eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CONTRACTTMPL_PVT dependencies on TAPI_DEV_KIT

Line 24: IF p_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR

20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttmpl_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;

Line 27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

23: BEGIN
24: IF p_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttmpl_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contracttmpl_rec.contract_type_id IS NULL
31: THEN

Line 29: ELSIF p_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM OR

25: p_contracttmpl_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contracttmpl_rec.contract_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;

Line 32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_type_id');

28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contracttmpl_rec.contract_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttmpl_rec.duration IS NULL
36: THEN

Line 34: ELSIF p_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM OR

30: p_contracttmpl_rec.contract_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttmpl_rec.duration IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'duration');
38: l_return_status := FND_API.G_RET_STS_ERROR;

Line 37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'duration');

33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttmpl_rec.duration IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'duration');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contracttmpl_rec.period_code IS NULL
41: THEN

Line 39: ELSIF p_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR OR

35: p_contracttmpl_rec.duration IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'duration');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contracttmpl_rec.period_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'period_code');
43: l_return_status := FND_API.G_RET_STS_ERROR;

Line 42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'period_code');

38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contracttmpl_rec.period_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'period_code');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttmpl_rec.price_list_id IS NULL
46: THEN

Line 44: ELSIF p_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM OR

40: p_contracttmpl_rec.period_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'period_code');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttmpl_rec.price_list_id IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'price_list_id');
48: l_return_status := FND_API.G_RET_STS_ERROR;

Line 47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'price_list_id');

43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttmpl_rec.price_list_id IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'price_list_id');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
50: p_contracttmpl_rec.currency_code IS NULL
51: THEN

Line 49: ELSIF p_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR

45: p_contracttmpl_rec.price_list_id IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'price_list_id');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
50: p_contracttmpl_rec.currency_code IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
53: l_return_status := FND_API.G_RET_STS_ERROR;

Line 52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');

48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
50: p_contracttmpl_rec.currency_code IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_contracttmpl_rec.terms_id IS NULL
56: THEN

Line 54: ELSIF p_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM OR

50: p_contracttmpl_rec.currency_code IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_contracttmpl_rec.terms_id IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'terms_id');
58: l_return_status := FND_API.G_RET_STS_ERROR;

Line 57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'terms_id');

53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_contracttmpl_rec.terms_id IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'terms_id');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
60: p_contracttmpl_rec.last_update_date IS NULL
61: THEN

Line 59: ELSIF p_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR

55: p_contracttmpl_rec.terms_id IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'terms_id');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
60: p_contracttmpl_rec.last_update_date IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
63: l_return_status := FND_API.G_RET_STS_ERROR;

Line 62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
60: p_contracttmpl_rec.last_update_date IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contracttmpl_rec.last_updated_by IS NULL
66: THEN

Line 64: ELSIF p_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR

60: p_contracttmpl_rec.last_update_date IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contracttmpl_rec.last_updated_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;

Line 67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');

63: l_return_status := FND_API.G_RET_STS_ERROR;
64: ELSIF p_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
65: p_contracttmpl_rec.last_updated_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contracttmpl_rec.creation_date IS NULL
71: THEN

Line 69: ELSIF p_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR

65: p_contracttmpl_rec.last_updated_by IS NULL
66: THEN
67: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contracttmpl_rec.creation_date IS NULL
71: THEN
72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
73: l_return_status := FND_API.G_RET_STS_ERROR;

Line 72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');

68: l_return_status := FND_API.G_RET_STS_ERROR;
69: ELSIF p_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
70: p_contracttmpl_rec.creation_date IS NULL
71: THEN
72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
73: l_return_status := FND_API.G_RET_STS_ERROR;
74: ELSIF p_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
75: p_contracttmpl_rec.created_by IS NULL
76: THEN

Line 74: ELSIF p_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR

70: p_contracttmpl_rec.creation_date IS NULL
71: THEN
72: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
73: l_return_status := FND_API.G_RET_STS_ERROR;
74: ELSIF p_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
75: p_contracttmpl_rec.created_by IS NULL
76: THEN
77: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
78: l_return_status := FND_API.G_RET_STS_ERROR;

Line 77: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');

73: l_return_status := FND_API.G_RET_STS_ERROR;
74: ELSIF p_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
75: p_contracttmpl_rec.created_by IS NULL
76: THEN
77: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
78: l_return_status := FND_API.G_RET_STS_ERROR;
79: ELSIF p_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
80: p_contracttmpl_rec.start_date_active IS NULL
81: THEN

Line 79: ELSIF p_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE OR

75: p_contracttmpl_rec.created_by IS NULL
76: THEN
77: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
78: l_return_status := FND_API.G_RET_STS_ERROR;
79: ELSIF p_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
80: p_contracttmpl_rec.start_date_active IS NULL
81: THEN
82: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'start_date_active');
83: l_return_status := FND_API.G_RET_STS_ERROR;

Line 82: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'start_date_active');

78: l_return_status := FND_API.G_RET_STS_ERROR;
79: ELSIF p_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
80: p_contracttmpl_rec.start_date_active IS NULL
81: THEN
82: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'start_date_active');
83: l_return_status := FND_API.G_RET_STS_ERROR;
84: ELSIF p_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
85: p_contracttmpl_rec.end_date_active IS NULL
86: THEN

Line 84: ELSIF p_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE OR

80: p_contracttmpl_rec.start_date_active IS NULL
81: THEN
82: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'start_date_active');
83: l_return_status := FND_API.G_RET_STS_ERROR;
84: ELSIF p_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
85: p_contracttmpl_rec.end_date_active IS NULL
86: THEN
87: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'end_date_active');
88: l_return_status := FND_API.G_RET_STS_ERROR;

Line 87: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'end_date_active');

83: l_return_status := FND_API.G_RET_STS_ERROR;
84: ELSIF p_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE OR
85: p_contracttmpl_rec.end_date_active IS NULL
86: THEN
87: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'end_date_active');
88: l_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90: RETURN(l_return_status);
91: END Validate_Item_Attributes;

Line 135: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TYPE_ID');

131: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
132: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
133: CLOSE cs_contract_types_pk_csr;
134: IF (l_row_notfound) THEN
135: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TYPE_ID');
136: RAISE item_not_found_error;
137: END IF;
138: END IF;
139: RETURN (l_return_status);

Line 262: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

258: END migrate;
259: PROCEDURE insert_row
260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
263: p_validation_level IN NUMBER,
264: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
265: x_return_status OUT VARCHAR2,
266: x_msg_count OUT NUMBER,

Line 264: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

260: (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
263: p_validation_level IN NUMBER,
264: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
265: x_return_status OUT VARCHAR2,
266: x_msg_count OUT NUMBER,
267: x_msg_data OUT VARCHAR2,
268: p_contracttmpl_rec IN ContractTmpl_Rec_Type := G_MISS_CONTRACTTMPL_REC,

Line 277: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

273: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
274: l_contracttmpl_rec ContractTmpl_Rec_Type;
275: l_def_contracttmpl_rec ContractTmpl_Rec_Type;
276: BEGIN
277: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
278: G_PKG_NAME,
279: l_api_version,
280: p_api_version,
281: p_init_msg_list,

Line 426: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

422: l_def_contracttmpl_rec.object_version_number);
423: -- Set OUT values
424: x_contract_template_id := l_def_contracttmpl_rec.contract_template_id;
425: x_object_version_number := l_def_contracttmpl_rec.OBJECT_VERSION_NUMBER;
426: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
430: (

Line 429: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

425: x_object_version_number := l_def_contracttmpl_rec.OBJECT_VERSION_NUMBER;
426: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
430: (
431: l_api_name,
432: G_PKG_NAME,
433: 'FND_API.G_RET_STS_ERROR',

Line 440: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

436: '_Pvt'
437: );
438: APP_EXCEPTION.RAISE_EXCEPTION;
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
441: (
442: l_api_name,
443: G_PKG_NAME,
444: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 450: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

446: x_msg_data,
447: '_Pvt'
448: );
449: APP_EXCEPTION.RAISE_EXCEPTION;
450: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
451: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
452: (
453: l_api_name,
454: G_PKG_NAME,

Line 451: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

447: '_Pvt'
448: );
449: APP_EXCEPTION.RAISE_EXCEPTION;
450: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
451: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
452: (
453: l_api_name,
454: G_PKG_NAME,
455: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 455: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

451: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
452: (
453: l_api_name,
454: G_PKG_NAME,
455: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
456: x_msg_count,
457: x_msg_data,
458: '_Pvt'
459: );

Line 465: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

461: END insert_row;
462: PROCEDURE insert_row
463: (
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
466: p_validation_level IN NUMBER,
467: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
468: x_return_status OUT VARCHAR2,
469: x_msg_count OUT NUMBER,

Line 467: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

463: (
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
466: p_validation_level IN NUMBER,
467: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
468: x_return_status OUT VARCHAR2,
469: x_msg_count OUT NUMBER,
470: x_msg_data OUT VARCHAR2,
471: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := NULL,

Line 525: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

521: l_api_version CONSTANT NUMBER := 1;
522: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
523: l_contracttmpl_rec ContractTmpl_Rec_Type;
524: BEGIN
525: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
526: G_PKG_NAME,
527: l_api_version,
528: p_api_version,
529: p_init_msg_list,

Line 596: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

592: l_contracttmpl_rec,
593: x_contract_template_id,
594: x_object_version_number
595: );
596: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
600: (

Line 599: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

595: );
596: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
600: (
601: l_api_name,
602: G_PKG_NAME,
603: 'FND_API.G_RET_STS_ERROR',

Line 610: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

606: '_Pvt'
607: );
608: APP_EXCEPTION.RAISE_EXCEPTION;
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
611: (
612: l_api_name,
613: G_PKG_NAME,
614: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 620: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

616: x_msg_data,
617: '_Pvt'
618: );
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
621: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
622: (
623: l_api_name,
624: G_PKG_NAME,

Line 621: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

617: '_Pvt'
618: );
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
621: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
622: (
623: l_api_name,
624: G_PKG_NAME,
625: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 625: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

621: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
622: (
623: l_api_name,
624: G_PKG_NAME,
625: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
626: x_msg_count,
627: x_msg_data,
628: '_Pvt'
629: );

Line 635: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

631: END insert_row;
632: Procedure lock_row
633: (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
636: p_validation_level IN NUMBER,
637: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
638: x_return_status OUT VARCHAR2,
639: x_msg_count OUT NUMBER,

Line 637: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

633: (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
636: p_validation_level IN NUMBER,
637: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
638: x_return_status OUT VARCHAR2,
639: x_msg_count OUT NUMBER,
640: x_msg_data OUT VARCHAR2,
641: p_contract_template_id IN NUMBER,

Line 667: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

663: lc_object_version_number CS_CONTRACT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
664: l_row_notfound BOOLEAN := FALSE;
665: lc_row_notfound BOOLEAN := FALSE;
666: BEGIN
667: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
668: G_PKG_NAME,
669: l_api_version,
670: p_api_version,
671: p_init_msg_list,

Line 689: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

685: WHEN E_Resource_Busy THEN
686: IF (lock_csr%ISOPEN) THEN
687: CLOSE lock_csr;
688: END IF;
689: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
690: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
691: END;
692:
693: IF ( l_row_notfound ) THEN

Line 700: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

696: lc_row_notfound := lchk_csr%NOTFOUND;
697: CLOSE lchk_csr;
698: END IF;
699: IF (lc_row_notfound) THEN
700: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
701: RAISE FND_API.G_EXC_ERROR;
702: ELSIF lc_object_version_number > p_object_version_number THEN
703: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
704: RAISE FND_API.G_EXC_ERROR;

Line 703: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

699: IF (lc_row_notfound) THEN
700: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
701: RAISE FND_API.G_EXC_ERROR;
702: ELSIF lc_object_version_number > p_object_version_number THEN
703: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
704: RAISE FND_API.G_EXC_ERROR;
705: ELSIF lc_object_version_number <> p_object_version_number THEN
706: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
707: RAISE FND_API.G_EXC_ERROR;

Line 706: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

702: ELSIF lc_object_version_number > p_object_version_number THEN
703: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
704: RAISE FND_API.G_EXC_ERROR;
705: ELSIF lc_object_version_number <> p_object_version_number THEN
706: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
707: RAISE FND_API.G_EXC_ERROR;
708: ELSIF lc_object_version_number = -1 THEN
709: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
710: RAISE FND_API.G_EXC_ERROR;

Line 709: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

705: ELSIF lc_object_version_number <> p_object_version_number THEN
706: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
707: RAISE FND_API.G_EXC_ERROR;
708: ELSIF lc_object_version_number = -1 THEN
709: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
713: EXCEPTION

Line 712: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

708: ELSIF lc_object_version_number = -1 THEN
709: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
716: (

Line 715: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

711: END IF;
712: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
716: (
717: l_api_name,
718: G_PKG_NAME,
719: 'FND_API.G_RET_STS_ERROR',

Line 726: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

722: '_Pvt'
723: );
724: APP_EXCEPTION.RAISE_EXCEPTION;
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
727: (
728: l_api_name,
729: G_PKG_NAME,
730: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 736: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

732: x_msg_data,
733: '_Pvt'
734: );
735: APP_EXCEPTION.RAISE_EXCEPTION;
736: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
737: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
738: (
739: l_api_name,
740: G_PKG_NAME,

Line 737: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

733: '_Pvt'
734: );
735: APP_EXCEPTION.RAISE_EXCEPTION;
736: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
737: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
738: (
739: l_api_name,
740: G_PKG_NAME,
741: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 741: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

737: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
738: (
739: l_api_name,
740: G_PKG_NAME,
741: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
742: x_msg_count,
743: x_msg_data,
744: '_Pvt'
745: );

Line 751: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

747: END lock_row;
748: Procedure update_row
749: (
750: p_api_version IN NUMBER,
751: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
752: p_validation_level IN NUMBER,
753: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
754: x_return_status OUT VARCHAR2,
755: x_msg_count OUT NUMBER,

Line 753: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

749: (
750: p_api_version IN NUMBER,
751: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
752: p_validation_level IN NUMBER,
753: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
754: x_return_status OUT VARCHAR2,
755: x_msg_count OUT NUMBER,
756: x_msg_data OUT VARCHAR2,
757: p_contracttmpl_val_rec IN ContractTmpl_Val_Rec_Type := G_MISS_CONTRACTTMPL_VAL_REC,

Line 785: IF (x_contracttmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)

781: CLOSE cs_contract_templates_pk_csr;
782: IF (l_row_notfound) THEN
783: l_return_status := FND_API.G_RET_STS_ERROR;
784: END IF;
785: IF (x_contracttmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)
786: THEN
787: x_contracttmpl_rec.contract_template_id := l_cs_contract_templates_pk.contract_template_id;
788: END IF;
789: IF (x_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)

Line 789: IF (x_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)

785: IF (x_contracttmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)
786: THEN
787: x_contracttmpl_rec.contract_template_id := l_cs_contract_templates_pk.contract_template_id;
788: END IF;
789: IF (x_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
790: THEN
791: x_contracttmpl_rec.name := l_cs_contract_templates_pk.name;
792: END IF;
793: IF (x_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 793: IF (x_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)

789: IF (x_contracttmpl_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
790: THEN
791: x_contracttmpl_rec.name := l_cs_contract_templates_pk.name;
792: END IF;
793: IF (x_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
794: THEN
795: x_contracttmpl_rec.contract_type_id := l_cs_contract_templates_pk.contract_type_id;
796: END IF;
797: IF (x_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)

Line 797: IF (x_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)

793: IF (x_contracttmpl_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
794: THEN
795: x_contracttmpl_rec.contract_type_id := l_cs_contract_templates_pk.contract_type_id;
796: END IF;
797: IF (x_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)
798: THEN
799: x_contracttmpl_rec.duration := l_cs_contract_templates_pk.duration;
800: END IF;
801: IF (x_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 801: IF (x_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR)

797: IF (x_contracttmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)
798: THEN
799: x_contracttmpl_rec.duration := l_cs_contract_templates_pk.duration;
800: END IF;
801: IF (x_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR)
802: THEN
803: x_contracttmpl_rec.period_code := l_cs_contract_templates_pk.period_code;
804: END IF;
805: IF (x_contracttmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)

Line 805: IF (x_contracttmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)

801: IF (x_contracttmpl_rec.period_code = TAPI_DEV_KIT.G_MISS_CHAR)
802: THEN
803: x_contracttmpl_rec.period_code := l_cs_contract_templates_pk.period_code;
804: END IF;
805: IF (x_contracttmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)
806: THEN
807: x_contracttmpl_rec.workflow := l_cs_contract_templates_pk.workflow;
808: END IF;
809: IF (x_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 809: IF (x_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)

805: IF (x_contracttmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)
806: THEN
807: x_contracttmpl_rec.workflow := l_cs_contract_templates_pk.workflow;
808: END IF;
809: IF (x_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
810: THEN
811: x_contracttmpl_rec.price_list_id := l_cs_contract_templates_pk.price_list_id;
812: END IF;
813: IF (x_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 813: IF (x_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)

809: IF (x_contracttmpl_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
810: THEN
811: x_contracttmpl_rec.price_list_id := l_cs_contract_templates_pk.price_list_id;
812: END IF;
813: IF (x_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
814: THEN
815: x_contracttmpl_rec.currency_code := l_cs_contract_templates_pk.currency_code;
816: END IF;
817: IF (x_contracttmpl_rec.conversion_type_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 817: IF (x_contracttmpl_rec.conversion_type_code = TAPI_DEV_KIT.G_MISS_CHAR)

813: IF (x_contracttmpl_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
814: THEN
815: x_contracttmpl_rec.currency_code := l_cs_contract_templates_pk.currency_code;
816: END IF;
817: IF (x_contracttmpl_rec.conversion_type_code = TAPI_DEV_KIT.G_MISS_CHAR)
818: THEN
819: x_contracttmpl_rec.conversion_type_code := l_cs_contract_templates_pk.conversion_type_code;
820: END IF;
821: IF (x_contracttmpl_rec.conversion_rate = TAPI_DEV_KIT.G_MISS_NUM)

Line 821: IF (x_contracttmpl_rec.conversion_rate = TAPI_DEV_KIT.G_MISS_NUM)

817: IF (x_contracttmpl_rec.conversion_type_code = TAPI_DEV_KIT.G_MISS_CHAR)
818: THEN
819: x_contracttmpl_rec.conversion_type_code := l_cs_contract_templates_pk.conversion_type_code;
820: END IF;
821: IF (x_contracttmpl_rec.conversion_rate = TAPI_DEV_KIT.G_MISS_NUM)
822: THEN
823: x_contracttmpl_rec.conversion_rate := l_cs_contract_templates_pk.conversion_rate;
824: END IF;
825: IF (x_contracttmpl_rec.conversion_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 825: IF (x_contracttmpl_rec.conversion_date = TAPI_DEV_KIT.G_MISS_DATE)

821: IF (x_contracttmpl_rec.conversion_rate = TAPI_DEV_KIT.G_MISS_NUM)
822: THEN
823: x_contracttmpl_rec.conversion_rate := l_cs_contract_templates_pk.conversion_rate;
824: END IF;
825: IF (x_contracttmpl_rec.conversion_date = TAPI_DEV_KIT.G_MISS_DATE)
826: THEN
827: x_contracttmpl_rec.conversion_date := l_cs_contract_templates_pk.conversion_date;
828: END IF;
829: IF (x_contracttmpl_rec.invoicing_rule_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 829: IF (x_contracttmpl_rec.invoicing_rule_id = TAPI_DEV_KIT.G_MISS_NUM)

825: IF (x_contracttmpl_rec.conversion_date = TAPI_DEV_KIT.G_MISS_DATE)
826: THEN
827: x_contracttmpl_rec.conversion_date := l_cs_contract_templates_pk.conversion_date;
828: END IF;
829: IF (x_contracttmpl_rec.invoicing_rule_id = TAPI_DEV_KIT.G_MISS_NUM)
830: THEN
831: x_contracttmpl_rec.invoicing_rule_id := l_cs_contract_templates_pk.invoicing_rule_id;
832: END IF;
833: IF (x_contracttmpl_rec.accounting_rule_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 833: IF (x_contracttmpl_rec.accounting_rule_id = TAPI_DEV_KIT.G_MISS_NUM)

829: IF (x_contracttmpl_rec.invoicing_rule_id = TAPI_DEV_KIT.G_MISS_NUM)
830: THEN
831: x_contracttmpl_rec.invoicing_rule_id := l_cs_contract_templates_pk.invoicing_rule_id;
832: END IF;
833: IF (x_contracttmpl_rec.accounting_rule_id = TAPI_DEV_KIT.G_MISS_NUM)
834: THEN
835: x_contracttmpl_rec.accounting_rule_id := l_cs_contract_templates_pk.accounting_rule_id;
836: END IF;
837: IF (x_contracttmpl_rec.billing_frequency_period = TAPI_DEV_KIT.G_MISS_CHAR)

Line 837: IF (x_contracttmpl_rec.billing_frequency_period = TAPI_DEV_KIT.G_MISS_CHAR)

833: IF (x_contracttmpl_rec.accounting_rule_id = TAPI_DEV_KIT.G_MISS_NUM)
834: THEN
835: x_contracttmpl_rec.accounting_rule_id := l_cs_contract_templates_pk.accounting_rule_id;
836: END IF;
837: IF (x_contracttmpl_rec.billing_frequency_period = TAPI_DEV_KIT.G_MISS_CHAR)
838: THEN
839: x_contracttmpl_rec.billing_frequency_period := l_cs_contract_templates_pk.billing_frequency_period;
840: END IF;
841: IF (x_contracttmpl_rec.create_sales_order = TAPI_DEV_KIT.G_MISS_CHAR)

Line 841: IF (x_contracttmpl_rec.create_sales_order = TAPI_DEV_KIT.G_MISS_CHAR)

837: IF (x_contracttmpl_rec.billing_frequency_period = TAPI_DEV_KIT.G_MISS_CHAR)
838: THEN
839: x_contracttmpl_rec.billing_frequency_period := l_cs_contract_templates_pk.billing_frequency_period;
840: END IF;
841: IF (x_contracttmpl_rec.create_sales_order = TAPI_DEV_KIT.G_MISS_CHAR)
842: THEN
843: x_contracttmpl_rec.create_sales_order := l_cs_contract_templates_pk.create_sales_order;
844: END IF;
845: IF (x_contracttmpl_rec.renewal_rule = TAPI_DEV_KIT.G_MISS_CHAR)

Line 845: IF (x_contracttmpl_rec.renewal_rule = TAPI_DEV_KIT.G_MISS_CHAR)

841: IF (x_contracttmpl_rec.create_sales_order = TAPI_DEV_KIT.G_MISS_CHAR)
842: THEN
843: x_contracttmpl_rec.create_sales_order := l_cs_contract_templates_pk.create_sales_order;
844: END IF;
845: IF (x_contracttmpl_rec.renewal_rule = TAPI_DEV_KIT.G_MISS_CHAR)
846: THEN
847: x_contracttmpl_rec.renewal_rule := l_cs_contract_templates_pk.renewal_rule;
848: END IF;
849: IF (x_contracttmpl_rec.termination_rule = TAPI_DEV_KIT.G_MISS_CHAR)

Line 849: IF (x_contracttmpl_rec.termination_rule = TAPI_DEV_KIT.G_MISS_CHAR)

845: IF (x_contracttmpl_rec.renewal_rule = TAPI_DEV_KIT.G_MISS_CHAR)
846: THEN
847: x_contracttmpl_rec.renewal_rule := l_cs_contract_templates_pk.renewal_rule;
848: END IF;
849: IF (x_contracttmpl_rec.termination_rule = TAPI_DEV_KIT.G_MISS_CHAR)
850: THEN
851: x_contracttmpl_rec.termination_rule := l_cs_contract_templates_pk.termination_rule;
852: END IF;
853: IF (x_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 853: IF (x_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM)

849: IF (x_contracttmpl_rec.termination_rule = TAPI_DEV_KIT.G_MISS_CHAR)
850: THEN
851: x_contracttmpl_rec.termination_rule := l_cs_contract_templates_pk.termination_rule;
852: END IF;
853: IF (x_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM)
854: THEN
855: x_contracttmpl_rec.terms_id := l_cs_contract_templates_pk.terms_id;
856: END IF;
857: IF (x_contracttmpl_rec.tax_handling = TAPI_DEV_KIT.G_MISS_CHAR)

Line 857: IF (x_contracttmpl_rec.tax_handling = TAPI_DEV_KIT.G_MISS_CHAR)

853: IF (x_contracttmpl_rec.terms_id = TAPI_DEV_KIT.G_MISS_NUM)
854: THEN
855: x_contracttmpl_rec.terms_id := l_cs_contract_templates_pk.terms_id;
856: END IF;
857: IF (x_contracttmpl_rec.tax_handling = TAPI_DEV_KIT.G_MISS_CHAR)
858: THEN
859: x_contracttmpl_rec.tax_handling := l_cs_contract_templates_pk.tax_handling;
860: END IF;
861: IF (x_contracttmpl_rec.tax_exempt_num = TAPI_DEV_KIT.G_MISS_CHAR)

Line 861: IF (x_contracttmpl_rec.tax_exempt_num = TAPI_DEV_KIT.G_MISS_CHAR)

857: IF (x_contracttmpl_rec.tax_handling = TAPI_DEV_KIT.G_MISS_CHAR)
858: THEN
859: x_contracttmpl_rec.tax_handling := l_cs_contract_templates_pk.tax_handling;
860: END IF;
861: IF (x_contracttmpl_rec.tax_exempt_num = TAPI_DEV_KIT.G_MISS_CHAR)
862: THEN
863: x_contracttmpl_rec.tax_exempt_num := l_cs_contract_templates_pk.tax_exempt_num;
864: END IF;
865: IF (x_contracttmpl_rec.tax_exempt_reason_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 865: IF (x_contracttmpl_rec.tax_exempt_reason_code = TAPI_DEV_KIT.G_MISS_CHAR)

861: IF (x_contracttmpl_rec.tax_exempt_num = TAPI_DEV_KIT.G_MISS_CHAR)
862: THEN
863: x_contracttmpl_rec.tax_exempt_num := l_cs_contract_templates_pk.tax_exempt_num;
864: END IF;
865: IF (x_contracttmpl_rec.tax_exempt_reason_code = TAPI_DEV_KIT.G_MISS_CHAR)
866: THEN
867: x_contracttmpl_rec.tax_exempt_reason_code := l_cs_contract_templates_pk.tax_exempt_reason_code;
868: END IF;
869: IF (x_contracttmpl_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)

Line 869: IF (x_contracttmpl_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)

865: IF (x_contracttmpl_rec.tax_exempt_reason_code = TAPI_DEV_KIT.G_MISS_CHAR)
866: THEN
867: x_contracttmpl_rec.tax_exempt_reason_code := l_cs_contract_templates_pk.tax_exempt_reason_code;
868: END IF;
869: IF (x_contracttmpl_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
870: THEN
871: x_contracttmpl_rec.contract_amount := l_cs_contract_templates_pk.contract_amount;
872: END IF;
873: IF (x_contracttmpl_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 873: IF (x_contracttmpl_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)

869: IF (x_contracttmpl_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
870: THEN
871: x_contracttmpl_rec.contract_amount := l_cs_contract_templates_pk.contract_amount;
872: END IF;
873: IF (x_contracttmpl_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
874: THEN
875: x_contracttmpl_rec.discount_id := l_cs_contract_templates_pk.discount_id;
876: END IF;
877: IF (x_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 877: IF (x_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

873: IF (x_contracttmpl_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
874: THEN
875: x_contracttmpl_rec.discount_id := l_cs_contract_templates_pk.discount_id;
876: END IF;
877: IF (x_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
878: THEN
879: x_contracttmpl_rec.last_update_date := l_cs_contract_templates_pk.last_update_date;
880: END IF;
881: IF (x_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 881: IF (x_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

877: IF (x_contracttmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
878: THEN
879: x_contracttmpl_rec.last_update_date := l_cs_contract_templates_pk.last_update_date;
880: END IF;
881: IF (x_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
882: THEN
883: x_contracttmpl_rec.last_updated_by := l_cs_contract_templates_pk.last_updated_by;
884: END IF;
885: IF (x_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 885: IF (x_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

881: IF (x_contracttmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
882: THEN
883: x_contracttmpl_rec.last_updated_by := l_cs_contract_templates_pk.last_updated_by;
884: END IF;
885: IF (x_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
886: THEN
887: x_contracttmpl_rec.creation_date := l_cs_contract_templates_pk.creation_date;
888: END IF;
889: IF (x_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 889: IF (x_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

885: IF (x_contracttmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
886: THEN
887: x_contracttmpl_rec.creation_date := l_cs_contract_templates_pk.creation_date;
888: END IF;
889: IF (x_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
890: THEN
891: x_contracttmpl_rec.created_by := l_cs_contract_templates_pk.created_by;
892: END IF;
893: IF (x_contracttmpl_rec.auto_renewal_flag = TAPI_DEV_KIT.G_MISS_CHAR)

Line 893: IF (x_contracttmpl_rec.auto_renewal_flag = TAPI_DEV_KIT.G_MISS_CHAR)

889: IF (x_contracttmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
890: THEN
891: x_contracttmpl_rec.created_by := l_cs_contract_templates_pk.created_by;
892: END IF;
893: IF (x_contracttmpl_rec.auto_renewal_flag = TAPI_DEV_KIT.G_MISS_CHAR)
894: THEN
895: x_contracttmpl_rec.auto_renewal_flag := l_cs_contract_templates_pk.auto_renewal_flag;
896: END IF;
897: IF (x_contracttmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

Line 897: IF (x_contracttmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

893: IF (x_contracttmpl_rec.auto_renewal_flag = TAPI_DEV_KIT.G_MISS_CHAR)
894: THEN
895: x_contracttmpl_rec.auto_renewal_flag := l_cs_contract_templates_pk.auto_renewal_flag;
896: END IF;
897: IF (x_contracttmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
898: THEN
899: x_contracttmpl_rec.last_update_login := l_cs_contract_templates_pk.last_update_login;
900: END IF;
901: IF (x_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 901: IF (x_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

897: IF (x_contracttmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
898: THEN
899: x_contracttmpl_rec.last_update_login := l_cs_contract_templates_pk.last_update_login;
900: END IF;
901: IF (x_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
902: THEN
903: x_contracttmpl_rec.start_date_active := l_cs_contract_templates_pk.start_date_active;
904: END IF;
905: IF (x_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 905: IF (x_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

901: IF (x_contracttmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
902: THEN
903: x_contracttmpl_rec.start_date_active := l_cs_contract_templates_pk.start_date_active;
904: END IF;
905: IF (x_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
906: THEN
907: x_contracttmpl_rec.end_date_active := l_cs_contract_templates_pk.end_date_active;
908: END IF;
909: IF (x_contracttmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 909: IF (x_contracttmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

905: IF (x_contracttmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
906: THEN
907: x_contracttmpl_rec.end_date_active := l_cs_contract_templates_pk.end_date_active;
908: END IF;
909: IF (x_contracttmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
910: THEN
911: x_contracttmpl_rec.attribute1 := l_cs_contract_templates_pk.attribute1;
912: END IF;
913: IF (x_contracttmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 913: IF (x_contracttmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

909: IF (x_contracttmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
910: THEN
911: x_contracttmpl_rec.attribute1 := l_cs_contract_templates_pk.attribute1;
912: END IF;
913: IF (x_contracttmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
914: THEN
915: x_contracttmpl_rec.attribute2 := l_cs_contract_templates_pk.attribute2;
916: END IF;
917: IF (x_contracttmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 917: IF (x_contracttmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

913: IF (x_contracttmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
914: THEN
915: x_contracttmpl_rec.attribute2 := l_cs_contract_templates_pk.attribute2;
916: END IF;
917: IF (x_contracttmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
918: THEN
919: x_contracttmpl_rec.attribute3 := l_cs_contract_templates_pk.attribute3;
920: END IF;
921: IF (x_contracttmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 921: IF (x_contracttmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

917: IF (x_contracttmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
918: THEN
919: x_contracttmpl_rec.attribute3 := l_cs_contract_templates_pk.attribute3;
920: END IF;
921: IF (x_contracttmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
922: THEN
923: x_contracttmpl_rec.attribute4 := l_cs_contract_templates_pk.attribute4;
924: END IF;
925: IF (x_contracttmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 925: IF (x_contracttmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

921: IF (x_contracttmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
922: THEN
923: x_contracttmpl_rec.attribute4 := l_cs_contract_templates_pk.attribute4;
924: END IF;
925: IF (x_contracttmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
926: THEN
927: x_contracttmpl_rec.attribute5 := l_cs_contract_templates_pk.attribute5;
928: END IF;
929: IF (x_contracttmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 929: IF (x_contracttmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

925: IF (x_contracttmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
926: THEN
927: x_contracttmpl_rec.attribute5 := l_cs_contract_templates_pk.attribute5;
928: END IF;
929: IF (x_contracttmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
930: THEN
931: x_contracttmpl_rec.attribute6 := l_cs_contract_templates_pk.attribute6;
932: END IF;
933: IF (x_contracttmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 933: IF (x_contracttmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

929: IF (x_contracttmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
930: THEN
931: x_contracttmpl_rec.attribute6 := l_cs_contract_templates_pk.attribute6;
932: END IF;
933: IF (x_contracttmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
934: THEN
935: x_contracttmpl_rec.attribute7 := l_cs_contract_templates_pk.attribute7;
936: END IF;
937: IF (x_contracttmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 937: IF (x_contracttmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

933: IF (x_contracttmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
934: THEN
935: x_contracttmpl_rec.attribute7 := l_cs_contract_templates_pk.attribute7;
936: END IF;
937: IF (x_contracttmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
938: THEN
939: x_contracttmpl_rec.attribute8 := l_cs_contract_templates_pk.attribute8;
940: END IF;
941: IF (x_contracttmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 941: IF (x_contracttmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

937: IF (x_contracttmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
938: THEN
939: x_contracttmpl_rec.attribute8 := l_cs_contract_templates_pk.attribute8;
940: END IF;
941: IF (x_contracttmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
942: THEN
943: x_contracttmpl_rec.attribute9 := l_cs_contract_templates_pk.attribute9;
944: END IF;
945: IF (x_contracttmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 945: IF (x_contracttmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

941: IF (x_contracttmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
942: THEN
943: x_contracttmpl_rec.attribute9 := l_cs_contract_templates_pk.attribute9;
944: END IF;
945: IF (x_contracttmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
946: THEN
947: x_contracttmpl_rec.attribute10 := l_cs_contract_templates_pk.attribute10;
948: END IF;
949: IF (x_contracttmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 949: IF (x_contracttmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

945: IF (x_contracttmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
946: THEN
947: x_contracttmpl_rec.attribute10 := l_cs_contract_templates_pk.attribute10;
948: END IF;
949: IF (x_contracttmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
950: THEN
951: x_contracttmpl_rec.attribute11 := l_cs_contract_templates_pk.attribute11;
952: END IF;
953: IF (x_contracttmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 953: IF (x_contracttmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

949: IF (x_contracttmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
950: THEN
951: x_contracttmpl_rec.attribute11 := l_cs_contract_templates_pk.attribute11;
952: END IF;
953: IF (x_contracttmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
954: THEN
955: x_contracttmpl_rec.attribute12 := l_cs_contract_templates_pk.attribute12;
956: END IF;
957: IF (x_contracttmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 957: IF (x_contracttmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

953: IF (x_contracttmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
954: THEN
955: x_contracttmpl_rec.attribute12 := l_cs_contract_templates_pk.attribute12;
956: END IF;
957: IF (x_contracttmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
958: THEN
959: x_contracttmpl_rec.attribute13 := l_cs_contract_templates_pk.attribute13;
960: END IF;
961: IF (x_contracttmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 961: IF (x_contracttmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

957: IF (x_contracttmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
958: THEN
959: x_contracttmpl_rec.attribute13 := l_cs_contract_templates_pk.attribute13;
960: END IF;
961: IF (x_contracttmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
962: THEN
963: x_contracttmpl_rec.attribute14 := l_cs_contract_templates_pk.attribute14;
964: END IF;
965: IF (x_contracttmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 965: IF (x_contracttmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

961: IF (x_contracttmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
962: THEN
963: x_contracttmpl_rec.attribute14 := l_cs_contract_templates_pk.attribute14;
964: END IF;
965: IF (x_contracttmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
966: THEN
967: x_contracttmpl_rec.attribute15 := l_cs_contract_templates_pk.attribute15;
968: END IF;
969: IF (x_contracttmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

Line 969: IF (x_contracttmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

965: IF (x_contracttmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
966: THEN
967: x_contracttmpl_rec.attribute15 := l_cs_contract_templates_pk.attribute15;
968: END IF;
969: IF (x_contracttmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
970: THEN
971: x_contracttmpl_rec.context := l_cs_contract_templates_pk.context;
972: END IF;
973: IF (x_contracttmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 973: IF (x_contracttmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

969: IF (x_contracttmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
970: THEN
971: x_contracttmpl_rec.context := l_cs_contract_templates_pk.context;
972: END IF;
973: IF (x_contracttmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
974: THEN
975: x_contracttmpl_rec.object_version_number := l_cs_contract_templates_pk.object_version_number;
976: END IF;
977: RETURN(l_return_status);

Line 980: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

976: END IF;
977: RETURN(l_return_status);
978: END populate_new_record;
979: BEGIN
980: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
981: G_PKG_NAME,
982: l_api_version,
983: p_api_version,
984: p_init_msg_list,

Line 1086: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1082: WHERE
1083: CONTRACT_TEMPLATE_ID = l_def_contracttmpl_rec.contract_template_id
1084: ;
1085: x_object_version_number := l_def_contracttmpl_rec.OBJECT_VERSION_NUMBER;
1086: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1090: (

Line 1089: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1085: x_object_version_number := l_def_contracttmpl_rec.OBJECT_VERSION_NUMBER;
1086: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1090: (
1091: l_api_name,
1092: G_PKG_NAME,
1093: 'FND_API.G_RET_STS_ERROR',

Line 1100: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1096: '_Pvt'
1097: );
1098: APP_EXCEPTION.RAISE_EXCEPTION;
1099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1100: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1101: (
1102: l_api_name,
1103: G_PKG_NAME,
1104: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1110: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1106: x_msg_data,
1107: '_Pvt'
1108: );
1109: APP_EXCEPTION.RAISE_EXCEPTION;
1110: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1111: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,

Line 1111: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1107: '_Pvt'
1108: );
1109: APP_EXCEPTION.RAISE_EXCEPTION;
1110: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1111: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,
1115: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1115: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1111: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,
1115: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1116: x_msg_count,
1117: x_msg_data,
1118: '_Pvt'
1119: );

Line 1125: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1121: END update_row;
1122: Procedure update_row
1123: (
1124: p_api_version IN NUMBER,
1125: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1126: p_validation_level IN NUMBER,
1127: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1128: x_return_status OUT VARCHAR2,
1129: x_msg_count OUT NUMBER,

Line 1127: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1123: (
1124: p_api_version IN NUMBER,
1125: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1126: p_validation_level IN NUMBER,
1127: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1128: x_return_status OUT VARCHAR2,
1129: x_msg_count OUT NUMBER,
1130: x_msg_data OUT VARCHAR2,
1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1127: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1128: x_return_status OUT VARCHAR2,
1129: x_msg_count OUT NUMBER,
1130: x_msg_data OUT VARCHAR2,
1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1128: x_return_status OUT VARCHAR2,
1129: x_msg_count OUT NUMBER,
1130: x_msg_data OUT VARCHAR2,
1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1129: x_msg_count OUT NUMBER,
1130: x_msg_data OUT VARCHAR2,
1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1130: x_msg_data OUT VARCHAR2,
1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1131: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1132: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1133: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1134: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1135: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1136: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1137: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1138: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1139: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1140: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1141: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1142: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1143: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1144: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1145: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1146: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1147: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1148: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1149: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1150: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1151: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1152: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1153: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1154: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1155: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1165: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1166: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1167: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1168: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1169: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1170: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1171: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: x_object_version_number OUT NUMBER) IS

Line 1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1172: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: x_object_version_number OUT NUMBER) IS
1180: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1173: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: x_object_version_number OUT NUMBER) IS
1180: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1181: l_api_version CONSTANT NUMBER := 1;

Line 1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1174: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: x_object_version_number OUT NUMBER) IS
1180: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1181: l_api_version CONSTANT NUMBER := 1;
1182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1185: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1181: l_api_version CONSTANT NUMBER := 1;
1182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1183: l_contracttmpl_rec ContractTmpl_Val_Rec_Type;
1184: BEGIN
1185: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1186: G_PKG_NAME,
1187: l_api_version,
1188: p_api_version,
1189: p_init_msg_list,

Line 1256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1252: x_msg_data,
1253: l_contracttmpl_rec,
1254: x_object_version_number
1255: );
1256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1260: (

Line 1259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1255: );
1256: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1260: (
1261: l_api_name,
1262: G_PKG_NAME,
1263: 'FND_API.G_RET_STS_ERROR',

Line 1270: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1266: '_Pvt'
1267: );
1268: APP_EXCEPTION.RAISE_EXCEPTION;
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,
1274: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1276: x_msg_data,
1277: '_Pvt'
1278: );
1279: APP_EXCEPTION.RAISE_EXCEPTION;
1280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,

Line 1281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1277: '_Pvt'
1278: );
1279: APP_EXCEPTION.RAISE_EXCEPTION;
1280: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,
1285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1281: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,
1285: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1286: x_msg_count,
1287: x_msg_data,
1288: '_Pvt'
1289: );

Line 1295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1291: END update_row;
1292: Procedure delete_row
1293: (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1296: p_validation_level IN NUMBER,
1297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1298: x_return_status OUT VARCHAR2,
1299: x_msg_count OUT NUMBER,

Line 1297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1293: (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1296: p_validation_level IN NUMBER,
1297: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1298: x_return_status OUT VARCHAR2,
1299: x_msg_count OUT NUMBER,
1300: x_msg_data OUT VARCHAR2,
1301: p_contract_template_id IN NUMBER) IS

Line 1306: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1302: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1303: l_api_version CONSTANT NUMBER := 1;
1304: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1305: BEGIN
1306: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1307: G_PKG_NAME,
1308: l_api_version,
1309: p_api_version,
1310: p_init_msg_list,

Line 1322: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1318: DELETE FROM CS_CONTRACT_TEMPLATES
1319: WHERE
1320: CONTRACT_TEMPLATE_ID = p_contract_template_id
1321: ;
1322: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1326: (

Line 1325: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1321: ;
1322: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'FND_API.G_RET_STS_ERROR',

Line 1336: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1332: '_Pvt'
1333: );
1334: APP_EXCEPTION.RAISE_EXCEPTION;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1337: (
1338: l_api_name,
1339: G_PKG_NAME,
1340: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1346: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1342: x_msg_data,
1343: '_Pvt'
1344: );
1345: APP_EXCEPTION.RAISE_EXCEPTION;
1346: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1347: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1348: (
1349: l_api_name,
1350: G_PKG_NAME,

Line 1347: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1343: '_Pvt'
1344: );
1345: APP_EXCEPTION.RAISE_EXCEPTION;
1346: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1347: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1348: (
1349: l_api_name,
1350: G_PKG_NAME,
1351: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1351: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1347: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1348: (
1349: l_api_name,
1350: G_PKG_NAME,
1351: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1352: x_msg_count,
1353: x_msg_data,
1354: '_Pvt'
1355: );

Line 1361: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1357: END delete_row;
1358: PROCEDURE validate_row
1359: (
1360: p_api_version IN NUMBER,
1361: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1362: p_validation_level IN NUMBER,
1363: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1364: x_return_status OUT VARCHAR2,
1365: x_msg_count OUT NUMBER,

Line 1363: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1359: (
1360: p_api_version IN NUMBER,
1361: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1362: p_validation_level IN NUMBER,
1363: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1364: x_return_status OUT VARCHAR2,
1365: x_msg_count OUT NUMBER,
1366: x_msg_data OUT VARCHAR2,
1367: p_contracttmpl_val_rec IN ContractTmpl_Val_Rec_Type := G_MISS_CONTRACTTMPL_VAL_REC) IS

Line 1374: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1370: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1371: l_contracttmpl_rec ContractTmpl_Rec_Type;
1372: l_def_contracttmpl_rec ContractTmpl_Rec_Type;
1373: BEGIN
1374: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1375: G_PKG_NAME,
1376: l_api_version,
1377: p_api_version,
1378: p_init_msg_list,

Line 1408: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1405: RAISE FND_API.G_EXC_ERROR;
1406: END IF;
1407: END IF;
1408: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1409: EXCEPTION
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1412: (

Line 1411: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1407: END IF;
1408: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1409: EXCEPTION
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,
1415: 'FND_API.G_RET_STS_ERROR',

Line 1422: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1418: '_Pvt'
1419: );
1420: APP_EXCEPTION.RAISE_EXCEPTION;
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1432: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1428: x_msg_data,
1429: '_Pvt'
1430: );
1431: APP_EXCEPTION.RAISE_EXCEPTION;
1432: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1433: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1434: (
1435: l_api_name,
1436: G_PKG_NAME,

Line 1433: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1429: '_Pvt'
1430: );
1431: APP_EXCEPTION.RAISE_EXCEPTION;
1432: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1433: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1434: (
1435: l_api_name,
1436: G_PKG_NAME,
1437: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1437: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1433: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1434: (
1435: l_api_name,
1436: G_PKG_NAME,
1437: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1438: x_msg_count,
1439: x_msg_data,
1440: '_Pvt'
1441: );

Line 1447: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1443: END validate_row;
1444: PROCEDURE validate_row
1445: (
1446: p_api_version IN NUMBER,
1447: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1448: p_validation_level IN NUMBER,
1449: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1450: x_return_status OUT VARCHAR2,
1451: x_msg_count OUT NUMBER,

Line 1449: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1445: (
1446: p_api_version IN NUMBER,
1447: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1448: p_validation_level IN NUMBER,
1449: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1450: x_return_status OUT VARCHAR2,
1451: x_msg_count OUT NUMBER,
1452: x_msg_data OUT VARCHAR2,
1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1449: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1450: x_return_status OUT VARCHAR2,
1451: x_msg_count OUT NUMBER,
1452: x_msg_data OUT VARCHAR2,
1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1450: x_return_status OUT VARCHAR2,
1451: x_msg_count OUT NUMBER,
1452: x_msg_data OUT VARCHAR2,
1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1451: x_msg_count OUT NUMBER,
1452: x_msg_data OUT VARCHAR2,
1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1452: x_msg_data OUT VARCHAR2,
1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1453: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1454: p_name IN CS_CONTRACT_TEMPLATES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1455: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1456: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1457: p_period_code IN CS_CONTRACT_TEMPLATES.PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1458: p_workflow IN CS_CONTRACT_TEMPLATES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1459: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1460: p_currency_code IN CS_CONTRACT_TEMPLATES.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1461: p_conversion_type_code IN CS_CONTRACT_TEMPLATES.CONVERSION_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1462: p_conversion_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1463: p_conversion_date IN CS_CONTRACT_TEMPLATES.CONVERSION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1464: p_invoicing_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1465: p_accounting_rule_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1466: p_billing_frequency_period IN CS_CONTRACT_TEMPLATES.BILLING_FREQUENCY_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1467: p_create_sales_order IN CS_CONTRACT_TEMPLATES.CREATE_SALES_ORDER%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1468: p_renewal_rule IN CS_CONTRACT_TEMPLATES.RENEWAL_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1469: p_termination_rule IN CS_CONTRACT_TEMPLATES.TERMINATION_RULE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1470: p_terms_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1471: p_tax_handling IN CS_CONTRACT_TEMPLATES.TAX_HANDLING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1472: p_tax_exempt_num IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1473: p_tax_exempt_reason_code IN CS_CONTRACT_TEMPLATES.TAX_EXEMPT_REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1474: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1475: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1476: p_last_update_date IN CS_CONTRACT_TEMPLATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1477: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1487: p_attribute4 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1488: p_attribute5 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1489: p_attribute6 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1490: p_attribute7 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1491: p_attribute8 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1492: p_attribute9 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1493: p_attribute10 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1501: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1494: p_attribute11 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1501: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1502: l_api_version CONSTANT NUMBER := 1;

Line 1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1495: p_attribute12 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1501: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1502: l_api_version CONSTANT NUMBER := 1;
1503: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

1496: p_attribute13 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1497: p_attribute14 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1498: p_attribute15 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1499: p_context IN CS_CONTRACT_TEMPLATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1500: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1501: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1502: l_api_version CONSTANT NUMBER := 1;
1503: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1504: l_contracttmpl_rec ContractTmpl_Val_Rec_Type;

Line 1506: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1502: l_api_version CONSTANT NUMBER := 1;
1503: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1504: l_contracttmpl_rec ContractTmpl_Val_Rec_Type;
1505: BEGIN
1506: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1507: G_PKG_NAME,
1508: l_api_version,
1509: p_api_version,
1510: p_init_msg_list,

Line 1576: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1572: x_msg_count,
1573: x_msg_data,
1574: l_contracttmpl_rec
1575: );
1576: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1577: EXCEPTION
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1580: (

Line 1579: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1575: );
1576: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1577: EXCEPTION
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1580: (
1581: l_api_name,
1582: G_PKG_NAME,
1583: 'FND_API.G_RET_STS_ERROR',

Line 1590: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1586: '_Pvt'
1587: );
1588: APP_EXCEPTION.RAISE_EXCEPTION;
1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1590: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1591: (
1592: l_api_name,
1593: G_PKG_NAME,
1594: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1600: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1596: x_msg_data,
1597: '_Pvt'
1598: );
1599: APP_EXCEPTION.RAISE_EXCEPTION;
1600: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1601: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1602: (
1603: l_api_name,
1604: G_PKG_NAME,

Line 1601: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1597: '_Pvt'
1598: );
1599: APP_EXCEPTION.RAISE_EXCEPTION;
1600: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1601: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1602: (
1603: l_api_name,
1604: G_PKG_NAME,
1605: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1605: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1601: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1602: (
1603: l_api_name,
1604: G_PKG_NAME,
1605: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1606: x_msg_count,
1607: x_msg_data,
1608: '_Pvt'
1609: );