DBA Data[Home] [Help]

APPS.OKL_IPM_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TRX_PARAMS_B Record Spec
7: TYPE ipm_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- OKL_TRX_PARAMS_B Record Spec
7: TYPE ipm_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 10: ,source_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKL_TRX_PARAMS_B Record Spec
7: TYPE ipm_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR

7: TYPE ipm_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 13: ,created_by NUMBER := OKC_API.G_MISS_NUM

9: ,source_table OKL_TRX_PARAMS_B.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR
10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,source_id NUMBER := OKC_API.G_MISS_NUM
11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: G_MISS_ipm_rec ipm_rec_type;

Line 15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

11: ,param_name OKL_TRX_PARAMS_B.PARAM_NAME%TYPE := OKC_API.G_MISS_CHAR
12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: G_MISS_ipm_rec ipm_rec_type;
19: TYPE ipm_tbl_type IS TABLE OF ipm_rec_type

Line 16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

12: ,param_value OKL_TRX_PARAMS_B.PARAM_VALUE%TYPE := OKC_API.G_MISS_CHAR
13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: G_MISS_ipm_rec ipm_rec_type;
19: TYPE ipm_tbl_type IS TABLE OF ipm_rec_type
20: INDEX BY BINARY_INTEGER;

Line 17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

13: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,creation_date OKL_TRX_PARAMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,last_update_date OKL_TRX_PARAMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: G_MISS_ipm_rec ipm_rec_type;
19: TYPE ipm_tbl_type IS TABLE OF ipm_rec_type
20: INDEX BY BINARY_INTEGER;
21: ---------------------------------------------------------------------------

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

20: INDEX BY BINARY_INTEGER;
21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
36: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
36: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
37:

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

43: ---------------------------------------------------------------------------
44: -- GLOBAL VARIABLES
45: ---------------------------------------------------------------------------
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IPM_PVT';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48: ---------------------------------------------------------------------------
49: -- Procedures and Functions
50: ---------------------------------------------------------------------------
51:

Line 57: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

53: PROCEDURE change_version;
54: PROCEDURE api_copy;
55: PROCEDURE insert_row(
56: p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_ipm_rec IN ipm_rec_type,

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

61: p_ipm_rec IN ipm_rec_type,
62: x_ipm_rec OUT NOCOPY ipm_rec_type);
63: /* PROCEDURE insert_row(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_ipm_tbl IN ipm_tbl_type,

Line 71: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_ipm_tbl IN ipm_tbl_type,
70: x_ipm_tbl OUT NOCOPY ipm_tbl_type,
71: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
72: */ PROCEDURE insert_row(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,

Line 74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

70: x_ipm_tbl OUT NOCOPY ipm_tbl_type,
71: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
72: */ PROCEDURE insert_row(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_ipm_tbl IN ipm_tbl_type,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78: p_ipm_tbl IN ipm_tbl_type,
79: x_ipm_tbl OUT NOCOPY ipm_tbl_type);
80: PROCEDURE lock_row(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_ipm_rec IN ipm_rec_type);

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_ipm_rec IN ipm_rec_type);
87: PROCEDURE lock_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_ipm_tbl IN ipm_tbl_type,

Line 94: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_ipm_tbl IN ipm_tbl_type,
94: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
95: PROCEDURE lock_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

93: p_ipm_tbl IN ipm_tbl_type,
94: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
95: PROCEDURE lock_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_ipm_tbl IN ipm_tbl_type);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_ipm_tbl IN ipm_tbl_type);
102: PROCEDURE update_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_ipm_rec IN ipm_rec_type,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108: p_ipm_rec IN ipm_rec_type,
109: x_ipm_rec OUT NOCOPY ipm_rec_type);
110: PROCEDURE update_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_ipm_tbl IN ipm_tbl_type,

Line 118: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_ipm_tbl IN ipm_tbl_type,
117: x_ipm_tbl OUT NOCOPY ipm_tbl_type,
118: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
119: PROCEDURE update_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: x_ipm_tbl OUT NOCOPY ipm_tbl_type,
118: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
119: PROCEDURE update_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_ipm_tbl IN ipm_tbl_type,

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_ipm_tbl IN ipm_tbl_type,
126: x_ipm_tbl OUT NOCOPY ipm_tbl_type);
127: PROCEDURE delete_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_ipm_rec IN ipm_rec_type);

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_ipm_rec IN ipm_rec_type);
134: PROCEDURE delete_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_ipm_tbl IN ipm_tbl_type,

Line 141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_ipm_tbl IN ipm_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
142: PROCEDURE delete_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: p_ipm_tbl IN ipm_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
142: PROCEDURE delete_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_ipm_tbl IN ipm_tbl_type);

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_ipm_tbl IN ipm_tbl_type);
149: PROCEDURE validate_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_ipm_rec IN ipm_rec_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_ipm_rec IN ipm_rec_type);
156: PROCEDURE validate_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_ipm_tbl IN ipm_tbl_type,

Line 163: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_ipm_tbl IN ipm_tbl_type,
163: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
164: PROCEDURE validate_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,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: p_ipm_tbl IN ipm_tbl_type,
163: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
164: PROCEDURE validate_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_ipm_tbl IN ipm_tbl_type);