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 422: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',

418: orig_sys_pricing_attr_ref, error_message)
419: SELECT
420: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
421: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
422: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
423: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
424: FROM QP_INTERFACE_LIST_HEADERS qpih
425: WHERE qpih.name = p_entity_name
426: AND qpih.process_status_flag ='P' --is null

Line 424: FROM QP_INTERFACE_LIST_HEADERS qpih

420: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
421: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
422: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
423: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
424: FROM QP_INTERFACE_LIST_HEADERS qpih
425: WHERE qpih.name = p_entity_name
426: AND qpih.process_status_flag ='P' --is null
427: AND qpih.interface_action_code ='INSERT'
428: AND EXISTS(

Line 443: UPDATE qp_interface_list_headers qpih

439: /**
440: Load only if header with same orig_sys_hdr_ref is non existent
441: in qp tables for INSERT action
442: **/
443: UPDATE qp_interface_list_headers qpih
444: SET qpih.request_id = l_request_id, qpih.process_status_flag = 'P'
445: WHERE qpih.name = p_entity_name
446: AND (qpih.source_system_code IS NULL
447: or (qpih.source_system_code = nvl(l_source_system_code, qpih.source_system_code)))

Line 532: UPDATE qp_interface_list_headers qpih

528: /**
529: If interface action is update then load all null value interface columns
530: with values from corresponding qp table columns
531: **/
532: UPDATE qp_interface_list_headers qpih
533: SET ( creation_date,
534: created_by,
535: program_application_id,
536: program_id,

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

1040: orig_sys_pricing_attr_ref, error_message)
1041: SELECT
1042: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1043: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
1044: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
1045: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
1046: FROM QP_INTERFACE_LIST_HEADERS qpih
1047: WHERE nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
1048: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))

Line 1046: FROM QP_INTERFACE_LIST_HEADERS qpih

1042: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1043: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, l_request_id, 661,
1044: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
1045: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
1046: FROM QP_INTERFACE_LIST_HEADERS qpih
1047: WHERE nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
1048: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))
1049: AND qpih.process_status_flag ='P' --is null
1050: AND qpih.interface_action_code ='INSERT'

Line 1066: UPDATE qp_interface_list_headers qpih

1062: Load only if header with same orig_sys_hdr_ref is non existent
1063: in qp tables for INSERT action
1064: **/
1065: write_log('Entity Name Is null');
1066: UPDATE qp_interface_list_headers qpih
1067: SET qpih.request_id = l_request_id
1068: WHERE qpih.request_id is null
1069: AND (qpih.source_system_code IS NULL
1070: or (qpih.source_system_code = nvl(l_source_system_code, qpih.source_system_code)))

Line 1149: UPDATE qp_interface_list_headers qpih

1145: /**
1146: If interface action is update then load all null value interface columns
1147: with values from corresponding qp table columns
1148: **/
1149: UPDATE qp_interface_list_headers qpih
1150: SET ( creation_date,
1151: created_by,
1152: program_application_id,
1153: program_id,

Line 1689: FROM qp_interface_qualifiers q,qp_interface_list_headers h

1685: UPDATE qp_interface_qualifiers qpiq
1686: SET qpiq.request_id = l_request_id
1687: WHERE qpiq.rowid IN
1688: (SELECT q.rowid
1689: FROM qp_interface_qualifiers q,qp_interface_list_headers h
1690: WHERE q.orig_sys_header_ref = h.orig_sys_header_ref
1691: AND q.request_id IS NULL
1692: AND q.process_status_flag = 'P'
1693: AND h.process_status_flag = 'I'

Line 2157: from qp_interface_list_lines l, qp_interface_list_headers h

2153: Update qp_interface_list_lines qpil
2154: Set qpil.request_id= l_request_id
2155: Where qpil.rowid IN
2156: (select l.rowid
2157: from qp_interface_list_lines l, qp_interface_list_headers h
2158: where h.process_status_flag='I'
2159: and l.process_status_flag = 'P'
2160: and l.request_id is null
2161: and h.request_id = l_request_id

Line 2964: FROM qp_interface_pricing_attribs pa, qp_interface_list_headers h

2960: UPDATE qp_interface_pricing_attribs qpip
2961: SET qpip.request_id = l_request_id
2962: WHERE qpip.rowid IN
2963: (SELECT pa.rowid
2964: FROM qp_interface_pricing_attribs pa, qp_interface_list_headers h
2965: WHERE h.process_status_flag='I'
2966: AND h.orig_sys_header_ref=pa.orig_sys_header_ref
2967: AND h.request_id = l_request_id
2968: AND pa.request_id IS NULL

Line 4776: UPDATE qp_interface_list_headers

4772:
4773: FORALL I IN G_INS_HEADER_REC.orig_sys_header_ref.FIRST..
4774: G_INS_HEADER_REC.orig_sys_header_ref.LAST
4775:
4776: UPDATE qp_interface_list_headers
4777: SET process_status_flag = decode(G_INS_HEADER_REC.process_status_flag(I),'P','I',G_INS_HEADER_REC.process_status_flag(I))
4778: WHERE nvl(orig_sys_header_ref,'*') = nvl(G_INS_HEADER_REC.orig_sys_header_ref(I),'*')
4779: AND request_id=p_request_id; -- Bug No: 6235177
4780:

Line 4801: UPDATE qp_interface_list_headers

4797:
4798: FORALL I IN G_UDT_HEADER_REC.orig_sys_header_ref.FIRST..
4799: G_UDT_HEADER_REC.orig_sys_header_ref.LAST
4800:
4801: UPDATE qp_interface_list_headers
4802: SET process_status_flag = decode(G_UDT_HEADER_REC.process_status_flag(I),'P','I',G_UDT_HEADER_REC.process_status_flag(I))
4803: WHERE nvl(orig_sys_header_ref,'*') = nvl(G_UDT_HEADER_REC.orig_sys_header_ref(I),'*')
4804: AND request_id = p_request_id; -- Bug No: 6235177
4805:

Line 4888: FROM qp_interface_qualifiers q, qp_interface_list_headers h

4884: ,q.ORIG_SYS_HEADER_REF
4885: ,q.ORIG_SYS_QUALIFIER_REF
4886: ,q.ORIG_SYS_LINE_REF
4887: ,q.QUALIFY_HIER_DESCENDENTS_FLAG
4888: FROM qp_interface_qualifiers q, qp_interface_list_headers h
4889: WHERE q.request_id = p_request_id
4890: AND h.request_id = p_request_id -- bug no 5881528
4891: AND h.orig_sys_header_ref = q.orig_sys_header_ref
4892: AND q.process_status_flag = 'P'

Line 4954: FROM qp_interface_qualifiers q, qp_interface_list_headers h

4950: ,q.ORIG_SYS_HEADER_REF
4951: ,q.ORIG_SYS_QUALIFIER_REF
4952: ,q.ORIG_SYS_LINE_REF
4953: ,q.QUALIFY_HIER_DESCENDENTS_FLAG
4954: FROM qp_interface_qualifiers q, qp_interface_list_headers h
4955: WHERE q.request_id = p_request_id
4956: AND h.request_id = p_request_id -- bug no 5881528
4957: AND h.orig_sys_header_ref = q.orig_sys_header_ref
4958: AND q.process_status_flag = 'P'

Line 6776: from qp_list_headers_b b, qp_interface_list_headers h

6772:
6773: Delete from qp_list_headers_tl
6774: where list_header_id IN
6775: (Select b.list_header_id
6776: from qp_list_headers_b b, qp_interface_list_headers h
6777: where h.request_id = p_request_id
6778: and b.orig_system_header_ref=h.orig_sys_header_ref
6779: and h.process_status_flag IS NULL
6780: and h.interface_action_code = 'INSERT'

Line 6790: from qp_interface_list_headers h

6786:
6787: Delete from qp_list_headers_b
6788: where orig_system_header_ref IN
6789: (Select orig_sys_header_ref
6790: from qp_interface_list_headers h
6791: where h.request_id = p_request_id
6792: and h.process_status_flag IS NULL
6793: and h.interface_action_code = 'INSERT'
6794: -- 6028305

Line 7188: if l_table_name = 'QP_INTERFACE_LIST_HEADERS' then

7184: l_orig_sys_qualifier_ref,
7185: l_error_message;
7186:
7187: EXIT WHEN c_errors%NOTFOUND;
7188: if l_table_name = 'QP_INTERFACE_LIST_HEADERS' then
7189: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7190: ||'/'||l_entity_type
7191: ||'/'||l_table_name
7192: ||'/'||l_orig_sys_header_ref

Line 7248: DELETE FROM qp_interface_list_headers

7244: DELETE FROM qp_interface_qualifiers
7245: WHERE request_id = p_request_id
7246: AND process_status_flag = 'I';
7247:
7248: DELETE FROM qp_interface_list_headers
7249: WHERE request_id = p_request_id
7250: AND process_status_flag = 'I';
7251:
7252: write_log('Leaving Purging');

Line 7294: from qp_interface_list_headers

7290: write_log( 'Complete...');
7291:
7292:
7293: Select count(*) into l_suc_head
7294: from qp_interface_list_headers
7295: where request_id = l_request_id
7296: and process_status_flag = 'I';
7297:
7298: Select count(*) into l_err_head

Line 7299: from qp_interface_list_headers

7295: where request_id = l_request_id
7296: and process_status_flag = 'I';
7297:
7298: Select count(*) into l_err_head
7299: from qp_interface_list_headers
7300: where request_id = l_request_id
7301: and process_status_flag IS NULL;
7302:
7303: Select count(*) into l_suc_qual