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_PRICING_ATTRIBS

Line 2845: UPDATE qp_interface_pricing_attribs qpip

2841: and qpil.interface_action_code IN ('UPDATE','DELETE');
2842:
2843:
2844: -- Bug 5208480(5208112,4188784) RAVI
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

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 2907: UPDATE qp_interface_pricing_attribs qpip

2903: /**
2904: If interface action is update then load all null value interface columns
2905: with values from corresponding qp table columns
2906: **/
2907: UPDATE qp_interface_pricing_attribs qpip
2908: SET ( accumulate_flag,
2909: attribute_grouping_no,
2910: attribute1,
2911: attribute10,

Line 3299: UPDATE qp_interface_pricing_attribs qpip

3295: and qpip.process_status_flag = 'P'
3296: and qpip.interface_action_code IN ('UPDATE','DELETE');
3297:
3298: --Highest Price Break Value To '9999...999' if it is null
3299: UPDATE qp_interface_pricing_attribs qpip
3300: SET qpip.pricing_attr_value_to = '999999999999999'
3301: WHERE qpip.request_id = l_request_id
3302: AND EXISTS (
3303: SELECT 'YES'

Line 3345: FROM qp_interface_pricing_attribs

3341: WHERE request_id = l_request_id
3342: AND process_status_flag = 'P'
3343: UNION
3344: SELECT 'Y'
3345: FROM qp_interface_pricing_attribs
3346: WHERE request_id = l_request_id
3347: AND process_status_flag = 'P');
3348:
3349: IF l_count > 0 THEN

Line 4221: UPDATE qp_interface_pricing_attribs qpip

4217: **/
4218: -- Bug#5353889 RAVI END
4219:
4220: -- Update Pricing attributes records with request id
4221: UPDATE qp_interface_pricing_attribs qpip
4222: SET qpip.request_id = l_request_id
4223: WHERE qpip.rowid IN
4224: ((SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4225: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

Line 4225: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

4221: UPDATE qp_interface_pricing_attribs qpip
4222: SET qpip.request_id = l_request_id
4223: WHERE qpip.rowid IN
4224: ((SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4225: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa
4226: WHERE l.request_id = l_request_id
4227: AND (pa.request_id = p_request_id or pa.request_id is NULL)
4228: AND pa.process_status_flag = 'P'
4229: AND l.process_status_flag = 'P'

Line 4238: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

4234: -- End Bug No: 6235177
4235: AND pa.orig_sys_line_ref = l.orig_sys_line_ref)
4236: UNION
4237: (SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4238: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa
4239: WHERE l.process_status_flag = 'I'
4240: AND (pa.request_id = p_request_id or pa.request_id is NULL)
4241: AND pa.process_status_flag = 'P'
4242: -- Begin Bug No: 6235177

Line 4269: UPDATE qp_interface_pricing_attribs qpip

4265: **/
4266: -- Bug#5353889 RAVI START
4267: -- Comment the update as the updates are already done.
4268: /**
4269: UPDATE qp_interface_pricing_attribs qpip
4270: SET ( accumulate_flag,
4271: attribute_grouping_no,
4272: attribute1,
4273: attribute10,

Line 4588: FROM qp_interface_pricing_attribs

4584: WHERE request_id = l_request_id
4585: AND process_status_flag IS NULL;
4586:
4587: SELECT count(*) INTO l_suc_pr_attr
4588: FROM qp_interface_pricing_attribs
4589: WHERE request_id = l_request_id
4590: AND process_status_flag = 'I';
4591:
4592: SELECT count(*) INTO l_err_pr_attr

Line 4593: FROM qp_interface_pricing_attribs

4589: WHERE request_id = l_request_id
4590: AND process_status_flag = 'I';
4591:
4592: SELECT count(*) INTO l_err_pr_attr
4593: FROM qp_interface_pricing_attribs
4594: WHERE request_id = l_request_id
4595: AND process_status_flag IS NULL;
4596:
4597: purge(l_request_id);

Line 6113: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l

6109: ,pa.PRICING_ATTR_VALUE_TO_DISP
6110: ,pa.ATTRIBUTE_STATUS
6111: ,pa.ORIG_SYS_LINE_REF
6112: ,pa.ORIG_SYS_HEADER_REF
6113: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l
6114: WHERE pa.request_id = p_request_id
6115: AND l.request_id = p_request_id -- bug no 5881528
6116: AND l.orig_sys_line_ref = pa.orig_sys_line_ref
6117: AND l.process_status_flag = 'I'

Line 6182: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l

6178: ,pa.PRICING_ATTR_VALUE_TO_DISP
6179: ,pa.ATTRIBUTE_STATUS
6180: ,pa.ORIG_SYS_LINE_REF
6181: ,pa.ORIG_SYS_HEADER_REF
6182: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l
6183: WHERE pa.request_id = p_request_id
6184: AND l.request_id = p_request_id -- bug no 5881528
6185: AND l.orig_sys_line_ref = pa.orig_sys_line_ref
6186: AND l.process_status_flag = 'I'

Line 6336: update qp_interface_pricing_Attribs qill1

6332: -- 6028305
6333: if p_process_parent='N' then
6334:
6335: --if any price break of this header line fails validation in this request
6336: update qp_interface_pricing_Attribs qill1
6337: set qill1.process_status_flag=null
6338: where qill1.PRICING_ATTR_CODE is null
6339: and qill1.request_id=p_request_id
6340: and qill1.process_status_flag is not null

Line 6344: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3

6340: and qill1.process_status_flag is not null
6341: and exists
6342:
6343: (select 'Y'
6344: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6345: where q1.process_status_flag is null
6346: and q1.request_id=p_request_id
6347: and q2.request_id=p_request_id
6348: and q3.request_id=p_request_id

Line 6357: update qp_interface_pricing_Attribs qill1

6353: and q1.ORIG_SYS_HEADER_REF=q2.ORIG_SYS_HEADER_REF
6354: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6355:
6356: -- Deleting all child if the siblings fail
6357: update qp_interface_pricing_Attribs qill1
6358: set qill1.process_status_flag=null
6359: where qill1.PRICING_ATTR_CODE is not null
6360: and qill1.request_id=p_request_id
6361: and qill1.process_status_flag is not null

Line 6364: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3

6360: and qill1.request_id=p_request_id
6361: and qill1.process_status_flag is not null
6362: and exists
6363: (select 'Y'
6364: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6365: where q1.process_status_flag is null
6366: and q1.request_id=p_request_id
6367: and q2.request_id=p_request_id
6368: and q3.request_id=p_request_id

Line 6384: from qp_interface_pricing_Attribs q1

6380: where qill.request_id=p_request_id
6381: and qill.process_status_flag is not null
6382: and exists
6383: ( select 'Y'
6384: from qp_interface_pricing_Attribs q1
6385: where q1.process_status_flag is null
6386: and q1.request_id=p_request_id
6387: and q1.ORIG_SYS_HEADER_REF=qill.ORIG_SYS_HEADER_REF
6388: and q1.ORIG_SYS_LINE_REF=qill.ORIG_SYS_LINE_REF);

Line 6398: UPDATE qp_interface_pricing_attribs

6394:
6395: --set the process_status_flag
6396: FORALL I IN G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6397: ..G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
6398: UPDATE qp_interface_pricing_attribs
6399: SET process_status_flag = decode(G_INS_PRICING_ATTR_REC.process_status_flag(I),'P','I',G_INS_PRICING_ATTR_REC.process_status_flag(I))
6400: WHERE orig_sys_pricing_attr_ref = G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref(I)
6401: AND orig_sys_line_ref = G_INS_PRICING_ATTR_REC.orig_sys_line_ref(I)
6402: AND orig_sys_header_ref = G_INS_PRICING_ATTR_REC.orig_sys_header_ref(I)

Line 6551: update qp_interface_pricing_Attribs qill1

6547:
6548: if p_process_parent='N' then
6549:
6550: --if any price break of this header line fails validation in this request
6551: update qp_interface_pricing_Attribs qill1
6552: set qill1.process_status_flag=null
6553: where qill1.PRICING_ATTR_CODE is null
6554: and qill1.request_id=p_request_id
6555: and qill1.process_status_flag is not null

Line 6559: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3

6555: and qill1.process_status_flag is not null
6556: and exists
6557:
6558: (select 'Y'
6559: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6560: where q1.process_status_flag is null
6561: and q1.request_id=p_request_id
6562: and q2.request_id=p_request_id
6563: and q3.request_id=p_request_id

Line 6573: update qp_interface_pricing_Attribs qill1

6569: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6570:
6571: write_log( 'Number of attribute lines picked1: '||SQL%ROWCOUNT);
6572: -- Deleting all child if the siblings fail
6573: update qp_interface_pricing_Attribs qill1
6574: set qill1.process_status_flag=null
6575: where qill1.PRICING_ATTR_CODE is not null
6576: and qill1.request_id=p_request_id
6577: and qill1.process_status_flag is not null

Line 6580: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3

6576: and qill1.request_id=p_request_id
6577: and qill1.process_status_flag is not null
6578: and exists
6579: (select 'Y'
6580: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6581: where q1.process_status_flag is null
6582: and q1.request_id=p_request_id
6583: and q2.request_id=p_request_id
6584: and q3.request_id=p_request_id

Line 6600: from qp_interface_pricing_Attribs q1

6596: where qill.request_id=p_request_id
6597: and qill.process_status_flag is not null
6598: and exists
6599: ( select 'Y'
6600: from qp_interface_pricing_Attribs q1
6601: where q1.process_status_flag is null
6602: and q1.request_id=p_request_id
6603: and q1.ORIG_SYS_HEADER_REF=qill.ORIG_SYS_HEADER_REF
6604: and q1.ORIG_SYS_LINE_REF=qill.ORIG_SYS_LINE_REF);

Line 6615: UPDATE qp_interface_pricing_attribs

6611:
6612: --set the process_status_flag
6613: FORALL I IN G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6614: ..G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
6615: UPDATE qp_interface_pricing_attribs
6616: SET process_status_flag = decode(G_UDT_PRICING_ATTR_REC.process_status_flag(I),'P','I',G_UDT_PRICING_ATTR_REC.process_status_flag(I))
6617: WHERE orig_sys_pricing_attr_ref = G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref(I)
6618: AND orig_sys_line_ref = G_UDT_PRICING_ATTR_REC.orig_sys_line_ref(I)
6619: AND orig_sys_header_ref = G_UDT_PRICING_ATTR_REC.orig_sys_header_ref(I)

Line 6734: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa

6730:
6731: Delete from qp_pricing_attributes
6732: where pricing_attribute_id IN
6733: (Select pa.pricing_attribute_id
6734: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa
6735: where ipa.request_id = p_request_id
6736: and pa.request_id = p_request_id -- changes made by rassharm 6028305
6737: and ipa.process_status_flag IS NULL
6738: and ipa.interface_action_code ='INSERT'

Line 6909: FROM qp_interface_pricing_attribs

6905: CURSOR c_pricing_attr IS
6906: SELECT orig_sys_pricing_attr_ref,
6907: orig_sys_line_ref,
6908: orig_sys_header_ref
6909: FROM qp_interface_pricing_attribs
6910: WHERE request_id = p_request_id
6911: AND process_status_flag IS NULL;
6912:
6913: CURSOR c_pbh_child_line IS

Line 7112: DELETE FROM qp_interface_pricing_attribs

7108: (p_request_id NUMBER)
7109: IS
7110: BEGIN
7111: write_log('Entering Purging');
7112: DELETE FROM qp_interface_pricing_attribs
7113: WHERE request_id = p_request_id
7114: AND process_status_flag = 'I';
7115:
7116: DELETE FROM qp_interface_list_lines