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_INTERFACE_LIST_HEADERS

Line 310: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',

306: orig_sys_pricing_attr_ref, error_message)
307: SELECT
308: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
309: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
310: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
311: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
312: FROM QP_INTERFACE_LIST_HEADERS qpih
313: WHERE qpih.name = p_entity_name
314: AND qpih.process_status_flag ='P' --is null

Line 312: FROM QP_INTERFACE_LIST_HEADERS qpih

308: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
309: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
310: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
311: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
312: FROM QP_INTERFACE_LIST_HEADERS qpih
313: WHERE qpih.name = p_entity_name
314: AND qpih.process_status_flag ='P' --is null
315: AND qpih.interface_action_code ='INSERT'
316: AND EXISTS(

Line 331: UPDATE qp_interface_list_headers qpih

327: /**
328: Load only if header with same orig_sys_hdr_ref is non existent
329: in qp tables for INSERT action
330: **/
331: UPDATE qp_interface_list_headers qpih
332: SET qpih.request_id = l_request_id, qpih.process_status_flag = 'P'
333: WHERE qpih.name = p_entity_name
334: AND (qpih.source_system_code IS NULL
335: or (qpih.source_system_code = nvl(l_source_system_code, qpih.source_system_code)))

Line 420: UPDATE qp_interface_list_headers qpih

416: /**
417: If interface action is update then load all null value interface columns
418: with values from corresponding qp table columns
419: **/
420: UPDATE qp_interface_list_headers qpih
421: SET ( creation_date,
422: created_by,
423: program_application_id,
424: program_id,

Line 932: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',

928: orig_sys_pricing_attr_ref, error_message)
929: SELECT
930: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
931: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
932: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
933: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
934: FROM QP_INTERFACE_LIST_HEADERS qpih
935: WHERE nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
936: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))

Line 934: FROM QP_INTERFACE_LIST_HEADERS qpih

930: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
931: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
932: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
933: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
934: FROM QP_INTERFACE_LIST_HEADERS qpih
935: WHERE nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
936: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))
937: AND qpih.process_status_flag ='P' --is null
938: AND qpih.interface_action_code ='INSERT'

Line 954: UPDATE qp_interface_list_headers qpih

950: Load only if header with same orig_sys_hdr_ref is non existent
951: in qp tables for INSERT action
952: **/
953: write_log('Entity Name Is null');
954: UPDATE qp_interface_list_headers qpih
955: SET qpih.request_id = l_request_id
956: WHERE qpih.request_id is null
957: AND (qpih.source_system_code IS NULL
958: or (qpih.source_system_code = nvl(l_source_system_code, qpih.source_system_code)))

Line 1037: UPDATE qp_interface_list_headers qpih

1033: /**
1034: If interface action is update then load all null value interface columns
1035: with values from corresponding qp table columns
1036: **/
1037: UPDATE qp_interface_list_headers qpih
1038: SET ( creation_date,
1039: created_by,
1040: program_application_id,
1041: program_id,

Line 1577: FROM qp_interface_qualifiers q,qp_interface_list_headers h

1573: UPDATE qp_interface_qualifiers qpiq
1574: SET qpiq.request_id = l_request_id
1575: WHERE qpiq.rowid IN
1576: (SELECT q.rowid
1577: FROM qp_interface_qualifiers q,qp_interface_list_headers h
1578: WHERE q.orig_sys_header_ref = h.orig_sys_header_ref
1579: AND q.request_id IS NULL
1580: AND q.process_status_flag = 'P'
1581: AND h.process_status_flag = 'I'

Line 2045: from qp_interface_list_lines l, qp_interface_list_headers h

2041: Update qp_interface_list_lines qpil
2042: Set qpil.request_id= l_request_id
2043: Where qpil.rowid IN
2044: (select l.rowid
2045: from qp_interface_list_lines l, qp_interface_list_headers h
2046: where h.process_status_flag='I'
2047: and l.process_status_flag = 'P'
2048: and l.request_id is null
2049: and h.request_id = l_request_id

Line 2849: FROM qp_interface_pricing_attribs pa, qp_interface_list_headers h

2845: UPDATE qp_interface_pricing_attribs qpip
2846: SET qpip.request_id = l_request_id
2847: WHERE qpip.rowid IN
2848: (SELECT pa.rowid
2849: FROM qp_interface_pricing_attribs pa, qp_interface_list_headers h
2850: WHERE h.process_status_flag='I'
2851: AND h.orig_sys_header_ref=pa.orig_sys_header_ref
2852: AND h.request_id = l_request_id
2853: AND pa.request_id IS NULL

Line 4657: UPDATE qp_interface_list_headers

4653:
4654: FORALL I IN G_INS_HEADER_REC.orig_sys_header_ref.FIRST..
4655: G_INS_HEADER_REC.orig_sys_header_ref.LAST
4656:
4657: UPDATE qp_interface_list_headers
4658: SET process_status_flag = decode(G_INS_HEADER_REC.process_status_flag(I),'P','I',G_INS_HEADER_REC.process_status_flag(I))
4659: WHERE nvl(orig_sys_header_ref,'*') = nvl(G_INS_HEADER_REC.orig_sys_header_ref(I),'*')
4660: AND request_id=p_request_id; -- Bug No: 6235177
4661:

Line 4682: UPDATE qp_interface_list_headers

4678:
4679: FORALL I IN G_UDT_HEADER_REC.orig_sys_header_ref.FIRST..
4680: G_UDT_HEADER_REC.orig_sys_header_ref.LAST
4681:
4682: UPDATE qp_interface_list_headers
4683: SET process_status_flag = decode(G_UDT_HEADER_REC.process_status_flag(I),'P','I',G_UDT_HEADER_REC.process_status_flag(I))
4684: WHERE nvl(orig_sys_header_ref,'*') = nvl(G_UDT_HEADER_REC.orig_sys_header_ref(I),'*')
4685: AND request_id = p_request_id; -- Bug No: 6235177
4686:

Line 4769: FROM qp_interface_qualifiers q, qp_interface_list_headers h

4765: ,q.ORIG_SYS_HEADER_REF
4766: ,q.ORIG_SYS_QUALIFIER_REF
4767: ,q.ORIG_SYS_LINE_REF
4768: ,q.QUALIFY_HIER_DESCENDENTS_FLAG
4769: FROM qp_interface_qualifiers q, qp_interface_list_headers h
4770: WHERE q.request_id = p_request_id
4771: AND h.request_id = p_request_id -- bug no 5881528
4772: AND h.orig_sys_header_ref = q.orig_sys_header_ref
4773: AND q.process_status_flag = 'P'

Line 4835: FROM qp_interface_qualifiers q, qp_interface_list_headers h

4831: ,q.ORIG_SYS_HEADER_REF
4832: ,q.ORIG_SYS_QUALIFIER_REF
4833: ,q.ORIG_SYS_LINE_REF
4834: ,q.QUALIFY_HIER_DESCENDENTS_FLAG
4835: FROM qp_interface_qualifiers q, qp_interface_list_headers h
4836: WHERE q.request_id = p_request_id
4837: AND h.request_id = p_request_id -- bug no 5881528
4838: AND h.orig_sys_header_ref = q.orig_sys_header_ref
4839: AND q.process_status_flag = 'P'

Line 6652: from qp_list_headers_b b, qp_interface_list_headers h

6648:
6649: Delete from qp_list_headers_tl
6650: where list_header_id IN
6651: (Select b.list_header_id
6652: from qp_list_headers_b b, qp_interface_list_headers h
6653: where h.request_id = p_request_id
6654: and b.orig_system_header_ref=h.orig_sys_header_ref
6655: and h.process_status_flag IS NULL
6656: and h.interface_action_code = 'INSERT'

Line 6666: from qp_interface_list_headers h

6662:
6663: Delete from qp_list_headers_b
6664: where orig_system_header_ref IN
6665: (Select orig_sys_header_ref
6666: from qp_interface_list_headers h
6667: where h.request_id = p_request_id
6668: and h.process_status_flag IS NULL
6669: and h.interface_action_code = 'INSERT'
6670: -- 6028305

Line 7064: if l_table_name = 'QP_INTERFACE_LIST_HEADERS' then

7060: l_orig_sys_qualifier_ref,
7061: l_error_message;
7062:
7063: EXIT WHEN c_errors%NOTFOUND;
7064: if l_table_name = 'QP_INTERFACE_LIST_HEADERS' then
7065: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7066: ||'/'||l_entity_type
7067: ||'/'||l_table_name
7068: ||'/'||l_orig_sys_header_ref

Line 7124: DELETE FROM qp_interface_list_headers

7120: DELETE FROM qp_interface_qualifiers
7121: WHERE request_id = p_request_id
7122: AND process_status_flag = 'I';
7123:
7124: DELETE FROM qp_interface_list_headers
7125: WHERE request_id = p_request_id
7126: AND process_status_flag = 'I';
7127:
7128: write_log('Leaving Purging');

Line 7170: from qp_interface_list_headers

7166: write_log( 'Complete...');
7167:
7168:
7169: Select count(*) into l_suc_head
7170: from qp_interface_list_headers
7171: where request_id = l_request_id
7172: and process_status_flag = 'I';
7173:
7174: Select count(*) into l_err_head

Line 7175: from qp_interface_list_headers

7171: where request_id = l_request_id
7172: and process_status_flag = 'I';
7173:
7174: Select count(*) into l_err_head
7175: from qp_interface_list_headers
7176: where request_id = l_request_id
7177: and process_status_flag IS NULL;
7178:
7179: Select count(*) into l_suc_qual