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

Line 1635: FROM po_lines_all pla,

1631: l_base_CLM_UNDEF_FLAG_tbl, --UCA Project
1632: l_base_CLM_APP_UNDEF_AMT_tbl,--UCA Project
1633: l_draft_CLM_UNDEF_ACTION_CODE,--UCA Project
1634: l_draft_CLM_UNDEF_FLAG_tbl --bug 16451273
1635: FROM po_lines_all pla,
1636: po_lines_draft_all plda
1637: WHERE pla.po_line_id = plda.po_line_id
1638: AND plda.draft_id = p_draft_id
1639: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 1666: FROM po_lines_all pla,

1662: 'N'
1663: BULK COLLECT INTO l_po_line_s_no_lck_tbl,
1664: l_draft_id_tbl,
1665: l_delete_flag_tbl
1666: FROM po_lines_all pla,
1667: po_lines_draft_all plda
1668: WHERE plda.draft_id = p_draft_id
1669: AND pla.po_line_id = plda.po_line_id
1670: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 1689: po_lines_all pla

1685: SELECT plda.po_line_id
1686: BULK COLLECT
1687: INTO l_po_line_s_no_p_lck_tbl
1688: FROM po_lines_draft_all plda,
1689: po_lines_all pla
1690: WHERE plda.draft_id = p_draft_id
1691: AND pla.po_line_id = plda.po_line_id
1692: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1693: AND NOT EXISTS (SELECT 'F locks'

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 3488: po_lines_all pol

3484: WHERE plbd.po_line_id = p_po_line_s_no_lck_tbl(i)
3485: AND plbd.draft_id = p_draft_id
3486: AND NOT EXISTS (SELECT 'exclude PRICING attribute category'
3487: FROM po_uda_ag_template_usages puatu,
3488: po_lines_all pol
3489: WHERE puatu.template_id = pol.uda_template_id
3490: AND plbd.po_line_id = pol.po_line_id
3491: AND puatu.attribute_category = 'PRICING'
3492: AND puatu.attribute_group_id = plbd.attr_group_id

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 3704: po_lines_all pol

3700: AND plbd.draft_id = -1
3701: AND plbd.pk1_value = p_draft_id
3702: AND EXISTS (SELECT 'include only PRICING attribute category'
3703: FROM po_uda_ag_template_usages puatu,
3704: po_lines_all pol
3705: WHERE puatu.template_id = pol.uda_template_id
3706: AND plbd.po_line_id = pol.po_line_id
3707: AND puatu.attribute_category = 'PRICING'
3708: AND puatu.attribute_group_id = plbd.attr_group_id

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 3872: po_lines_all pol

3868: AND plbd.draft_id = p_draft_id
3869: AND plbd.pk1_value IS NULL
3870: AND EXISTS (SELECT 'include only PRICING attribute category'
3871: FROM po_uda_ag_template_usages puatu,
3872: po_lines_all pol
3873: WHERE puatu.template_id = pol.uda_template_id
3874: AND plbd.po_line_id = pol.po_line_id
3875: AND puatu.attribute_category = 'PRICING'
3876: AND puatu.attribute_group_id = plbd.attr_group_id

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 3945: po_lines_all pol

3941: AND plbd.draft_id = p_draft_id
3942: AND plbd.pk1_value IS NULL
3943: AND EXISTS (SELECT 'include only PRICING attribute category'
3944: FROM po_uda_ag_template_usages puatu,
3945: po_lines_all pol
3946: WHERE puatu.template_id = pol.uda_template_id
3947: AND plbd.po_line_id = pol.po_line_id
3948: AND puatu.attribute_category = 'PRICING'
3949: AND puatu.attribute_group_id = plbd.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

Line 3960: UPDATE po_lines_all_ext_tl pltd

3956: END IF;
3957:
3958: -- Update lines in ext_tl table
3959: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT
3960: UPDATE po_lines_all_ext_tl pltd
3961: SET ( pltd.tl_ext_attr1 ,
3962: pltd.tl_ext_attr2 ,
3963: pltd.tl_ext_attr3 ,
3964: pltd.tl_ext_attr4 ,

Line 4042: FROM po_lines_all_ext_tl pltb --base

4038: pltb.tl_ext_attr37 ,
4039: pltb.tl_ext_attr38 ,
4040: pltb.tl_ext_attr39 ,
4041: pltb.tl_ext_attr40
4042: FROM po_lines_all_ext_tl pltb --base
4043: WHERE pltb.po_line_id = pltd.po_line_id
4044: AND pltb.draft_id = -1
4045: AND pltb.attr_group_id = pltd.attr_group_id
4046: AND pltb.language = pltd.language

Line 4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');

4052:
4053:
4054: d_position := 90;
4055: IF (PO_LOG.d_stmt) THEN
4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN