DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_API

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

29:
30: ---------------------------------------------------------------------------
31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

30: ---------------------------------------------------------------------------
31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

31: -- GLOBAL MESSAGE CONSTANTS
32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

32: ---------------------------------------------------------------------------
33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

33: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

34: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

35: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

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

36: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

37: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

38: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
45: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
46: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';

Line 1232: old_cpl_id NUMBER := OKC_API.G_MISS_NUM,

1228: --PL/SQL Table to check the party has already copied.
1229: --If Yes give the new cpl_id ----Begins
1230: ----------------------------------------------------------------------------
1231: TYPE party_rec_type IS RECORD (
1232: old_cpl_id NUMBER := OKC_API.G_MISS_NUM,
1233: new_cpl_id NUMBER := OKC_API.G_MISS_NUM);
1234: TYPE party_tbl_type IS TABLE OF party_rec_type
1235: INDEX BY BINARY_INTEGER;
1236: g_party party_tbl_type;

Line 1233: new_cpl_id NUMBER := OKC_API.G_MISS_NUM);

1229: --If Yes give the new cpl_id ----Begins
1230: ----------------------------------------------------------------------------
1231: TYPE party_rec_type IS RECORD (
1232: old_cpl_id NUMBER := OKC_API.G_MISS_NUM,
1233: new_cpl_id NUMBER := OKC_API.G_MISS_NUM);
1234: TYPE party_tbl_type IS TABLE OF party_rec_type
1235: INDEX BY BINARY_INTEGER;
1236: g_party party_tbl_type;
1237:

Line 1243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1239: FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
1240:
1241: PROCEDURE copy_components(
1242: p_api_version IN NUMBER,
1243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_msg_count OUT NOCOPY NUMBER,
1246: x_msg_data OUT NOCOPY VARCHAR2,
1247: p_from_chr_id IN NUMBER,

Line 1269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1265:
1266:
1267: PROCEDURE copy_contract(
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1270: x_return_status OUT NOCOPY VARCHAR2,
1271: x_msg_count OUT NOCOPY NUMBER,
1272: x_msg_data OUT NOCOPY VARCHAR2,
1273: p_commit IN VARCHAR2 DEFAULT 'F',

Line 1285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1281: p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
1282:
1283: PROCEDURE copy_contract_header(
1284: p_api_version IN NUMBER,
1285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1286: x_return_status OUT NOCOPY VARCHAR2,
1287: x_msg_count OUT NOCOPY NUMBER,
1288: x_msg_data OUT NOCOPY VARCHAR2,
1289: p_from_chr_id IN NUMBER,

Line 1299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1295:
1296: /******Header Level events no longer supported****
1297: PROCEDURE copy_events(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1302: x_msg_data OUT NOCOPY VARCHAR2,
1303: p_cnh_id IN NUMBER,

Line 1304: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1302: x_msg_data OUT NOCOPY VARCHAR2,
1303: p_cnh_id IN NUMBER,
1304: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
1305: p_to_template_yn IN VARCHAR2,
1306: x_cnh_id OUT NOCOPY NUMBER);
1307: ****************************************************/
1308:

Line 1323: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1319: values are 'Y' and 'N'
1320: =======================================================================================*/
1321: PROCEDURE copy_lines(
1322: p_api_version IN NUMBER
1323: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1324: ,x_return_status OUT NOCOPY VARCHAR2
1325: ,x_msg_count OUT NOCOPY NUMBER
1326: ,x_msg_data OUT NOCOPY VARCHAR2
1327: ,P_From_Chr_ID IN NUMBER

Line 1359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1355: else they would be copied for both Header and Lines.
1356: =========================================================================================*/
1357: PROCEDURE copy_line_components(
1358: p_api_version IN NUMBER
1359: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1360: ,x_return_status OUT NOCOPY VARCHAR2
1361: ,x_msg_count OUT NOCOPY NUMBER
1362: ,x_msg_data OUT NOCOPY VARCHAR2
1363: ,P_From_Chr_ID IN NUMBER

Line 1391: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1387: Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
1388: ,P_From_Chr_ID IN NUMBER
1389: ,P_Partial_Copy_YN IN VARCHAR2
1390: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
1391: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1392: ,x_return_status OUT NOCOPY VARCHAR2
1393: ,x_msg_count OUT NOCOPY NUMBER
1394: ,x_msg_data OUT NOCOPY VARCHAR2);
1395: