eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_MASSCHANGE_PVT dependencies on OKC_OPER_INST_PUB

Line 7154: l_olev_rec_in okc_oper_inst_pub.olev_rec_type;

7150:
7151: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
7152: l_rilv_tbl_out okc_ril_pvt.rilv_tbl_type;
7153:
7154: l_olev_rec_in okc_oper_inst_pub.olev_rec_type;
7155: l_olev_rec_out okc_oper_inst_pub.olev_rec_type;
7156:
7157: l_oiev_rec_in okc_oper_inst_pub.oiev_rec_type;
7158: l_oiev_rec_out okc_oper_inst_pub.oiev_rec_type;

Line 7155: l_olev_rec_out okc_oper_inst_pub.olev_rec_type;

7151: l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
7152: l_rilv_tbl_out okc_ril_pvt.rilv_tbl_type;
7153:
7154: l_olev_rec_in okc_oper_inst_pub.olev_rec_type;
7155: l_olev_rec_out okc_oper_inst_pub.olev_rec_type;
7156:
7157: l_oiev_rec_in okc_oper_inst_pub.oiev_rec_type;
7158: l_oiev_rec_out okc_oper_inst_pub.oiev_rec_type;
7159:

Line 7157: l_oiev_rec_in okc_oper_inst_pub.oiev_rec_type;

7153:
7154: l_olev_rec_in okc_oper_inst_pub.olev_rec_type;
7155: l_olev_rec_out okc_oper_inst_pub.olev_rec_type;
7156:
7157: l_oiev_rec_in okc_oper_inst_pub.oiev_rec_type;
7158: l_oiev_rec_out okc_oper_inst_pub.oiev_rec_type;
7159:
7160: l_rulv_rec_in okc_rule_pub.rulv_rec_type;
7161: l_rulv_rec_out okc_rule_pub.rulv_rec_type;

Line 7158: l_oiev_rec_out okc_oper_inst_pub.oiev_rec_type;

7154: l_olev_rec_in okc_oper_inst_pub.olev_rec_type;
7155: l_olev_rec_out okc_oper_inst_pub.olev_rec_type;
7156:
7157: l_oiev_rec_in okc_oper_inst_pub.oiev_rec_type;
7158: l_oiev_rec_out okc_oper_inst_pub.oiev_rec_type;
7159:
7160: l_rulv_rec_in okc_rule_pub.rulv_rec_type;
7161: l_rulv_rec_out okc_rule_pub.rulv_rec_type;
7162:

Line 12029: OKC_OPER_INST_PUB.Update_Operation_Line (

12025:
12026: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12027: l_olev_rec_in.process_flag := 'P';
12028:
12029: OKC_OPER_INST_PUB.Update_Operation_Line (
12030: p_api_version => l_api_version,
12031: p_init_msg_list => l_init_msg_list,
12032: x_return_status => l_return_status,
12033: x_msg_count => l_msg_count,

Line 12045: OKC_OPER_INST_PUB.Update_Operation_Line (

12041:
12042: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12043: l_olev_rec_in.process_flag := 'A';
12044:
12045: OKC_OPER_INST_PUB.Update_Operation_Line (
12046: p_api_version => l_api_version,
12047: p_init_msg_list => l_init_msg_list,
12048: x_return_status => l_return_status,
12049: x_msg_count => l_msg_count,

Line 12060: OKC_OPER_INST_PUB.Update_Operation_Line (

12056: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12057: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12058: l_olev_rec_in.process_flag := 'E';
12059:
12060: OKC_OPER_INST_PUB.Update_Operation_Line (
12061: p_api_version => l_api_version,
12062: p_init_msg_list => l_init_msg_list,
12063: x_return_status => l_return_status,
12064: x_msg_count => l_msg_count,

Line 12098: OKC_OPER_INST_PUB.Update_Operation_Line (

12094: --Update operation lines with ERROR (revisit)
12095: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12096: l_olev_rec_in.process_flag := 'E';
12097:
12098: OKC_OPER_INST_PUB.Update_Operation_Line (
12099: p_api_version => l_api_version,
12100: p_init_msg_list => l_init_msg_list,
12101: x_return_status => l_return_status,
12102: x_msg_count => l_msg_count,

Line 12125: OKC_OPER_INST_PUB.Update_Operation_Line (

12121:
12122: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12123: l_olev_rec_in.process_flag := NULL ;
12124:
12125: OKC_OPER_INST_PUB.Update_Operation_Line (
12126: p_api_version => l_api_version,
12127: p_init_msg_list => l_init_msg_list,
12128: x_return_status => l_return_status,
12129: x_msg_count => l_msg_count,

Line 12163: OKC_OPER_INST_PUB.Update_Operation_Line (

12159:
12160: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12161: l_olev_rec_in.process_flag := 'E';
12162:
12163: OKC_OPER_INST_PUB.Update_Operation_Line (
12164: p_api_version => l_api_version,
12165: p_init_msg_list => l_init_msg_list,
12166: x_return_status => l_return_status,
12167: x_msg_count => l_msg_count,

Line 12241: OKC_OPER_INST_PUB.Update_Operation_Line (

12237:
12238: l_olev_rec_in.id := inelligible_rec.ole_id;
12239: l_olev_rec_in.process_flag := 'N';
12240:
12241: OKC_OPER_INST_PUB.Update_Operation_Line (
12242: p_api_version => l_api_version,
12243: p_init_msg_list => l_init_msg_list,
12244: x_return_status => l_return_status,
12245: x_msg_count => l_msg_count,

Line 12250: LOG_MESSAGES(' OKC_OPER_INST_PUB.Update_Operation_Line: '||l_return_status);

12246: x_msg_data => l_msg_data,
12247: p_olev_rec => l_olev_rec_in,
12248: x_olev_rec => l_olev_rec_out);
12249:
12250: LOG_MESSAGES(' OKC_OPER_INST_PUB.Update_Operation_Line: '||l_return_status);
12251:
12252: IF l_return_status <> 'S' then
12253: IF l_msg_count > 0
12254: THEN

Line 12270: OKC_OPER_INST_PUB.Update_Operation_Instance (

12266: END LOOP;
12267:
12268: IF l_oiev_rec_in.status_code is NOT NULL then
12269:
12270: OKC_OPER_INST_PUB.Update_Operation_Instance (
12271: p_api_version => l_api_version,
12272: p_init_msg_list => l_init_msg_list,
12273: x_return_status => l_return_status,
12274: x_msg_count => l_msg_count,

Line 12435: OKC_OPER_INST_PUB.Update_Operation_Instance (

12431: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE_START');
12432: LOG_MESSAGES('For oie_id:'||p_oie_id||', Others EXCEPTION in outer:'||SQLERRM);
12433: l_oiev_rec_in.id := p_oie_id;
12434: l_oiev_rec_in.status_code := 'ERROR';
12435: OKC_OPER_INST_PUB.Update_Operation_Instance (
12436: p_api_version => l_api_version,
12437: p_init_msg_list => l_init_msg_list,
12438: x_return_status => l_return_status,
12439: x_msg_count => l_msg_count,

Line 12540: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12536: l_msg_data VARCHAR2(2000);
12537:
12538: l_msg_index_out NUMBER;
12539:
12540: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12541: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12542:
12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

Line 12541: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12537:
12538: l_msg_index_out NUMBER;
12539:
12540: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12541: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12542:
12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12545:

Line 12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;

12539:
12540: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12541: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12542:
12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12545:
12546: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12547: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

Line 12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

12540: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12541: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12542:
12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12545:
12546: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12547: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12548:

Line 12546: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;

12542:
12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12545:
12546: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12547: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12548:
12549: l_mod_rec_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12550: l_mod_rec_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;

Line 12547: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

12543: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12544: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12545:
12546: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12547: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12548:
12549: l_mod_rec_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12550: l_mod_rec_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12551:

Line 12591: OKC_OPER_INST_PUB.Create_Operation_Instance(

12587: l_oiev_tbl_in(1).last_updated_by := NULL ; --OKC_API.G_MISS_NUM;
12588: l_oiev_tbl_in(1).last_update_date := SYSDATE;
12589: l_oiev_tbl_in(1).last_update_login := NULL ; --OKC_API.G_MISS_NUM;
12590:
12591: OKC_OPER_INST_PUB.Create_Operation_Instance(
12592: p_api_version => l_api_version,
12593: p_init_msg_list => l_init_msg_list,
12594: x_return_status => l_return_status,
12595: x_msg_count => l_msg_count,

Line 12648: OKC_OPER_INST_PUB.Create_Masschange_Dtls(

12644: l_omrv_rec_in.last_update_date := SYSDATE;
12645: l_omrv_rec_in.last_update_login := NULL ; --OKC_API.G_MISS_NUM;
12646:
12647:
12648: OKC_OPER_INST_PUB.Create_Masschange_Dtls(
12649: p_api_version => l_api_version,
12650: p_init_msg_list => l_init_msg_list,
12651: x_return_status => l_return_status,
12652: x_msg_count => l_msg_count,

Line 12733: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12729: l_msg_data VARCHAR2(2000);
12730:
12731: l_msg_index_out NUMBER;
12732:
12733: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12734: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12735:
12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

Line 12734: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12730:
12731: l_msg_index_out NUMBER;
12732:
12733: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12734: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12735:
12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12738:

Line 12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;

12732:
12733: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12734: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12735:
12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12738:
12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

Line 12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

12733: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12734: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12735:
12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12738:
12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12741:

Line 12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;

12735:
12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12738:
12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12741:
12742: CURSOR Get_line_req(p_oie_id IN Number) IS
12743: SELECT id from okc_masschange_req_dtls_v

Line 12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

12736: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12737: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12738:
12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12741:
12742: CURSOR Get_line_req(p_oie_id IN Number) IS
12743: SELECT id from okc_masschange_req_dtls_v
12744: WHERE oie_id = p_oie_id;

Line 12755: OKC_OPER_INST_PUB.UPdate_Operation_Instance(

12751: l_oiev_tbl_in(1).jtot_object1_code := p_oie_rec.update_level;
12752:
12753:
12754: /*
12755: OKC_OPER_INST_PUB.UPdate_Operation_Instance(
12756: p_api_version => l_api_version,
12757: p_init_msg_list => l_init_msg_list,
12758: x_return_status => l_return_status,
12759: x_msg_count => l_msg_count,

Line 12791: OKC_OPER_INST_PUB.Update_Masschange_Dtls(

12787:
12788:
12789: --dbms_output.put_line('Calling ..');
12790:
12791: OKC_OPER_INST_PUB.Update_Masschange_Dtls(
12792: p_api_version => l_api_version,
12793: p_init_msg_list => l_init_msg_list,
12794: x_return_status => l_return_status,
12795: x_msg_count => l_msg_count,

Line 12807: OKC_OPER_INST_PUB.UPdate_Operation_Instance(

12803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12804: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
12805: RAISE OKC_API.G_EXCEPTION_ERROR;
12806: END IF;
12807: OKC_OPER_INST_PUB.UPdate_Operation_Instance(
12808: p_api_version => l_api_version,
12809: p_init_msg_list => l_init_msg_list,
12810: x_return_status => l_return_status,
12811: x_msg_count => l_msg_count,

Line 12838: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12834: l_msg_data VARCHAR2(2000);
12835:
12836: l_msg_index_out NUMBER;
12837:
12838: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12839: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12840:
12841: --/*
12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;

Line 12839: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE

12835:
12836: l_msg_index_out NUMBER;
12837:
12838: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12839: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12840:
12841: --/*
12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

Line 12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;

12838: l_oiev_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12839: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12840:
12841: --/*
12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12844:
12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

Line 12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

12839: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type; --OPERATION INSTANCE
12840:
12841: --/*
12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12844:
12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12847:

Line 12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;

12841: --/*
12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12844:
12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12847:
12848: -- CURSOR omrv_id is
12849: -- SELECT ID from OKC_MASSCHANGE_REQ_DTLS_V

Line 12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

12842: -- l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12843: -- l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12844:
12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12847:
12848: -- CURSOR omrv_id is
12849: -- SELECT ID from OKC_MASSCHANGE_REQ_DTLS_V
12850: -- WHERE oie_id = p_oie_rec.oie_id;

Line 12869: OKC_OPER_INST_PUB.Delete_Masschange_Dtls(

12865: l_omrv_rec_in.oie_id := p_oie_rec.oie_id;
12866:
12867: --dbms_output.put_line('Calling ..');
12868:
12869: OKC_OPER_INST_PUB.Delete_Masschange_Dtls(
12870: p_api_version => l_api_version,
12871: p_init_msg_list => l_init_msg_list,
12872: x_return_status => l_return_status,
12873: x_msg_count => l_msg_count,

Line 12888: OKC_OPER_INST_PUB.Delete_Operation_Instance(

12884: */
12885:
12886: l_oiev_tbl_in(1).id := p_oie_rec.oie_id; --OKC_API.G_MISS_CHAR;
12887:
12888: OKC_OPER_INST_PUB.Delete_Operation_Instance(
12889: p_api_version => l_api_version,
12890: p_init_msg_list => l_init_msg_list,
12891: x_return_status => l_return_status,
12892: x_msg_count => l_msg_count,

Line 12896: --dbms_output.put_line(' OKC_OPER_INST_PUB.Delete_Operation_Instance Value of l_return_status='||l_return_status);

12892: x_msg_count => l_msg_count,
12893: x_msg_data => l_msg_data,
12894: p_oiev_rec => l_oiev_tbl_in(1));
12895:
12896: --dbms_output.put_line(' OKC_OPER_INST_PUB.Delete_Operation_Instance Value of l_return_status='||l_return_status);
12897: --dbms_output.put_line('oie_id:'||l_oiev_tbl_out(1).id||',status:'||l_return_status);
12898: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
12899: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
12900: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 12922: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;

12918: l_msg_data VARCHAR2(2000);
12919:
12920: l_msg_index_out NUMBER;
12921:
12922: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12923: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12924:
12925: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12926: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

Line 12923: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;

12919:
12920: l_msg_index_out NUMBER;
12921:
12922: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12923: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12924:
12925: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12926: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12927:

Line 12925: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;

12921:
12922: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12923: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12924:
12925: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12926: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12927:
12928: l_mod_rec_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12929: l_mod_rec_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;

Line 12926: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;

12922: l_omrv_rec_in OKC_OPER_INST_PUB.mrdv_rec_type;
12923: l_omrv_rec_out OKC_OPER_INST_PUB.mrdv_rec_type;
12924:
12925: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12926: l_oiev_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12927:
12928: l_mod_rec_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12929: l_mod_rec_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType;
12930: --------------------------------------------------------------------

Line 12955: OKC_OPER_INST_PUB.Create_Masschange_Dtls (

12951: -- l_omrv_rec_in.last_updated_by := OKC_API.G_MISS_NUM;
12952: l_omrv_rec_in.last_update_date := SYSDATE;
12953: l_omrv_rec_in.last_update_login := NULL ; --OKC_API.G_MISS_NUM;
12954:
12955: OKC_OPER_INST_PUB.Create_Masschange_Dtls (
12956: p_api_version => l_api_version,
12957: p_init_msg_list => l_init_msg_list,
12958: x_return_status => l_return_status,
12959: x_msg_count => l_msg_count,

Line 13031: x_ole_tbl OUT NOCOPY OKC_OPER_INST_PUB.olev_tbl_type) IS

13027: ---Create OKC_OPERATIONS_LINES
13028: ----------------------------------------------------------------------------
13029:
13030: PROCEDURE CREATE_OPERATION_LINES (p_ole_tbl IN ole_tbl_type, --olev_tbl_type,
13031: x_ole_tbl OUT NOCOPY OKC_OPER_INST_PUB.olev_tbl_type) IS
13032:
13033: ----------------------------------------------------------------------------
13034: ---TAPI variables
13035: ----------------------------------------------------------------------------

Line 13044: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13040: l_msg_data VARCHAR2(2000);
13041:
13042: l_msg_index_out NUMBER;
13043:
13044: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13045: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13046:
13047:
13048: ------------------------------------------------------------------

Line 13045: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13041:
13042: l_msg_index_out NUMBER;
13043:
13044: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13045: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13046:
13047:
13048: ------------------------------------------------------------------
13049: ---PROGRAM variables

Line 13083: OKC_OPER_INST_PUB.Create_Operation_Line(

13079: i:=i+1;
13080: j:=j+1;
13081: END LOOP;
13082:
13083: OKC_OPER_INST_PUB.Create_Operation_Line(
13084: p_api_version => l_api_version,
13085: p_init_msg_list => l_init_msg_list,
13086: x_return_status => l_return_status,
13087: x_msg_count => l_msg_count,

Line 13117: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13113: l_msg_data VARCHAR2(2000);
13114:
13115: l_msg_index_out NUMBER;
13116:
13117: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13118: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13119:
13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES
13121:

Line 13118: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13114:
13115: l_msg_index_out NUMBER;
13116:
13117: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13118: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13119:
13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES
13121:
13122: CURSOR Get_opn_lines IS

Line 13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES

13116:
13117: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13118: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13119:
13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES
13121:
13122: CURSOR Get_opn_lines IS
13123: SELECT ole.id ole_id,omr.id omr_id
13124: from OKC_OPERATION_LINES_V ole, OKC_MASSCHANGE_REQ_DTLS_V omr

Line 13150: OKC_OPER_INST_PUB.Delete_Masschange_Dtls (

13146: --dbms_output.put_line('Value of l_olev_tbl_in(i).oie_id='||TO_CHAR(l_olev_tbl_in(i).oie_id));
13147: i:=i+1;
13148: END LOOP;
13149:
13150: OKC_OPER_INST_PUB.Delete_Masschange_Dtls (
13151: p_api_version => l_api_version,
13152: p_init_msg_list => l_init_msg_list,
13153: x_return_status => l_return_status,
13154: x_msg_count => l_msg_count,

Line 13164: OKC_OPER_INST_PUB.Delete_Operation_Line(

13160: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
13161: RAISE OKC_API.G_EXCEPTION_ERROR;
13162: ELSIF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
13163:
13164: OKC_OPER_INST_PUB.Delete_Operation_Line(
13165: p_api_version => l_api_version,
13166: p_init_msg_list => l_init_msg_list,
13167: x_return_status => l_return_status,
13168: x_msg_count => l_msg_count,

Line 13195: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13191: l_return_status VARCHAR2(1);
13192: l_msg_count NUMBER;
13193: l_msg_data VARCHAR2(2000);
13194: l_msg_index_out NUMBER;
13195: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13196: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13197:
13198: l_mod_tbl_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType ;
13199: l_mod_tbl_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType ;

Line 13196: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES

13192: l_msg_count NUMBER;
13193: l_msg_data VARCHAR2(2000);
13194: l_msg_index_out NUMBER;
13195: l_olev_tbl_in OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13196: l_olev_tbl_out OKC_OPER_INST_PUB.olev_tbl_type; --OPERATION LINES
13197:
13198: l_mod_tbl_in OKS_MOD_PVT.OksMschgOperationsDtlsVRecType ;
13199: l_mod_tbl_out OKS_MOD_PVT.OksMschgOperationsDtlsVRecType ;
13200: p_mod_id NUMBER ;

Line 13209: OKC_OPER_INST_PUB.Update_Operation_Line(

13205:
13206: l_olev_tbl_in(1).id := p_ole_id ;
13207: l_olev_tbl_in(1).select_yn := p_select_yn ;
13208:
13209: OKC_OPER_INST_PUB.Update_Operation_Line(
13210: p_api_version => l_api_version,
13211: p_init_msg_list => l_init_msg_list,
13212: x_return_status => l_return_status,
13213: x_msg_count => l_msg_count,

Line 13218: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_return_status = ' || l_return_status);

13214: x_msg_data => l_msg_data,
13215: p_olev_tbl => l_olev_tbl_in,
13216: x_olev_tbl => l_olev_tbl_out );
13217:
13218: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_return_status = ' || l_return_status);
13219:
13220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
13221: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
13222: Rollback;

Line 13221: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);

13217:
13218: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_return_status = ' || l_return_status);
13219:
13220: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
13221: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
13222: Rollback;
13223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
13225: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);

Line 13225: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);

13221: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
13222: Rollback;
13223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
13224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
13225: LOG_MESSAGES('OKC_OPER_INST_PUB.Update_Operation_Line l_msg_data = ' || l_msg_data);
13226: Rollback;
13227: RAISE OKC_API.G_EXCEPTION_ERROR;
13228: END IF;
13229: