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_QUALIFIERS

Line 1685: UPDATE qp_interface_qualifiers qpiq

1681:
1682: END IF;
1683:
1684: -- Bug 5208480(5208112,4188784) RAVI
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

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 1722: UPDATE qp_interface_qualifiers qpiq

1718: /**
1719: If interface action is update then load all null value interface columns
1720: with values from corresponding qp table columns
1721: **/
1722: UPDATE qp_interface_qualifiers qpiq
1723: SET ( active_flag,
1724: attribute1,
1725: attribute10,
1726: attribute11,

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 5111: UPDATE qp_interface_qualifiers

5107: --set process_status_flag
5108:
5109: FORALL I IN G_INS_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST
5110: ..G_INS_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
5111: UPDATE qp_interface_qualifiers
5112: SET process_status_flag = decode(G_INS_QUALIFIER_REC.process_status_flag(I),'P','I',G_INS_QUALIFIER_REC.process_status_flag(I))
5113: WHERE -- orig_sys_header_ref = G_INS_QUALIFIER_REC.orig_sys_header_ref(I) --commented for bug8359604
5114: orig_sys_qualifier_ref = G_INS_QUALIFIER_REC.orig_sys_qualifier_ref(I)
5115: AND request_id = p_request_id; --Bug No: 6235177

Line 5262: UPDATE qp_interface_qualifiers

5258: --set process_status_flag
5259:
5260: FORALL I IN G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST
5261: ..G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
5262: UPDATE qp_interface_qualifiers
5263: SET process_status_flag = decode(G_UDT_QUALIFIER_REC.process_status_flag(I),'P','I',G_UDT_QUALIFIER_REC.process_status_flag(I))
5264: WHERE -- orig_sys_header_ref = G_UDT_QUALIFIER_REC.orig_sys_header_ref(I) --Commented for bug8359604
5265: orig_sys_qualifier_ref = G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref(I)
5266: AND request_id = p_request_id; -- Bug No: 6235177

Line 6803: from qp_interface_qualifiers iq, qp_qualifiers q

6799:
6800: Delete from qp_qualifiers
6801: where rowid IN
6802: (Select q.rowid
6803: from qp_interface_qualifiers iq, qp_qualifiers q
6804: where iq.request_id = p_request_id
6805: and q.request_id= p_request_id -- changes made by rassharm 6028305
6806: and iq.process_status_flag IS NULL
6807: and iq.interface_action_code = 'INSERT'

Line 7244: DELETE FROM qp_interface_qualifiers

7240: DELETE FROM qp_interface_list_lines
7241: WHERE request_id = p_request_id
7242: AND process_status_flag = 'I';
7243:
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

Line 7304: from qp_interface_qualifiers

7300: where request_id = l_request_id
7301: and process_status_flag IS NULL;
7302:
7303: Select count(*) into l_suc_qual
7304: from qp_interface_qualifiers
7305: where request_id = l_request_id
7306: and process_status_flag = 'I';
7307:
7308: Select count(*) into l_err_qual

Line 7309: from qp_interface_qualifiers

7305: where request_id = l_request_id
7306: and process_status_flag = 'I';
7307:
7308: Select count(*) into l_err_qual
7309: from qp_interface_qualifiers
7310: where request_id = l_request_id
7311: and process_status_flag IS NULL;
7312:
7313: purge(l_request_id);