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

2956: and qpil.interface_action_code IN ('UPDATE','DELETE');
2957:
2958:
2959: -- Bug 5208480(5208112,4188784) RAVI
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

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

3022: /**
3023: If interface action is update then load all null value interface columns
3024: with values from corresponding qp table columns
3025: **/
3026: UPDATE qp_interface_pricing_attribs qpip
3027: SET ( accumulate_flag,
3028: attribute_grouping_no,
3029: attribute1,
3030: attribute10,

Line 3418: UPDATE qp_interface_pricing_attribs qpip

3414: and qpip.process_status_flag = 'P'
3415: and qpip.interface_action_code IN ('UPDATE','DELETE');
3416:
3417: --Highest Price Break Value To '9999...999' if it is null
3418: UPDATE qp_interface_pricing_attribs qpip
3419: SET qpip.pricing_attr_value_to = '999999999999999'
3420: WHERE qpip.request_id = l_request_id
3421: AND EXISTS (
3422: SELECT 'YES'

Line 3464: FROM qp_interface_pricing_attribs

3460: WHERE request_id = l_request_id
3461: AND process_status_flag = 'P'
3462: UNION
3463: SELECT 'Y'
3464: FROM qp_interface_pricing_attribs
3465: WHERE request_id = l_request_id
3466: AND process_status_flag = 'P');
3467:
3468: IF l_count > 0 THEN

Line 4340: UPDATE qp_interface_pricing_attribs qpip

4336: **/
4337: -- Bug#5353889 RAVI END
4338:
4339: -- Update Pricing attributes records with request id
4340: UPDATE qp_interface_pricing_attribs qpip
4341: SET qpip.request_id = l_request_id
4342: WHERE qpip.rowid IN
4343: ((SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4344: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

Line 4344: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

4340: UPDATE qp_interface_pricing_attribs qpip
4341: SET qpip.request_id = l_request_id
4342: WHERE qpip.rowid IN
4343: ((SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4344: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa
4345: WHERE l.request_id = l_request_id
4346: AND (pa.request_id = p_request_id or pa.request_id is NULL)
4347: AND pa.process_status_flag = 'P'
4348: AND l.process_status_flag = 'P'

Line 4357: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa

4353: -- End Bug No: 6235177
4354: AND pa.orig_sys_line_ref = l.orig_sys_line_ref)
4355: UNION
4356: (SELECT /*+ index(PA QP_INTERFACE_PRCNG_ATTRIBS_N4)*/ pa.ROWID --7433219
4357: FROM qp_interface_list_lines l, qp_interface_pricing_attribs pa
4358: WHERE l.process_status_flag = 'I'
4359: AND (pa.request_id = p_request_id or pa.request_id is NULL)
4360: AND pa.process_status_flag = 'P'
4361: -- Begin Bug No: 6235177

Line 4388: UPDATE qp_interface_pricing_attribs qpip

4384: **/
4385: -- Bug#5353889 RAVI START
4386: -- Comment the update as the updates are already done.
4387: /**
4388: UPDATE qp_interface_pricing_attribs qpip
4389: SET ( accumulate_flag,
4390: attribute_grouping_no,
4391: attribute1,
4392: attribute10,

Line 4707: FROM qp_interface_pricing_attribs

4703: WHERE request_id = l_request_id
4704: AND process_status_flag IS NULL;
4705:
4706: SELECT count(*) INTO l_suc_pr_attr
4707: FROM qp_interface_pricing_attribs
4708: WHERE request_id = l_request_id
4709: AND process_status_flag = 'I';
4710:
4711: SELECT count(*) INTO l_err_pr_attr

Line 4712: FROM qp_interface_pricing_attribs

4708: WHERE request_id = l_request_id
4709: AND process_status_flag = 'I';
4710:
4711: SELECT count(*) INTO l_err_pr_attr
4712: FROM qp_interface_pricing_attribs
4713: WHERE request_id = l_request_id
4714: AND process_status_flag IS NULL;
4715:
4716: purge(l_request_id);

Line 6237: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l

6233: ,pa.PRICING_ATTR_VALUE_TO_DISP
6234: ,pa.ATTRIBUTE_STATUS
6235: ,pa.ORIG_SYS_LINE_REF
6236: ,pa.ORIG_SYS_HEADER_REF
6237: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l
6238: WHERE pa.request_id = p_request_id
6239: AND l.request_id = p_request_id -- bug no 5881528
6240: AND l.orig_sys_line_ref = pa.orig_sys_line_ref
6241: AND l.process_status_flag = 'I'

Line 6306: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l

6302: ,pa.PRICING_ATTR_VALUE_TO_DISP
6303: ,pa.ATTRIBUTE_STATUS
6304: ,pa.ORIG_SYS_LINE_REF
6305: ,pa.ORIG_SYS_HEADER_REF
6306: FROM qp_interface_pricing_attribs pa, qp_interface_list_lines l
6307: WHERE pa.request_id = p_request_id
6308: AND l.request_id = p_request_id -- bug no 5881528
6309: AND l.orig_sys_line_ref = pa.orig_sys_line_ref
6310: AND l.process_status_flag = 'I'

Line 6460: update qp_interface_pricing_Attribs qill1

6456: -- 6028305
6457: if p_process_parent='N' then
6458:
6459: --if any price break of this header line fails validation in this request
6460: update qp_interface_pricing_Attribs qill1
6461: set qill1.process_status_flag=null
6462: where qill1.PRICING_ATTR_CODE is null
6463: and qill1.request_id=p_request_id
6464: and qill1.process_status_flag is not null

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

6464: and qill1.process_status_flag is not null
6465: and exists
6466:
6467: (select 'Y'
6468: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6469: where q1.process_status_flag is null
6470: and q1.request_id=p_request_id
6471: and q2.request_id=p_request_id
6472: and q3.request_id=p_request_id

Line 6481: update qp_interface_pricing_Attribs qill1

6477: and q1.ORIG_SYS_HEADER_REF=q2.ORIG_SYS_HEADER_REF
6478: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6479:
6480: -- Deleting all child if the siblings fail
6481: update qp_interface_pricing_Attribs qill1
6482: set qill1.process_status_flag=null
6483: where qill1.PRICING_ATTR_CODE is not null
6484: and qill1.request_id=p_request_id
6485: and qill1.process_status_flag is not null

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

6484: and qill1.request_id=p_request_id
6485: and qill1.process_status_flag is not null
6486: and exists
6487: (select 'Y'
6488: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6489: where q1.process_status_flag is null
6490: and q1.request_id=p_request_id
6491: and q2.request_id=p_request_id
6492: and q3.request_id=p_request_id

Line 6508: from qp_interface_pricing_Attribs q1

6504: where qill.request_id=p_request_id
6505: and qill.process_status_flag is not null
6506: and exists
6507: ( select 'Y'
6508: from qp_interface_pricing_Attribs q1
6509: where q1.process_status_flag is null
6510: and q1.request_id=p_request_id
6511: and q1.ORIG_SYS_HEADER_REF=qill.ORIG_SYS_HEADER_REF
6512: and q1.ORIG_SYS_LINE_REF=qill.ORIG_SYS_LINE_REF);

Line 6522: UPDATE qp_interface_pricing_attribs

6518:
6519: --set the process_status_flag
6520: FORALL I IN G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6521: ..G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
6522: UPDATE qp_interface_pricing_attribs
6523: 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))
6524: WHERE orig_sys_pricing_attr_ref = G_INS_PRICING_ATTR_REC.orig_sys_pricing_attr_ref(I)
6525: AND orig_sys_line_ref = G_INS_PRICING_ATTR_REC.orig_sys_line_ref(I)
6526: AND orig_sys_header_ref = G_INS_PRICING_ATTR_REC.orig_sys_header_ref(I)

Line 6675: update qp_interface_pricing_Attribs qill1

6671:
6672: if p_process_parent='N' then
6673:
6674: --if any price break of this header line fails validation in this request
6675: update qp_interface_pricing_Attribs qill1
6676: set qill1.process_status_flag=null
6677: where qill1.PRICING_ATTR_CODE is null
6678: and qill1.request_id=p_request_id
6679: and qill1.process_status_flag is not null

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

6679: and qill1.process_status_flag is not null
6680: and exists
6681:
6682: (select 'Y'
6683: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6684: where q1.process_status_flag is null
6685: and q1.request_id=p_request_id
6686: and q2.request_id=p_request_id
6687: and q3.request_id=p_request_id

Line 6697: update qp_interface_pricing_Attribs qill1

6693: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6694:
6695: write_log( 'Number of attribute lines picked1: '||SQL%ROWCOUNT);
6696: -- Deleting all child if the siblings fail
6697: update qp_interface_pricing_Attribs qill1
6698: set qill1.process_status_flag=null
6699: where qill1.PRICING_ATTR_CODE is not null
6700: and qill1.request_id=p_request_id
6701: and qill1.process_status_flag is not null

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

6700: and qill1.request_id=p_request_id
6701: and qill1.process_status_flag is not null
6702: and exists
6703: (select 'Y'
6704: from qp_interface_pricing_Attribs q1,qp_interface_list_lines q2,qp_interface_list_lines q3
6705: where q1.process_status_flag is null
6706: and q1.request_id=p_request_id
6707: and q2.request_id=p_request_id
6708: and q3.request_id=p_request_id

Line 6724: from qp_interface_pricing_Attribs q1

6720: where qill.request_id=p_request_id
6721: and qill.process_status_flag is not null
6722: and exists
6723: ( select 'Y'
6724: from qp_interface_pricing_Attribs q1
6725: where q1.process_status_flag is null
6726: and q1.request_id=p_request_id
6727: and q1.ORIG_SYS_HEADER_REF=qill.ORIG_SYS_HEADER_REF
6728: and q1.ORIG_SYS_LINE_REF=qill.ORIG_SYS_LINE_REF);

Line 6739: UPDATE qp_interface_pricing_attribs

6735:
6736: --set the process_status_flag
6737: FORALL I IN G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
6738: ..G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
6739: UPDATE qp_interface_pricing_attribs
6740: 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))
6741: WHERE orig_sys_pricing_attr_ref = G_UDT_PRICING_ATTR_REC.orig_sys_pricing_attr_ref(I)
6742: AND orig_sys_line_ref = G_UDT_PRICING_ATTR_REC.orig_sys_line_ref(I)
6743: AND orig_sys_header_ref = G_UDT_PRICING_ATTR_REC.orig_sys_header_ref(I)

Line 6858: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa

6854:
6855: Delete from qp_pricing_attributes
6856: where pricing_attribute_id IN
6857: (Select pa.pricing_attribute_id
6858: from qp_pricing_attributes pa, qp_interface_pricing_attribs ipa
6859: where ipa.request_id = p_request_id
6860: and pa.request_id = p_request_id -- changes made by rassharm 6028305
6861: and ipa.process_status_flag IS NULL
6862: and ipa.interface_action_code ='INSERT'

Line 7033: FROM qp_interface_pricing_attribs

7029: CURSOR c_pricing_attr IS
7030: SELECT orig_sys_pricing_attr_ref,
7031: orig_sys_line_ref,
7032: orig_sys_header_ref
7033: FROM qp_interface_pricing_attribs
7034: WHERE request_id = p_request_id
7035: AND process_status_flag IS NULL;
7036:
7037: CURSOR c_pbh_child_line IS

Line 7236: DELETE FROM qp_interface_pricing_attribs

7232: (p_request_id NUMBER)
7233: IS
7234: BEGIN
7235: write_log('Entering Purging');
7236: DELETE FROM qp_interface_pricing_attribs
7237: WHERE request_id = p_request_id
7238: AND process_status_flag = 'I';
7239:
7240: DELETE FROM qp_interface_list_lines