APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_CONTRACT_PUB

Line 73: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

69:
70: l_api_name CONSTANT VARCHAR2(30) := 'change_approval_start';
71: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
72: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
73: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
74: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
75: l_msg_count NUMBER;
76: l_msg_data varchar2(2000);
77: --

Line 74: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

70: l_api_name CONSTANT VARCHAR2(30) := 'change_approval_start';
71: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
72: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
73: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
74: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
75: l_msg_count NUMBER;
76: l_msg_data varchar2(2000);
77: --
78: --

Line 302: OKC_CONTRACT_PUB.update_contract_process(

298: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
299: raise OKC_API.G_EXCEPTION_ERROR;
300: end;
301: L1_CPSV_REC.PROCESS_ID := L_KEY;
302: OKC_CONTRACT_PUB.update_contract_process(
303: p_api_version => l_api_version,
304: x_return_status => l_return_status,
305: x_msg_count => l_msg_count,
306: x_msg_data => l_msg_data,

Line 936: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;

932: ) is
933: l_api_name CONSTANT VARCHAR2(30) := 'change_get_key';
934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
935: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
936: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
937: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
938: l_dummy varchar2(1) := '?';
939: --
940: cursor in_use_csr is

Line 937: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;

933: l_api_name CONSTANT VARCHAR2(30) := 'change_get_key';
934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
935: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
936: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
937: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
938: l_dummy varchar2(1) := '?';
939: --
940: cursor in_use_csr is
941: select '!'

Line 992: OKC_CONTRACT_PUB.lock_contract_process(

988: END IF;
989: open process_csr;
990: fetch process_csr into l_cpsv_rec.id,l_cpsv_rec.object_version_number;
991: close process_csr;
992: OKC_CONTRACT_PUB.lock_contract_process(
993: p_api_version => p_api_version,
994: x_return_status => l_return_status,
995: x_msg_count => x_msg_count,
996: x_msg_data => x_msg_data,

Line 1005: OKC_CONTRACT_PUB.update_contract_process(

1001: RAISE OKC_API.G_EXCEPTION_ERROR;
1002: END IF;
1003: l_cpsv_rec.in_process_yn := 'Y';
1004: l_cpsv_rec.user_id := fnd_global.user_id;
1005: OKC_CONTRACT_PUB.update_contract_process(
1006: p_api_version => p_api_version,
1007: x_return_status => l_return_status,
1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data,

Line 1074: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;

1070: l_api_name CONSTANT VARCHAR2(30) := 'change_put_key';
1071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1072: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1073: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1074: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1075: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1076: --
1077: cursor process_csr is
1078: select id,object_version_number from OKC_K_PROCESSES

Line 1075: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;

1071: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1072: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1073: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1074: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1075: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1076: --
1077: cursor process_csr is
1078: select id,object_version_number from OKC_K_PROCESSES
1079: where crt_id = p_change_request_id;

Line 1111: OKC_CONTRACT_PUB.lock_contract_process(

1107: --
1108: open process_csr;
1109: fetch process_csr into l_cpsv_rec.id,l_cpsv_rec.object_version_number;
1110: close process_csr;
1111: OKC_CONTRACT_PUB.lock_contract_process(
1112: p_api_version => p_api_version,
1113: x_return_status => l_return_status,
1114: x_msg_count => x_msg_count,
1115: x_msg_data => x_msg_data,

Line 1124: OKC_CONTRACT_PUB.update_contract_process(

1120: RAISE OKC_API.G_EXCEPTION_ERROR;
1121: END IF;
1122: --
1123: l_cpsv_rec.in_process_yn := 'N';
1124: OKC_CONTRACT_PUB.update_contract_process(
1125: p_api_version => p_api_version,
1126: x_return_status => l_return_status,
1127: x_msg_count => x_msg_count,
1128: x_msg_data => x_msg_data,