DBA Data[Home] [Help]

APPS.OKL_ADJ_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 8: ccw_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 9: tcn_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 10: adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 11: apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 13: gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 14: request_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,
18: org_id NUMBER := OKC_API.G_MISS_NUM,

Line 15: program_application_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,

Line 16: program_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 17: program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 18: org_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 36: creation_date OKL_TRX_AR_ADJSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 38: last_update_date OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 40: trx_status_code OKL_TRX_AR_ADJSTS_B.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 52: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 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,

Line 58: creation_date OKL_TRX_AR_ADJSTS_TL.CREATION_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;

Line 60: last_update_date OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

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;

Line 66: id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 69: trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 70: ccw_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 71: tcn_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,
75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 72: adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%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,

Line 73: apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 74: gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,

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,

Line 75: comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 92: request_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 93: program_application_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,

Line 94: program_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 95: program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_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,

Line 96: org_id NUMBER := OKC_API.G_MISS_NUM,

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,

Line 98: creation_date OKL_TRX_AR_ADJSTS_V.CREATION_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

Line 100: last_update_date OKL_TRX_AR_ADJSTS_V.LAST_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
103: try_id NUMBER := OKL_API.G_MISS_NUM,
104: --Bug 6316320 dpsingh end

Line 115: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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: ---------------------------------------------------------------------------

Line 122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

Line 123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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: ---------------------------------------------------------------------------

Line 124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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';

Line 129: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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:

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);