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.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINES_ALL_EXT_B

Line 3296: UPDATE po_lines_all_ext_b plbd

3292: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks excluding comlex pricing attr', p_po_line_s_no_lck_tbl);
3293: END IF;
3294:
3295: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT
3296: UPDATE po_lines_all_ext_b plbd
3297: SET ( plbd.c_ext_attr1,
3298: plbd.c_ext_attr2 ,
3299: plbd.c_ext_attr3 ,
3300: plbd.c_ext_attr4 ,

Line 3479: FROM po_lines_all_ext_b plb --base

3475: plb.d_ext_attr7 ,
3476: plb.d_ext_attr8 ,
3477: plb.d_ext_attr9 ,
3478: plb.d_ext_attr10
3479: FROM po_lines_all_ext_b plb --base
3480: WHERE plb.po_line_id = p_po_line_s_no_lck_tbl(i)
3481: AND plb.draft_id = -1
3482: AND plb.attr_group_id = plbd.attr_group_id
3483: )

Line 3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');

3493: );
3494:
3495: d_position := 40;
3496: IF (PO_LOG.d_stmt) THEN
3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');
3498: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3499: END IF;
3500:
3501: -- : Cleaning up. p_po_line_s_no_p_lck_tblalready passed as param to this api.

Line 3511: UPDATE po_lines_all_ext_b plbd

3507:
3508: -- We need 3 update statement
3509: -- 1st update old value records for S lock, P lock and no lock lines
3510: FORALL i in 1..p_po_line_s_no_p_lck_tbl.COUNT
3511: UPDATE po_lines_all_ext_b plbd
3512: SET ( plbd.c_ext_attr1,
3513: plbd.c_ext_attr2 ,
3514: plbd.c_ext_attr3 ,
3515: plbd.c_ext_attr4 ,

Line 3693: FROM po_lines_all_ext_b plb --base

3689: plb.d_ext_attr7 ,
3690: plb.d_ext_attr8 ,
3691: plb.d_ext_attr9 ,
3692: plb.d_ext_attr10
3693: FROM po_lines_all_ext_b plb --base
3694: WHERE plb.po_line_id = plbd.po_line_id
3695: AND plb.draft_id = -1
3696: AND plb.attr_group_id = plbd.attr_group_id
3697: AND plb.pk1_value IS NULL

Line 3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');

3709: );
3710:
3711: d_position := 60;
3712: IF (PO_LOG.d_stmt) THEN
3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');
3714: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3715: END IF;
3716:
3717: --2nd update all attributes excluding numeric attributes for S or no lock lines

Line 3719: UPDATE po_lines_all_ext_b plbd

3715: END IF;
3716:
3717: --2nd update all attributes excluding numeric attributes for S or no lock lines
3718: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT
3719: UPDATE po_lines_all_ext_b plbd
3720: SET ( plbd.c_ext_attr1,
3721: plbd.c_ext_attr2 ,
3722: plbd.c_ext_attr3 ,
3723: plbd.c_ext_attr4 ,

Line 3861: FROM po_lines_all_ext_b plb --base

3857: plb.d_ext_attr7 ,
3858: plb.d_ext_attr8 ,
3859: plb.d_ext_attr9 ,
3860: plb.d_ext_attr10
3861: FROM po_lines_all_ext_b plb --base
3862: WHERE plb.po_line_id = plbd.po_line_id
3863: AND plb.draft_id = -1
3864: AND plb.attr_group_id = plbd.attr_group_id
3865: AND plb.pk1_value IS NULL

Line 3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');

3877: );
3878:
3879: d_position := 70;
3880: IF (PO_LOG.d_stmt) THEN
3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');
3882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3883: END IF;
3884:
3885: ---3rd update numeric attributes.. for s, p, null lock types

Line 3887: UPDATE po_lines_all_ext_b plbd

3883: END IF;
3884:
3885: ---3rd update numeric attributes.. for s, p, null lock types
3886: FORALL i in 1..p_po_line_s_no_p_lck_tbl.COUNT
3887: UPDATE po_lines_all_ext_b plbd
3888: SET ( plbd.n_ext_attr1 ,
3889: plbd.n_ext_attr2 ,
3890: plbd.n_ext_attr3 ,
3891: plbd.n_ext_attr4 ,

Line 3929: FROM po_lines_all_ext_b plb,--base

3925: plb.n_ext_attr17 + pld.n_ext_attr17 ,
3926: plb.n_ext_attr18 + pld.n_ext_attr18 ,
3927: plb.n_ext_attr19 + pld.n_ext_attr19 ,
3928: plb.n_ext_attr20 + pld.n_ext_attr20
3929: FROM po_lines_all_ext_b plb,--base
3930: po_lines_all_ext_b pld--delta
3931: WHERE plb.po_line_id = plbd.po_line_id
3932: AND pld.po_line_id = -(plb.po_line_id)
3933: AND plb.attr_group_id = plbd.attr_group_id

Line 3930: po_lines_all_ext_b pld--delta

3926: plb.n_ext_attr18 + pld.n_ext_attr18 ,
3927: plb.n_ext_attr19 + pld.n_ext_attr19 ,
3928: plb.n_ext_attr20 + pld.n_ext_attr20
3929: FROM po_lines_all_ext_b plb,--base
3930: po_lines_all_ext_b pld--delta
3931: WHERE plb.po_line_id = plbd.po_line_id
3932: AND pld.po_line_id = -(plb.po_line_id)
3933: AND plb.attr_group_id = plbd.attr_group_id
3934: AND plb.attr_group_id = pld.attr_group_id

Line 3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');

3950: );
3951:
3952: d_position := 80;
3953: IF (PO_LOG.d_stmt) THEN
3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');
3955: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3956: END IF;
3957:
3958: -- Update lines in ext_tl table