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

1569:
1570: END IF;
1571:
1572: -- Bug 5208480(5208112,4188784) RAVI
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

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

1606: /**
1607: If interface action is update then load all null value interface columns
1608: with values from corresponding qp table columns
1609: **/
1610: UPDATE qp_interface_qualifiers qpiq
1611: SET ( active_flag,
1612: attribute1,
1613: attribute10,
1614: attribute11,

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

4988: --set process_status_flag
4989:
4990: FORALL I IN G_INS_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST
4991: ..G_INS_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
4992: UPDATE qp_interface_qualifiers
4993: SET process_status_flag = decode(G_INS_QUALIFIER_REC.process_status_flag(I),'P','I',G_INS_QUALIFIER_REC.process_status_flag(I))
4994: WHERE orig_sys_header_ref = G_INS_QUALIFIER_REC.orig_sys_header_ref(I)
4995: AND orig_sys_qualifier_ref = G_INS_QUALIFIER_REC.orig_sys_qualifier_ref(I)
4996: AND request_id = p_request_id; --Bug No: 6235177

Line 5143: UPDATE qp_interface_qualifiers

5139: --set process_status_flag
5140:
5141: FORALL I IN G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST
5142: ..G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
5143: UPDATE qp_interface_qualifiers
5144: SET process_status_flag = decode(G_UDT_QUALIFIER_REC.process_status_flag(I),'P','I',G_UDT_QUALIFIER_REC.process_status_flag(I))
5145: WHERE orig_sys_header_ref = G_UDT_QUALIFIER_REC.orig_sys_header_ref(I)
5146: AND orig_sys_qualifier_ref = G_UDT_QUALIFIER_REC.orig_sys_qualifier_ref(I)
5147: AND request_id = p_request_id; -- Bug No: 6235177

Line 6679: from qp_interface_qualifiers iq, qp_qualifiers q

6675:
6676: Delete from qp_qualifiers
6677: where rowid IN
6678: (Select q.rowid
6679: from qp_interface_qualifiers iq, qp_qualifiers q
6680: where iq.request_id = p_request_id
6681: and q.request_id= p_request_id -- changes made by rassharm 6028305
6682: and iq.process_status_flag IS NULL
6683: and iq.interface_action_code = 'INSERT'

Line 7120: DELETE FROM qp_interface_qualifiers

7116: DELETE FROM qp_interface_list_lines
7117: WHERE request_id = p_request_id
7118: AND process_status_flag = 'I';
7119:
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

Line 7180: from qp_interface_qualifiers

7176: where request_id = l_request_id
7177: and process_status_flag IS NULL;
7178:
7179: Select count(*) into l_suc_qual
7180: from qp_interface_qualifiers
7181: where request_id = l_request_id
7182: and process_status_flag = 'I';
7183:
7184: Select count(*) into l_err_qual

Line 7185: from qp_interface_qualifiers

7181: where request_id = l_request_id
7182: and process_status_flag = 'I';
7183:
7184: Select count(*) into l_err_qual
7185: from qp_interface_qualifiers
7186: where request_id = l_request_id
7187: and process_status_flag IS NULL;
7188:
7189: purge(l_request_id);