3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE adj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ccw_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE adj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ccw_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
5: ---------------------------------------------------------------------------
6: TYPE adj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ccw_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE adj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ccw_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: ccw_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
9: tcn_id NUMBER := OKC_API.G_MISS_NUM,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: attribute_category OKL_TRX_AR_ADJSTS_B.ATTRIBUTE_CATEGORY%TYPE,
12: object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: attribute_category OKL_TRX_AR_ADJSTS_B.ATTRIBUTE_CATEGORY%TYPE,
20: attribute1 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE1%TYPE,
13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: attribute_category OKL_TRX_AR_ADJSTS_B.ATTRIBUTE_CATEGORY%TYPE,
20: attribute1 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE1%TYPE,
21: attribute2 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE2%TYPE,
14: request_id NUMBER := OKC_API.G_MISS_NUM,
15: program_application_id NUMBER := OKC_API.G_MISS_NUM,
16: program_id NUMBER := OKC_API.G_MISS_NUM,
17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: attribute_category OKL_TRX_AR_ADJSTS_B.ATTRIBUTE_CATEGORY%TYPE,
20: attribute1 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE1%TYPE,
21: attribute2 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE2%TYPE,
22: attribute3 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE3%TYPE,
32: attribute13 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE13%TYPE,
33: attribute14 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE14%TYPE,
34: attribute15 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE15%TYPE,
35: created_by OKL_TRX_AR_ADJSTS_B.CREATED_BY%TYPE,
36: creation_date OKL_TRX_AR_ADJSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by OKL_TRX_AR_ADJSTS_B.LAST_UPDATED_BY%TYPE,
38: last_update_date OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_LOGIN%TYPE,
40: trx_status_code OKL_TRX_AR_ADJSTS_B.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
34: attribute15 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE15%TYPE,
35: created_by OKL_TRX_AR_ADJSTS_B.CREATED_BY%TYPE,
36: creation_date OKL_TRX_AR_ADJSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by OKL_TRX_AR_ADJSTS_B.LAST_UPDATED_BY%TYPE,
38: last_update_date OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_LOGIN%TYPE,
40: trx_status_code OKL_TRX_AR_ADJSTS_B.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: --Bug 6316320 dpsingh start
42: try_id NUMBER := OKL_API.G_MISS_NUM,
36: creation_date OKL_TRX_AR_ADJSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by OKL_TRX_AR_ADJSTS_B.LAST_UPDATED_BY%TYPE,
38: last_update_date OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_LOGIN%TYPE,
40: trx_status_code OKL_TRX_AR_ADJSTS_B.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: --Bug 6316320 dpsingh start
42: try_id NUMBER := OKL_API.G_MISS_NUM,
43: --Bug 6316320 dpsingh end
44: --gkhuntet start 02-Nov-07
48: g_miss_adj_rec adj_rec_type;
49: TYPE adj_tbl_type IS TABLE OF adj_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE okl_trx_ar_adjsts_tl_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: language OKL_TRX_AR_ADJSTS_TL.LANGUAGE%TYPE,
54: source_lang OKL_TRX_AR_ADJSTS_TL.SOURCE_LANG%TYPE,
55: sfwt_flag OKL_TRX_AR_ADJSTS_TL.SFWT_FLAG%TYPE,
56: comments OKL_TRX_AR_ADJSTS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
52: id NUMBER := OKC_API.G_MISS_NUM,
53: language OKL_TRX_AR_ADJSTS_TL.LANGUAGE%TYPE,
54: source_lang OKL_TRX_AR_ADJSTS_TL.SOURCE_LANG%TYPE,
55: sfwt_flag OKL_TRX_AR_ADJSTS_TL.SFWT_FLAG%TYPE,
56: comments OKL_TRX_AR_ADJSTS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
57: created_by OKL_TRX_AR_ADJSTS_TL.CREATED_BY%TYPE,
58: creation_date OKL_TRX_AR_ADJSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by OKL_TRX_AR_ADJSTS_TL.LAST_UPDATED_BY%TYPE,
60: last_update_date OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
54: source_lang OKL_TRX_AR_ADJSTS_TL.SOURCE_LANG%TYPE,
55: sfwt_flag OKL_TRX_AR_ADJSTS_TL.SFWT_FLAG%TYPE,
56: comments OKL_TRX_AR_ADJSTS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
57: created_by OKL_TRX_AR_ADJSTS_TL.CREATED_BY%TYPE,
58: creation_date OKL_TRX_AR_ADJSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by OKL_TRX_AR_ADJSTS_TL.LAST_UPDATED_BY%TYPE,
60: last_update_date OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_LOGIN%TYPE);
62: GMissOklTrxArAdjstsTlRec okl_trx_ar_adjsts_tl_rec_type;
56: comments OKL_TRX_AR_ADJSTS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
57: created_by OKL_TRX_AR_ADJSTS_TL.CREATED_BY%TYPE,
58: creation_date OKL_TRX_AR_ADJSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_updated_by OKL_TRX_AR_ADJSTS_TL.LAST_UPDATED_BY%TYPE,
60: last_update_date OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_update_login OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_LOGIN%TYPE);
62: GMissOklTrxArAdjstsTlRec okl_trx_ar_adjsts_tl_rec_type;
63: TYPE okl_trx_ar_adjsts_tl_tbl_type IS TABLE OF okl_trx_ar_adjsts_tl_rec_type
64: INDEX BY BINARY_INTEGER;
62: GMissOklTrxArAdjstsTlRec okl_trx_ar_adjsts_tl_rec_type;
63: TYPE okl_trx_ar_adjsts_tl_tbl_type IS TABLE OF okl_trx_ar_adjsts_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE adjv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TRX_AR_ADJSTS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
65: TYPE adjv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TRX_AR_ADJSTS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
66: id NUMBER := OKC_API.G_MISS_NUM,
67: object_version_number OKL_TRX_AR_ADJSTS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
67: object_version_number OKL_TRX_AR_ADJSTS_V.OBJECT_VERSION_NUMBER%TYPE,
68: sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
68: sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
76: attribute_category OKL_TRX_AR_ADJSTS_V.ATTRIBUTE_CATEGORY%TYPE,
69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
76: attribute_category OKL_TRX_AR_ADJSTS_V.ATTRIBUTE_CATEGORY%TYPE,
77: attribute1 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE1%TYPE,
70: ccw_id NUMBER := OKC_API.G_MISS_NUM,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
76: attribute_category OKL_TRX_AR_ADJSTS_V.ATTRIBUTE_CATEGORY%TYPE,
77: attribute1 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE1%TYPE,
78: attribute2 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE2%TYPE,
71: tcn_id NUMBER := OKC_API.G_MISS_NUM,
72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
76: attribute_category OKL_TRX_AR_ADJSTS_V.ATTRIBUTE_CATEGORY%TYPE,
77: attribute1 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE1%TYPE,
78: attribute2 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE2%TYPE,
79: attribute3 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE3%TYPE,
88: attribute12 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE12%TYPE,
89: attribute13 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE13%TYPE,
90: attribute14 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE14%TYPE,
91: attribute15 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE15%TYPE,
92: request_id NUMBER := OKC_API.G_MISS_NUM,
93: program_application_id NUMBER := OKC_API.G_MISS_NUM,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
89: attribute13 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE13%TYPE,
90: attribute14 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE14%TYPE,
91: attribute15 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE15%TYPE,
92: request_id NUMBER := OKC_API.G_MISS_NUM,
93: program_application_id NUMBER := OKC_API.G_MISS_NUM,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
90: attribute14 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE14%TYPE,
91: attribute15 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE15%TYPE,
92: request_id NUMBER := OKC_API.G_MISS_NUM,
93: program_application_id NUMBER := OKC_API.G_MISS_NUM,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
91: attribute15 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE15%TYPE,
92: request_id NUMBER := OKC_API.G_MISS_NUM,
93: program_application_id NUMBER := OKC_API.G_MISS_NUM,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_updated_by OKL_TRX_AR_ADJSTS_V.LAST_UPDATED_BY%TYPE,
92: request_id NUMBER := OKC_API.G_MISS_NUM,
93: program_application_id NUMBER := OKC_API.G_MISS_NUM,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_updated_by OKL_TRX_AR_ADJSTS_V.LAST_UPDATED_BY%TYPE,
100: last_update_date OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: program_id NUMBER := OKC_API.G_MISS_NUM,
95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_updated_by OKL_TRX_AR_ADJSTS_V.LAST_UPDATED_BY%TYPE,
100: last_update_date OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
101: last_update_login OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_LOGIN%TYPE,
102: --Bug 6316320 dpsingh start
96: org_id NUMBER := OKC_API.G_MISS_NUM,
97: created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: last_updated_by OKL_TRX_AR_ADJSTS_V.LAST_UPDATED_BY%TYPE,
100: last_update_date OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
101: last_update_login OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_LOGIN%TYPE,
102: --Bug 6316320 dpsingh start
103: try_id NUMBER := OKL_API.G_MISS_NUM,
104: --Bug 6316320 dpsingh end
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_ADJ_PVT';
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
128: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ADJ_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_adjv_rec IN adjv_rec_type,
145: x_adjv_rec OUT NOCOPY adjv_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_adjv_tbl IN adjv_tbl_type,
154: x_adjv_tbl OUT NOCOPY adjv_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_adjv_rec IN adjv_rec_type);
162: p_adjv_rec IN adjv_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_adjv_tbl IN adjv_tbl_type);
170: p_adjv_tbl IN adjv_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_adjv_rec IN adjv_rec_type,
179: x_adjv_rec OUT NOCOPY adjv_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_adjv_tbl IN adjv_tbl_type,
188: x_adjv_tbl OUT NOCOPY adjv_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_adjv_rec IN adjv_rec_type);
196: p_adjv_rec IN adjv_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_adjv_tbl IN adjv_tbl_type);
204: p_adjv_tbl IN adjv_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_adjv_rec IN adjv_rec_type);
212: p_adjv_rec IN adjv_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_adjv_tbl IN adjv_tbl_type);