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_LIST_LINES

Line 2153: Update qp_interface_list_lines qpil

2149: IF p_spawned_request = 'N' or p_spawned_request IS NULL THEN
2150:
2151: -- Update the all the lines to be processed with request_id
2152: -- Bug 5208480(5208112,4188784) RAVI
2153: Update qp_interface_list_lines qpil
2154: Set qpil.request_id= l_request_id
2155: Where qpil.rowid IN
2156: (select l.rowid
2157: from qp_interface_list_lines l, qp_interface_list_headers h

Line 2157: from qp_interface_list_lines l, qp_interface_list_headers h

2153: Update qp_interface_list_lines qpil
2154: Set qpil.request_id= l_request_id
2155: Where qpil.rowid IN
2156: (select l.rowid
2157: from qp_interface_list_lines l, qp_interface_list_headers h
2158: where h.process_status_flag='I'
2159: and l.process_status_flag = 'P'
2160: and l.request_id is null
2161: and h.request_id = l_request_id

Line 2189: UPDATE qp_interface_list_lines qpil

2185: /**
2186: If interface action is update then load all null value interface columns
2187: with values from corresponding qp table columns
2188: **/
2189: UPDATE qp_interface_list_lines qpil
2190: SET ( accrual_conversion_rate,
2191: accrual_flag,
2192: accrual_qty,
2193: accrual_uom_code,

Line 3423: FROM qp_interface_list_lines qpil

3419: SET qpip.pricing_attr_value_to = '999999999999999'
3420: WHERE qpip.request_id = l_request_id
3421: AND EXISTS (
3422: SELECT 'YES'
3423: FROM qp_interface_list_lines qpil
3424: WHERE qpil.request_id = qpip.request_id
3425: AND qpip.orig_sys_line_ref = qpil.orig_sys_line_ref
3426: AND qpil.price_break_header_ref is not null
3427: AND qpip.pricing_attr_value_to is null

Line 3447: FROM qp_interface_list_lines

3443:
3444: --Number of lines to be processed
3445:
3446: SELECT count(*) INTO l_no_of_lines
3447: FROM qp_interface_list_lines
3448: WHERE request_id = l_request_id
3449: AND process_status_flag = 'P'
3450: AND price_break_header_ref is null
3451: AND rltd_modifier_grp_type is null;

Line 3459: FROM qp_interface_list_lines

3455: IF l_no_of_lines = 0 THEN
3456:
3457: SELECT count(*) INTO l_count
3458: FROM (SELECT 'Y'
3459: FROM qp_interface_list_lines
3460: WHERE request_id = l_request_id
3461: AND process_status_flag = 'P'
3462: UNION
3463: SELECT 'Y'

Line 3518: UPDATE qp_interface_list_lines

3514: G_thread_info_table(I).request_id := l_new_request_id;
3515:
3516: IF I=p_no_of_threads
3517: THEN
3518: UPDATE qp_interface_list_lines
3519: SET request_id = l_new_request_id
3520: WHERE request_id = l_request_id
3521: AND process_status_flag = 'P'
3522: AND price_break_header_ref IS NULL

Line 3526: UPDATE qp_interface_list_lines

3522: AND price_break_header_ref IS NULL
3523: AND rltd_modifier_grp_type IS NULL
3524: AND rownum <= l_batch_size+l_mod;
3525: ELSE
3526: UPDATE qp_interface_list_lines
3527: SET request_id = l_new_request_id
3528: WHERE request_id = l_request_id
3529: AND process_status_flag = 'P'
3530: AND price_break_header_ref IS NULL

Line 3568: UPDATE qp_interface_list_lines qpil

3564: select hsecs into l_start_time from v$timer;
3565: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3566:
3567: -- Bug 5208480(5208112,4188784) RAVI
3568: UPDATE qp_interface_list_lines qpil
3569: SET qpil.request_id = l_request_id
3570: WHERE qpil.rowid IN
3571: ((SELECT c.rowid
3572: FROM qp_interface_list_lines p,qp_interface_list_lines c

Line 3572: FROM qp_interface_list_lines p,qp_interface_list_lines c

3568: UPDATE qp_interface_list_lines qpil
3569: SET qpil.request_id = l_request_id
3570: WHERE qpil.rowid IN
3571: ((SELECT c.rowid
3572: FROM qp_interface_list_lines p,qp_interface_list_lines c
3573: WHERE p.request_id = l_request_id
3574: AND c.request_id = p_request_id
3575: AND c.price_break_header_ref = p.orig_sys_line_ref
3576: AND c.rltd_modifier_grp_type = 'PRICE BREAK'

Line 3581: FROM qp_interface_list_lines p,qp_interface_list_lines c

3577: AND c.process_status_flag = 'P'
3578: AND p.process_status_flag = 'P' )
3579: UNION
3580: (SELECT c.rowid
3581: FROM qp_interface_list_lines p,qp_interface_list_lines c
3582: WHERE p.process_status_flag = 'I'
3583: AND c.request_id = p_request_id
3584: AND c.price_break_header_ref = p.orig_sys_line_ref
3585: AND c.rltd_modifier_grp_type = 'PRICE BREAK'

Line 3608: UPDATE qp_interface_list_lines qpil

3604: **/
3605: -- Bug#5353889 RAVI START
3606: -- Comment the update as the updates are already done.
3607: /**
3608: UPDATE qp_interface_list_lines qpil
3609: SET ( accrual_conversion_rate,
3610: accrual_flag,
3611: accrual_qty,
3612: accrual_uom_code,

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 4697: FROM qp_interface_list_lines

4693: END IF;
4694: */
4695:
4696: SELECT count(*) INTO l_suc_line
4697: FROM qp_interface_list_lines
4698: WHERE request_id = l_request_id
4699: AND process_status_flag = 'I';
4700:
4701: SELECT count(*) INTO l_err_line

Line 4702: FROM qp_interface_list_lines

4698: WHERE request_id = l_request_id
4699: AND process_status_flag = 'I';
4700:
4701: SELECT count(*) INTO l_err_line
4702: FROM qp_interface_list_lines
4703: WHERE request_id = l_request_id
4704: AND process_status_flag IS NULL;
4705:
4706: SELECT count(*) INTO l_suc_pr_attr

Line 5401: FROM qp_interface_list_lines

5397: ,RECURRING_VALUE
5398: ,NET_AMOUNT_FLAG
5399: --Bug#5359974 RAVI
5400: ,CONTINUOUS_PRICE_BREAK_FLAG
5401: FROM qp_interface_list_lines
5402: WHERE request_id = p_request_id
5403: AND process_status_flag = 'P'
5404: AND interface_action_code='INSERT'
5405: --ORDER BY LIST_LINE_TYPE_CODE; --bug 7315191

Line 5509: FROM qp_interface_list_lines

5505: ,RECURRING_VALUE
5506: ,NET_AMOUNT_FLAG
5507: --Bug#5359974 RAVI
5508: ,CONTINUOUS_PRICE_BREAK_FLAG
5509: FROM qp_interface_list_lines
5510: WHERE request_id = p_request_id
5511: AND process_status_flag = 'P'
5512: AND interface_action_code='UPDATE';
5513:

Line 5747: update qp_interface_list_lines qill1

5743:
5744: -- 6028305
5745: if p_process_parent='N' then
5746: --Invalidate all the valid sibling break lines, in this request
5747: update qp_interface_list_lines qill1
5748: set qill1.process_status_flag=null
5749: where qill1.price_break_header_ref is not null
5750: and qill1.request_id=p_request_id
5751: and qill1.process_status_flag is not null

Line 5753: and exists (Select 'Y' from qp_interface_list_lines qill2

5749: where qill1.price_break_header_ref is not null
5750: and qill1.request_id=p_request_id
5751: and qill1.process_status_flag is not null
5752: --if any sibling of this child line fails validation in this request
5753: and exists (Select 'Y' from qp_interface_list_lines qill2
5754: where qill2.process_status_flag is null
5755: and qill2.request_id=p_request_id
5756: and qill2.price_break_header_ref=qill1.price_break_header_ref);
5757:

Line 5760: update qp_interface_list_lines qill1

5756: and qill2.price_break_header_ref=qill1.price_break_header_ref);
5757:
5758:
5759: --Invalidate all the valid price break header lines, in this request
5760: update qp_interface_list_lines qill1
5761: set qill1.process_status_flag=null
5762: where qill1.price_break_header_ref is null
5763: and qill1.LIST_LINE_TYPE_CODE='PBH'
5764: and qill1.request_id=p_request_id

Line 5767: and exists (Select 'Y' from qp_interface_list_lines qill2

5763: and qill1.LIST_LINE_TYPE_CODE='PBH'
5764: and qill1.request_id=p_request_id
5765: and qill1.process_status_flag is not null
5766: --if any price break qill2 of this header line fails validation in this request
5767: and exists (Select 'Y' from qp_interface_list_lines qill2
5768: where qill2.process_status_flag is null
5769: and qill2.LIST_LINE_TYPE_CODE='PLL'
5770: and qill2.request_id=p_request_id
5771: and qill2.price_break_header_ref=qill1.orig_sys_line_ref);

Line 5781: UPDATE qp_interface_list_lines

5777:
5778: --set process_status_flag
5779: FORALL I IN G_UDT_LINE_REC.orig_sys_line_ref.FIRST
5780: ..G_UDT_LINE_REC.orig_sys_line_ref.LAST
5781: UPDATE qp_interface_list_lines
5782: SET process_status_flag = decode(G_UDT_LINE_REC.process_status_flag(I),'P', 'I',G_UDT_LINE_REC.process_status_flag(I))
5783: WHERE orig_sys_line_ref = G_UDT_LINE_REC.orig_sys_line_ref(I)
5784: AND orig_sys_header_ref = G_UDT_LINE_REC.orig_sys_header_ref(I)
5785: AND request_id = p_request_id; -- Bug No: 6235177

Line 6022: update qp_interface_list_lines qill1

6018: -- 6028305
6019:
6020: if p_process_parent='N' then
6021: --Invalidate all the valid sibling break lines, in this request
6022: update qp_interface_list_lines qill1
6023: set qill1.process_status_flag=null
6024: where qill1.price_break_header_ref is not null
6025: and qill1.request_id=p_request_id
6026: and qill1.process_status_flag is not null

Line 6028: and exists (Select 'Y' from qp_interface_list_lines qill2

6024: where qill1.price_break_header_ref is not null
6025: and qill1.request_id=p_request_id
6026: and qill1.process_status_flag is not null
6027: --if any sibling of this child line fails validation in this request
6028: and exists (Select 'Y' from qp_interface_list_lines qill2
6029: where qill2.process_status_flag is null
6030: and qill2.request_id=p_request_id
6031: and qill2.price_break_header_ref=qill1.price_break_header_ref);
6032:

Line 6035: update qp_interface_list_lines qill1

6031: and qill2.price_break_header_ref=qill1.price_break_header_ref);
6032:
6033: write_log('Inside process_parent Lines Loaded for INS1: '||G_INS_LINE_REC.orig_sys_line_ref.count);
6034: --Invalidate all the valid price break header lines, in this request
6035: update qp_interface_list_lines qill1
6036: set qill1.process_status_flag=null
6037: where qill1.price_break_header_ref is null
6038: and qill1.LIST_LINE_TYPE_CODE='PBH'
6039: and qill1.request_id=p_request_id

Line 6042: and exists (Select 'Y' from qp_interface_list_lines qill2

6038: and qill1.LIST_LINE_TYPE_CODE='PBH'
6039: and qill1.request_id=p_request_id
6040: and qill1.process_status_flag is not null
6041: --if any price break qill2 of this header line fails validation in this request
6042: and exists (Select 'Y' from qp_interface_list_lines qill2
6043: where qill2.process_status_flag is null
6044: and qill2.LIST_LINE_TYPE_CODE='PLL'
6045: and qill2.request_id=p_request_id
6046: and qill2.price_break_header_ref=qill1.orig_sys_line_ref);

Line 6062: UPDATE qp_interface_list_lines

6058:
6059: --set process_status_flag
6060: FORALL I IN G_INS_LINE_REC.orig_sys_line_ref.FIRST
6061: ..G_INS_LINE_REC.orig_sys_line_ref.LAST
6062: UPDATE qp_interface_list_lines
6063: SET process_status_flag = decode(G_INS_LINE_REC.process_status_flag(I),'P', 'I',G_INS_LINE_REC.process_status_flag(I))
6064: WHERE orig_sys_line_ref = G_INS_LINE_REC.orig_sys_line_ref(I)
6065: AND orig_sys_header_ref = G_INS_LINE_REC.orig_sys_header_ref(I)
6066: AND request_id = p_request_id; -- Bug No: 6235177

Line 6138: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

6134: orig_sys_pricing_attr_ref,error_message)
6135: VALUES
6136: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6137: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
6138: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
6139: G_INS_LINE_REC.orig_sys_header_ref(I),G_INS_LINE_REC.orig_sys_line_ref(I),
6140: null,null,l_msg_txt);
6141: END;
6142: END IF;

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 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 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 6502: update qp_interface_list_lines qill

6498: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6499:
6500:
6501: ---- updating the corresponding list lines
6502: update qp_interface_list_lines qill
6503: set process_Status_flag = null
6504: where qill.request_id=p_request_id
6505: and qill.process_status_flag is not null
6506: and exists

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 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 6718: update qp_interface_list_lines qill

6714: and qill1.ORIG_SYS_LINE_REF=q3.ORIG_SYS_LINE_REF);
6715:
6716: write_log( 'Number of attribute lines picked1: '||SQL%ROWCOUNT);
6717: ---- updating the corresponding list lines
6718: update qp_interface_list_lines qill
6719: set process_Status_flag = null
6720: where qill.request_id=p_request_id
6721: and qill.process_status_flag is not null
6722: and exists

Line 6835: from qp_list_lines l, qp_interface_list_lines il

6831:
6832: Delete from qp_rltd_modifiers
6833: where from_rltd_modifier_id IN
6834: (select l.list_line_id
6835: from qp_list_lines l, qp_interface_list_lines il
6836: where il.request_id = p_request_id
6837: and l.request_id = p_request_id -- changes made by rassharm 6028305
6838: and il.process_status_flag IS NULL
6839: and il.interface_action_code ='INSERT'

Line 6847: from qp_list_lines l, qp_interface_list_lines il

6843:
6844: Delete from qp_rltd_modifiers
6845: where to_rltd_modifier_id IN
6846: (select l.list_line_id
6847: from qp_list_lines l, qp_interface_list_lines il
6848: where il.request_id = p_request_id
6849: and l.request_id = p_request_id -- changes made by rassharm 6028305
6850: and il.process_status_flag IS NULL
6851: and il.interface_action_code ='INSERT'

Line 6872: from qp_list_lines l, qp_interface_list_lines il

6868:
6869: Delete from qp_list_lines
6870: where list_line_id IN
6871: (select l.list_line_id
6872: from qp_list_lines l, qp_interface_list_lines il
6873: where il.request_id = p_request_id
6874: and l.request_id = p_request_id -- changes made by rassharm 6028305
6875: and il.process_status_flag IS NULL
6876: and il.interface_action_code ='INSERT'

Line 6957: UPDATE qp_interface_list_lines

6953:
6954: write_log('Number of invalid lines: '|| l_orig_sys_line_ref_tbl.count);
6955:
6956: FORALL I in l_orig_sys_line_ref_tbl.first..l_orig_sys_line_ref_tbl.last
6957: UPDATE qp_interface_list_lines
6958: SET process_status_flag = NULL
6959: WHERE orig_sys_header_ref = l_orig_sys_header_ref_tbl(I)
6960: AND orig_sys_line_ref = l_orig_sys_line_ref_tbl(I)
6961: AND request_id = p_request_id; --Bug No: 6235177

Line 7008: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

7004: orig_sys_pricing_attr_ref,error_message)
7005: VALUES
7006: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
7007: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
7008: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
7009: null,l_orig_sys_line_ref_tbl(I),null,null,l_msg_txt);
7010:
7011: write_log('Leaving Validate_Lines');
7012:

Line 7041: FROM qp_interface_list_lines

7037: CURSOR c_pbh_child_line IS
7038: SELECT orig_sys_line_ref,
7039: orig_sys_header_ref,
7040: price_break_header_ref
7041: FROM qp_interface_list_lines
7042: WHERE request_id = p_request_id
7043: AND process_status_flag IS NULL
7044: AND price_break_header_ref IS NOT NULL;
7045:

Line 7194: elsif l_table_name = 'QP_INTERFACE_LIST_LINES' then

7190: ||'/'||l_entity_type
7191: ||'/'||l_table_name
7192: ||'/'||l_orig_sys_header_ref
7193: ||' '||l_error_message);
7194: elsif l_table_name = 'QP_INTERFACE_LIST_LINES' then
7195: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7196: ||'/'||l_entity_type
7197: ||'/'||l_table_name
7198: ||'/'||l_orig_sys_header_ref

Line 7240: DELETE FROM qp_interface_list_lines

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