DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_CHANGE_REQUEST_PUB

Line 72: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

68: --end san
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);

Line 232: OKC_CHANGE_REQUEST_PUB.lock_change_request(

228: -- try to lock crt (will not be locked if approved or on approval etc.
229: -- message raised inside lock procedure
230: --
231: l1_crtv_rec.id := p_change_request_id;
232: OKC_CHANGE_REQUEST_PUB.lock_change_request(
233: p_api_version => l_api_version,
234: x_return_status => l_return_status,
235: x_msg_count => l_msg_count,
236: x_msg_data => l_msg_data,

Line 935: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

931: p_do_commit IN VARCHAR2
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: --

Line 970: OKC_CHANGE_REQUEST_PUB.lock_change_request(

966: RAISE OKC_API.G_EXCEPTION_ERROR;
967: END IF;
968: --
969: l_crtv_rec.id := p_change_request_id;
970: OKC_CHANGE_REQUEST_PUB.lock_change_request(
971: p_api_version => p_api_version,
972: x_return_status => l_return_status,
973: x_msg_count => x_msg_count,
974: x_msg_data => x_msg_data,

Line 1072: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1068: p_do_commit IN VARCHAR2
1069: ) is
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: --

Line 1073: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1069: ) is
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

Line 1095: OKC_CHANGE_REQUEST_PUB.lock_change_request(

1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093: --
1094: l_crtv_rec.id := p_change_request_id;
1095: OKC_CHANGE_REQUEST_PUB.lock_change_request(
1096: p_api_version => p_api_version,
1097: x_return_status => l_return_status,
1098: x_msg_count => x_msg_count,
1099: x_msg_data => x_msg_data,

Line 1138: OKC_CHANGE_REQUEST_PUB.update_change_request(

1134: RAISE OKC_API.G_EXCEPTION_ERROR;
1135: END IF;
1136: l_crtv_rec.datetime_applied := p_datetime_applied;
1137: l_crtv_rec.applied_contract_version := p_k_version;
1138: OKC_CHANGE_REQUEST_PUB.update_change_request(
1139: p_api_version => p_api_version,
1140: x_return_status => l_return_status,
1141: x_msg_count => x_msg_count,
1142: x_msg_data => x_msg_data,

Line 1213: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1209: procedure change_request_approved(
1210: p_change_request_id IN number,
1211: x_return_status OUT NOCOPY VARCHAR2
1212: ) is
1213: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1214: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1215: l_msg_count NUMBER;
1216: l_msg_data varchar2(2000);
1217: cursor lock_csr is

Line 1214: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1210: p_change_request_id IN number,
1211: x_return_status OUT NOCOPY VARCHAR2
1212: ) is
1213: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1214: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1215: l_msg_count NUMBER;
1216: l_msg_data varchar2(2000);
1217: cursor lock_csr is
1218: select ID

Line 1245: OKC_CHANGE_REQUEST_PUB.update_change_request(

1241: close lock_csr;
1242: l_crtv_rec.datetime_approved := sysdate;
1243: l_crtv_rec.datetime_rejected := NULL;
1244: l_crtv_rec.crs_code := 'APP';
1245: OKC_CHANGE_REQUEST_PUB.update_change_request(
1246: p_api_version => l_api_version,
1247: x_return_status => x_return_status,
1248: x_msg_count => l_msg_count,
1249: x_msg_data => l_msg_data,

Line 1308: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1304: procedure change_request_rejected(
1305: p_change_request_id IN number,
1306: x_return_status OUT NOCOPY VARCHAR2
1307: ) is
1308: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1309: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1310: l_msg_count NUMBER;
1311: l_msg_data varchar2(2000);
1312: cursor lock_csr is

Line 1309: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;

1305: p_change_request_id IN number,
1306: x_return_status OUT NOCOPY VARCHAR2
1307: ) is
1308: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1309: l1_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
1310: l_msg_count NUMBER;
1311: l_msg_data varchar2(2000);
1312: cursor lock_csr is
1313: select ID

Line 1341: OKC_CHANGE_REQUEST_PUB.update_change_request(

1337: close lock_csr;
1338: l_crtv_rec.datetime_approved := NULL;
1339: l_crtv_rec.datetime_rejected := sysdate;
1340: l_crtv_rec.crs_code := 'REJ';
1341: OKC_CHANGE_REQUEST_PUB.update_change_request(
1342: p_api_version => l_api_version,
1343: x_return_status => x_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,