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.QP_BULK_LOADER_PUB dependencies on QP_BULK_UTIL

Line 4640: QP_BULK_UTIL.LOAD_INS_HEADER

4636: BEGIN
4637:
4638: write_log('Inside Process Header');
4639:
4640: QP_BULK_UTIL.LOAD_INS_HEADER
4641: (p_request_id=>p_request_id
4642: ,x_header_rec=>G_INS_HEADER_REC);
4643:
4644: write_log('Records loaded for INS:'||G_INS_HEADER_REC.orig_sys_header_ref.count);

Line 4650: QP_BULK_UTIL.Insert_Header(p_header_rec=>G_INS_HEADER_REC);

4646: IF G_INS_HEADER_REC.orig_sys_header_ref.count>0 THEN
4647:
4648: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_INS_HEADER_REC);
4649:
4650: QP_BULK_UTIL.Insert_Header(p_header_rec=>G_INS_HEADER_REC);
4651: QP_BULK_MSG.Save_Message(p_request_id);
4652:
4653:
4654: FORALL I IN G_INS_HEADER_REC.orig_sys_header_ref.FIRST..

Line 4666: QP_BULK_UTIL.LOAD_UDT_HEADER

4662: write_log('Records Updated with process_status_flag: ' || sql%rowcount);
4663:
4664: END IF;
4665:
4666: QP_BULK_UTIL.LOAD_UDT_HEADER
4667: (p_request_id => p_request_id
4668: ,x_header_rec => G_UDT_HEADER_REC);
4669:
4670: write_log('Records loaded for UDT:'||G_UDT_HEADER_REC.orig_sys_header_ref.count);

Line 4676: QP_BULK_UTIL.Update_Header(p_header_rec=>G_UDT_HEADER_REC);

4672: IF G_UDT_HEADER_REC.orig_sys_header_ref.count>0 THEN
4673:
4674: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_UDT_HEADER_REC);
4675:
4676: QP_BULK_UTIL.Update_Header(p_header_rec=>G_UDT_HEADER_REC);
4677: QP_BULK_MSG.Save_Message(p_request_id);
4678:
4679: FORALL I IN G_UDT_HEADER_REC.orig_sys_header_ref.FIRST..
4680: G_UDT_HEADER_REC.orig_sys_header_ref.LAST

Line 4691: QP_BULK_UTIL.Delete_Header(p_request_id);

4687: write_log('Records Updated with process_status_flag:' || sql%rowcount);
4688: END IF;
4689:
4690:
4691: QP_BULK_UTIL.Delete_Header(p_request_id);
4692:
4693: QP_BULK_MSG.Save_Message(p_request_id);
4694:
4695: write_log('Leaving Process Header');

Line 4984: QP_BULK_UTIL.Insert_Qualifier(p_qualifier_rec=>G_INS_QUALIFIER_REC);

4980:
4981: QP_BULK_VALIDATE.ENTITY_QUALIFIER
4982: (p_qualifier_rec=>G_INS_QUALIFIER_REC);
4983:
4984: QP_BULK_UTIL.Insert_Qualifier(p_qualifier_rec=>G_INS_QUALIFIER_REC);
4985:
4986: QP_BULK_MSG.SAVE_MESSAGE(p_request_id);
4987:
4988: --set process_status_flag

Line 5135: QP_BULK_UTIL.Update_Qualifier(p_qualifier_rec=>G_UDT_QUALIFIER_REC);

5131:
5132: QP_BULK_VALIDATE.ENTITY_QUALIFIER
5133: (p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5134:
5135: QP_BULK_UTIL.Update_Qualifier(p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5136:
5137: QP_BULK_MSG.SAVE_MESSAGE(p_request_id);
5138:
5139: --set process_status_flag

Line 5162: QP_BULK_UTIL.Delete_Qualifier(p_request_id);

5158:
5159:
5160: QP_BULK_MSG.SAVE_MESSAGE(p_request_id);
5161:
5162: QP_BULK_UTIL.Delete_Qualifier(p_request_id);
5163:
5164: write_log('Existing Process Qualifier');
5165:
5166: EXCEPTION

Line 5660: QP_BULK_UTIL.Insert_line(G_INS_LINE_REC);

5656:
5657:
5658: -- end bug 6028305
5659:
5660: QP_BULK_UTIL.Insert_line(G_INS_LINE_REC);
5661:
5662: --set process_status_flag
5663: FORALL I IN G_INS_LINE_REC.orig_sys_line_ref.FIRST
5664: ..G_INS_LINE_REC.orig_sys_line_ref.LAST

Line 6003: QP_BULK_UTIL.Update_line(G_UDT_LINE_REC);

5999: and qill2.price_break_header_ref=qill1.orig_sys_line_ref);
6000: COMMIT;
6001: end if;
6002:
6003: QP_BULK_UTIL.Update_line(G_UDT_LINE_REC);
6004:
6005:
6006: --set process_status_flag
6007: FORALL I IN G_UDT_LINE_REC.orig_sys_line_ref.FIRST

Line 6022: QP_BULK_UTIL.UPDATE_LINE_TO_OLD(G_UDT_LINE_REC_OLD);

6018: -- changes for bug no 6028305
6019: Process_pricing_attr(p_request_id,p_process_parent);
6020: -- update the parent back 6028305
6021: if p_process_parent='N' then
6022: QP_BULK_UTIL.UPDATE_LINE_TO_OLD(G_UDT_LINE_REC_OLD);
6023: end if;
6024:
6025: END IF;
6026:

Line 6031: QP_BULK_UTIL.Delete_Line(p_request_id);

6027: EXIT WHEN C_UDT_LINE%NOTFOUND;
6028: END LOOP;
6029: CLOSE C_UDT_LINE;
6030:
6031: QP_BULK_UTIL.Delete_Line(p_request_id);
6032:
6033: write_log('Existing Process Line');
6034:
6035: EXCEPTION

Line 6393: QP_BULK_UTIL.Insert_pricing_attr(G_INS_PRICING_ATTR_REC);

6389:
6390: COMMIT;
6391: end if;
6392:
6393: QP_BULK_UTIL.Insert_pricing_attr(G_INS_PRICING_ATTR_REC);
6394:
6395: --set the process_status_flag
6396: FORALL I IN G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6397: ..G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST

Line 6610: QP_BULK_UTIL.Update_pricing_attr(G_UDT_PRICING_ATTR_REC);

6606: write_log( 'Number of attribute lines picked1: '||SQL%ROWCOUNT);
6607: commit;
6608: end if;
6609:
6610: QP_BULK_UTIL.Update_pricing_attr(G_UDT_PRICING_ATTR_REC);
6611:
6612: --set the process_status_flag
6613: FORALL I IN G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6614: ..G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST

Line 6630: QP_BULK_UTIL.Delete_Pricing_Attr(p_request_id);

6626: CLOSE C_UDT_PRICING_ATTR;
6627:
6628: Post_cleanup_Line(p_request_id); --delete all the errored records
6629:
6630: QP_BULK_UTIL.Delete_Pricing_Attr(p_request_id);
6631:
6632: write_log('Leaving Process Pricing Attribute');
6633: EXCEPTION
6634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN