DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_K_HEADERS_V

Line 49: l_k_status_code okc_k_headers_v.sts_code%type;

45: WHERE k.id = p_contract_id
46: AND k.scs_code = scs.code;
47:
48: l_scs_code okc_subclasses_v.code%type;
49: l_k_status_code okc_k_headers_v.sts_code%type;
50: l_cls_code okc_subclasses_v.cls_code%type;
51: l_estimated_amount number;
52: procedure change_approval_start(
53: p_api_version IN NUMBER,

Line 1233: l_contract_number okc_k_headers_v.contract_number%type;

1229: where crt.chr_id = k.id
1230: and k.scs_code = scs.code
1231: and crt.id = p_change_request_id;
1232: l_chr_id number;
1233: l_contract_number okc_k_headers_v.contract_number%type;
1234: l_k_status_code okc_k_headers_v.sts_code%type;
1235: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1236: begin
1237: MO_GLOBAL.INIT('OKS');

Line 1234: l_k_status_code okc_k_headers_v.sts_code%type;

1230: and k.scs_code = scs.code
1231: and crt.id = p_change_request_id;
1232: l_chr_id number;
1233: l_contract_number okc_k_headers_v.contract_number%type;
1234: l_k_status_code okc_k_headers_v.sts_code%type;
1235: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1236: begin
1237: MO_GLOBAL.INIT('OKS');
1238: savepoint change_request_approved;

Line 1235: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;

1231: and crt.id = p_change_request_id;
1232: l_chr_id number;
1233: l_contract_number okc_k_headers_v.contract_number%type;
1234: l_k_status_code okc_k_headers_v.sts_code%type;
1235: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1236: begin
1237: MO_GLOBAL.INIT('OKS');
1238: savepoint change_request_approved;
1239: open lock_csr;

Line 1329: l_contract_number okc_k_headers_v.contract_number%type;

1325: and k.scs_code = scs.code
1326: and crt.id = p_change_request_id;
1327:
1328: l_chr_id number;
1329: l_contract_number okc_k_headers_v.contract_number%type;
1330: l_k_status_code okc_k_headers_v.sts_code%type;
1331: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1332: begin
1333: MO_GLOBAL.INIT('OKS');

Line 1330: l_k_status_code okc_k_headers_v.sts_code%type;

1326: and crt.id = p_change_request_id;
1327:
1328: l_chr_id number;
1329: l_contract_number okc_k_headers_v.contract_number%type;
1330: l_k_status_code okc_k_headers_v.sts_code%type;
1331: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1332: begin
1333: MO_GLOBAL.INIT('OKS');
1334: savepoint change_request_rejected;

Line 1331: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;

1327:
1328: l_chr_id number;
1329: l_contract_number okc_k_headers_v.contract_number%type;
1330: l_k_status_code okc_k_headers_v.sts_code%type;
1331: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1332: begin
1333: MO_GLOBAL.INIT('OKS');
1334: savepoint change_request_rejected;
1335: open lock_csr;