APPS.QP_BULK_VALUE_TO_ID dependencies on QP_INTERFACE_LIST_HEADERS

Line 18: Update qp_interface_list_headers ih

14: -- If Multi Currency Option is Set to Yes then process_status_flag should be set to 'E'
15: -- Fix for bug# 3570115
16:
17: If (NVL(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'),'N') = 'Y') THEN
18: Update qp_interface_list_headers ih
19: set (currency_header_id, process_status_flag, attribute_status)=
20: (select c.currency_header_id,
21: decode(c.currency_header_id, null, null, 'P'),
22: decode(c.currency_header_id, null, ih.attribute_status||'001', ih.attribute_status)

Line 24: qp_interface_list_headers iih

20: (select c.currency_header_id,
21: decode(c.currency_header_id, null, null, 'P'),
22: decode(c.currency_header_id, null, ih.attribute_status||'001', ih.attribute_status)
23: from qp_currency_lists_vl c,
24: qp_interface_list_headers iih
25: where iih.currency_header = c.name(+)
26: and iih.currency_code = c.base_currency_code(+)
27: and ih.rowid = iih.rowid
28: )

Line 40: Update qp_interface_list_headers ih

36: and ih.interface_action_code in ('INSERT','UPDATE');
37: End If;
38:
39: --2. Freight Terms Code
40: Update qp_interface_list_headers ih
41: set (freight_terms_code, process_status_flag, attribute_status)=
42: (select c.freight_terms_code,
43: decode(c.freight_terms_code, null, null, 'P'),
44: decode(c.freight_terms_code, null, ih.attribute_status||'002', ih.attribute_status)

Line 46: qp_interface_list_headers iih

42: (select c.freight_terms_code,
43: decode(c.freight_terms_code, null, null, 'P'),
44: decode(c.freight_terms_code, null, ih.attribute_status||'002', ih.attribute_status)
45: from OE_FRGHT_TERMS_ACTIVE_V c,
46: qp_interface_list_headers iih
47: where iih.freight_terms = c.freight_terms(+)
48: and sysdate between nvl(c.start_date_active, sysdate)
49: and nvl(c.end_date_active, sysdate)
50: and ih.rowid = iih.rowid

Line 63: Update qp_interface_list_headers ih

59: and ih.interface_action_code in ('INSERT','UPDATE');
60:
61: -- 3. Ship Method Code
62:
63: Update qp_interface_list_headers ih
64: set (ship_method_code, process_status_flag, attribute_status)=
65: (select c.lookup_code,
66: decode(c.lookup_code, null, null, 'P'),
67: decode(c.lookup_code, null, ih.attribute_status||'003', ih.attribute_status)

Line 69: qp_interface_list_headers iih

65: (select c.lookup_code,
66: decode(c.lookup_code, null, null, 'P'),
67: decode(c.lookup_code, null, ih.attribute_status||'003', ih.attribute_status)
68: from OE_SHIP_METHODS_V c,
69: qp_interface_list_headers iih
70: where iih.ship_method = c.meaning(+)
71: and c.lookup_type(+) = 'SHIP_METHOD'
72: and sysdate between nvl(c.start_date_active, sysdate)
73: and nvl(c.end_date_active, sysdate)

Line 87: Update qp_interface_list_headers ih

83: and ih.interface_action_code in ('INSERT','UPDATE');
84:
85: -- 4. Terms Id
86:
87: Update qp_interface_list_headers ih
88: set (terms_id, process_status_flag, attribute_status)=
89: (select c.term_id,
90: decode(c.term_id, null, null, 'P'),
91: decode(c.term_id, null, ih.attribute_status||'004', ih.attribute_status)

Line 93: qp_interface_list_headers iih

89: (select c.term_id,
90: decode(c.term_id, null, null, 'P'),
91: decode(c.term_id, null, ih.attribute_status||'004', ih.attribute_status)
92: from RA_TERMS c,
93: qp_interface_list_headers iih
94: where iih.terms = c.name(+)
95: and sysdate between nvl(c.start_date_active, sysdate)
96: and nvl(c.end_date_active, sysdate)
97: and ih.rowid = iih.rowid

Line 707: FROM qp_interface_list_headers

703: IS
704: CURSOR c_error_records IS
705: SELECT orig_sys_header_ref,
706: attribute_status
707: FROM qp_interface_list_headers
708: WHERE request_id = p_request_id
709: AND process_status_flag is null
710: AND attribute_status IS NOT NULL;
711:

Line 760: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,

756: orig_sys_pricing_attr_ref,error_message)
757: VALUES
758: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
759: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
760: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
761: l_err.orig_sys_header_ref,null,null,null,l_msg_txt);
762:
763: l_first:=l_first+3;
764: