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 1230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1226: FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
1227:
1228: PROCEDURE copy_components(
1229: p_api_version IN NUMBER,
1230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1231: x_return_status OUT NOCOPY VARCHAR2,
1232: x_msg_count OUT NOCOPY NUMBER,
1233: x_msg_data OUT NOCOPY VARCHAR2,
1234: p_from_chr_id IN NUMBER,

Line 1256: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1252:
1253:
1254: PROCEDURE copy_contract(
1255: p_api_version IN NUMBER,
1256: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1257: x_return_status OUT NOCOPY VARCHAR2,
1258: x_msg_count OUT NOCOPY NUMBER,
1259: x_msg_data OUT NOCOPY VARCHAR2,
1260: p_commit IN VARCHAR2 DEFAULT 'F',

Line 1272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1268: p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
1269:
1270: PROCEDURE copy_contract_header(
1271: p_api_version IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1273: x_return_status OUT NOCOPY VARCHAR2,
1274: x_msg_count OUT NOCOPY NUMBER,
1275: x_msg_data OUT NOCOPY VARCHAR2,
1276: p_from_chr_id IN NUMBER,

Line 1286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1282:
1283: /******Header Level events no longer supported****
1284: PROCEDURE copy_events(
1285: p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1287: x_return_status OUT NOCOPY VARCHAR2,
1288: x_msg_count OUT NOCOPY NUMBER,
1289: x_msg_data OUT NOCOPY VARCHAR2,
1290: p_cnh_id IN NUMBER,

Line 1291: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,

1287: x_return_status OUT NOCOPY VARCHAR2,
1288: x_msg_count OUT NOCOPY NUMBER,
1289: x_msg_data OUT NOCOPY VARCHAR2,
1290: p_cnh_id IN NUMBER,
1291: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
1292: p_to_template_yn IN VARCHAR2,
1293: x_cnh_id OUT NOCOPY NUMBER);
1294: ****************************************************/
1295:

Line 1310: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1306: values are 'Y' and 'N'
1307: =======================================================================================*/
1308: PROCEDURE copy_lines(
1309: p_api_version IN NUMBER
1310: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1311: ,x_return_status OUT NOCOPY VARCHAR2
1312: ,x_msg_count OUT NOCOPY NUMBER
1313: ,x_msg_data OUT NOCOPY VARCHAR2
1314: ,P_From_Chr_ID IN NUMBER

Line 1346: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1342: else they would be copied for both Header and Lines.
1343: =========================================================================================*/
1344: PROCEDURE copy_line_components(
1345: p_api_version IN NUMBER
1346: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1347: ,x_return_status OUT NOCOPY VARCHAR2
1348: ,x_msg_count OUT NOCOPY NUMBER
1349: ,x_msg_data OUT NOCOPY VARCHAR2
1350: ,P_From_Chr_ID IN NUMBER

Line 1378: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1374: Procedure create_bsch_using_PPSetup(P_To_Chr_ID IN NUMBER
1375: ,P_From_Chr_ID IN NUMBER
1376: ,P_Partial_Copy_YN IN VARCHAR2
1377: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
1378: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1379: ,x_return_status OUT NOCOPY VARCHAR2
1380: ,x_msg_count OUT NOCOPY NUMBER
1381: ,x_msg_data OUT NOCOPY VARCHAR2);
1382: