3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ajl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ajl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE ajl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
6: TYPE ajl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
8: adj_id NUMBER := OKC_API.G_MISS_NUM,
9: til_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
10: tld_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
11: psl_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
12: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
13: object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: org_id NUMBER := OKC_API.G_MISS_NUM,
14: amount NUMBER := OKC_API.G_MISS_NUM,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: org_id NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE_CATEGORY%TYPE,
15: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: org_id NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE_CATEGORY%TYPE,
23: attribute1 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE1%TYPE,
16: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: org_id NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE_CATEGORY%TYPE,
23: attribute1 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE1%TYPE,
24: attribute2 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE2%TYPE,
17: request_id NUMBER := OKC_API.G_MISS_NUM,
18: program_application_id NUMBER := OKC_API.G_MISS_NUM,
19: program_id NUMBER := OKC_API.G_MISS_NUM,
20: program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: org_id NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE_CATEGORY%TYPE,
23: attribute1 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE1%TYPE,
24: attribute2 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE2%TYPE,
25: attribute3 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE3%TYPE,
35: attribute13 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE13%TYPE,
36: attribute14 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE14%TYPE,
37: attribute15 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE15%TYPE,
38: created_by OKL_TXL_ADJSTS_LNS_B.CREATED_BY%TYPE,
39: creation_date OKL_TXL_ADJSTS_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_updated_by OKL_TXL_ADJSTS_LNS_B.LAST_UPDATED_BY%TYPE,
41: last_update_date OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_login OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_LOGIN%TYPE,
43: --Bug 6316320 dpsingh start
37: attribute15 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE15%TYPE,
38: created_by OKL_TXL_ADJSTS_LNS_B.CREATED_BY%TYPE,
39: creation_date OKL_TXL_ADJSTS_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: last_updated_by OKL_TXL_ADJSTS_LNS_B.LAST_UPDATED_BY%TYPE,
41: last_update_date OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42: last_update_login OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_LOGIN%TYPE,
43: --Bug 6316320 dpsingh start
44: khr_id NUMBER := OKL_API.G_MISS_NUM,
45: sty_id NUMBER := OKL_API.G_MISS_NUM,
49: g_miss_ajl_rec ajl_rec_type;
50: TYPE ajl_tbl_type IS TABLE OF ajl_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE okl_txl_adjsts_lns_tl_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: language OKL_TXL_ADJSTS_LNS_TL.LANGUAGE%TYPE,
55: source_lang OKL_TXL_ADJSTS_LNS_TL.SOURCE_LANG%TYPE,
56: sfwt_flag OKL_TXL_ADJSTS_LNS_TL.SFWT_FLAG%TYPE,
57: created_by OKL_TXL_ADJSTS_LNS_TL.CREATED_BY%TYPE,
54: language OKL_TXL_ADJSTS_LNS_TL.LANGUAGE%TYPE,
55: source_lang OKL_TXL_ADJSTS_LNS_TL.SOURCE_LANG%TYPE,
56: sfwt_flag OKL_TXL_ADJSTS_LNS_TL.SFWT_FLAG%TYPE,
57: created_by OKL_TXL_ADJSTS_LNS_TL.CREATED_BY%TYPE,
58: creation_date OKL_TXL_ADJSTS_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATED_BY%TYPE,
60: last_update_date OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_LOGIN%TYPE);
62: GMissOklTxlAdjstsLnsTlRec okl_txl_adjsts_lns_tl_rec_type;
56: sfwt_flag OKL_TXL_ADJSTS_LNS_TL.SFWT_FLAG%TYPE,
57: created_by OKL_TXL_ADJSTS_LNS_TL.CREATED_BY%TYPE,
58: creation_date OKL_TXL_ADJSTS_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATED_BY%TYPE,
60: last_update_date OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_LOGIN%TYPE);
62: GMissOklTxlAdjstsLnsTlRec okl_txl_adjsts_lns_tl_rec_type;
63: TYPE okl_txl_adjsts_lns_tl_tbl_type IS TABLE OF okl_txl_adjsts_lns_tl_rec_type
64: INDEX BY BINARY_INTEGER;
62: GMissOklTxlAdjstsLnsTlRec okl_txl_adjsts_lns_tl_rec_type;
63: TYPE okl_txl_adjsts_lns_tl_tbl_type IS TABLE OF okl_txl_adjsts_lns_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE ajlv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TXL_ADJSTS_LNS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
65: TYPE ajlv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TXL_ADJSTS_LNS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TXL_ADJSTS_LNS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TXL_ADJSTS_LNS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
68: sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
69: adj_id NUMBER := OKC_API.G_MISS_NUM,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
77: attribute_category OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE_CATEGORY%TYPE,
70: til_id NUMBER := OKC_API.G_MISS_NUM,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
77: attribute_category OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE_CATEGORY%TYPE,
78: attribute1 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE1%TYPE,
71: tld_id NUMBER := OKC_API.G_MISS_NUM,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
77: attribute_category OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE_CATEGORY%TYPE,
78: attribute1 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE1%TYPE,
79: attribute2 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE2%TYPE,
72: code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73: psl_id NUMBER := OKC_API.G_MISS_NUM,
74: amount NUMBER := OKC_API.G_MISS_NUM,
75: check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76: receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
77: attribute_category OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE_CATEGORY%TYPE,
78: attribute1 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE1%TYPE,
79: attribute2 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE2%TYPE,
80: attribute3 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE3%TYPE,
89: attribute12 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE12%TYPE,
90: attribute13 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE13%TYPE,
91: attribute14 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE14%TYPE,
92: attribute15 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE15%TYPE,
93: request_id NUMBER := OKC_API.G_MISS_NUM,
94: program_application_id NUMBER := OKC_API.G_MISS_NUM,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
90: attribute13 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE13%TYPE,
91: attribute14 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE14%TYPE,
92: attribute15 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE15%TYPE,
93: request_id NUMBER := OKC_API.G_MISS_NUM,
94: program_application_id NUMBER := OKC_API.G_MISS_NUM,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
91: attribute14 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE14%TYPE,
92: attribute15 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE15%TYPE,
93: request_id NUMBER := OKC_API.G_MISS_NUM,
94: program_application_id NUMBER := OKC_API.G_MISS_NUM,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99: creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: attribute15 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE15%TYPE,
93: request_id NUMBER := OKC_API.G_MISS_NUM,
94: program_application_id NUMBER := OKC_API.G_MISS_NUM,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99: creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by OKL_TXL_ADJSTS_LNS_V.LAST_UPDATED_BY%TYPE,
93: request_id NUMBER := OKC_API.G_MISS_NUM,
94: program_application_id NUMBER := OKC_API.G_MISS_NUM,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99: creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by OKL_TXL_ADJSTS_LNS_V.LAST_UPDATED_BY%TYPE,
101: last_update_date OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95: program_id NUMBER := OKC_API.G_MISS_NUM,
96: program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99: creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by OKL_TXL_ADJSTS_LNS_V.LAST_UPDATED_BY%TYPE,
101: last_update_date OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_LOGIN%TYPE,
103: --Bug 6316320 dpsingh start
97: org_id NUMBER := OKC_API.G_MISS_NUM,
98: created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99: creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: last_updated_by OKL_TXL_ADJSTS_LNS_V.LAST_UPDATED_BY%TYPE,
101: last_update_date OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_update_login OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_LOGIN%TYPE,
103: --Bug 6316320 dpsingh start
104: khr_id NUMBER := OKL_API.G_MISS_NUM,
105: sty_id NUMBER := OKL_API.G_MISS_NUM,
111: INDEX BY BINARY_INTEGER;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
128: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AJL_PVT';
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
128: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AJL_PVT';
129: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
130: ---------------------------------------------------------------------------
131: -- Procedures and Functions
132: ---------------------------------------------------------------------------
133:
136: PROCEDURE api_copy;
137: PROCEDURE add_language;
138: PROCEDURE insert_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_ajlv_rec IN ajlv_rec_type,
145: x_ajlv_rec OUT NOCOPY ajlv_rec_type);
146:
147: PROCEDURE insert_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_ajlv_tbl IN ajlv_tbl_type,
154: x_ajlv_tbl OUT NOCOPY ajlv_tbl_type);
155:
156: PROCEDURE lock_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_ajlv_rec IN ajlv_rec_type);
162: p_ajlv_rec IN ajlv_rec_type);
163:
164: PROCEDURE lock_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_ajlv_tbl IN ajlv_tbl_type);
170: p_ajlv_tbl IN ajlv_tbl_type);
171:
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_ajlv_rec IN ajlv_rec_type,
179: x_ajlv_rec OUT NOCOPY ajlv_rec_type);
180:
181: PROCEDURE update_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_ajlv_tbl IN ajlv_tbl_type,
188: x_ajlv_tbl OUT NOCOPY ajlv_tbl_type);
189:
190: PROCEDURE delete_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_ajlv_rec IN ajlv_rec_type);
196: p_ajlv_rec IN ajlv_rec_type);
197:
198: PROCEDURE delete_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_ajlv_tbl IN ajlv_tbl_type);
204: p_ajlv_tbl IN ajlv_tbl_type);
205:
206: PROCEDURE validate_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_ajlv_rec IN ajlv_rec_type);
212: p_ajlv_rec IN ajlv_rec_type);
213:
214: PROCEDURE validate_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_ajlv_tbl IN ajlv_tbl_type);