APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on DUAL

Line 2705: FROM DUAL;

2701: -- SQL Why : To get tlp_id's
2702: -- SQL Join: none
2703: SELECT PO_SESSION_GT_S.nextval
2704: INTO l_key
2705: FROM DUAL;
2706:
2707: l_progress := '020';
2708: -- SQL What: Now get translations for each of the TLP rows, for each available language
2709: -- SQL Why : They will be inserted into the TLP table

Line 2822: FROM DUAL;

2818: -- SQL Why : To get tlp_id's
2819: -- SQL Join: none
2820: SELECT PO_SESSION_GT_S.nextval
2821: INTO l_key
2822: FROM DUAL;
2823:
2824: l_progress := '020';
2825: -- SQL What: Get the primary key to the TLP row of the created_language
2826: -- SQL Why : This TLP row will be copied when creating translations

Line 3542: FROM DUAL

3538: FND_GLOBAL.prog_appl_id, -- program_application_id
3539: FND_GLOBAL.conc_program_id, -- program_id
3540: sysdate, -- program_update_date
3541: d_mod -- last_updated_program
3542: FROM DUAL
3543: WHERE NOT EXISTS
3544: (SELECT 'TLP row for this language already exists'
3545: FROM PO_ATTRIBUTE_VALUES_TLP TLP2
3546: WHERE TLP2.po_line_id = p_po_line_id

Line 3709: FROM DUAL

3705: FND_GLOBAL.prog_appl_id, -- program_application_id
3706: FND_GLOBAL.conc_program_id, -- program_id
3707: sysdate, -- program_update_date
3708: d_mod -- last_updated_program
3709: FROM DUAL
3710: WHERE NOT EXISTS
3711: (SELECT 'Attribute row already exists'
3712: FROM PO_ATTRIBUTE_VALUES POATR
3713: WHERE POATR.po_line_id = p_po_line_id

Line 3850: FROM DUAL

3846: FND_GLOBAL.prog_appl_id, -- program_application_id
3847: FND_GLOBAL.conc_program_id, -- program_id
3848: sysdate, -- program_update_date
3849: d_mod -- last_updated_program
3850: FROM DUAL
3851: WHERE NOT EXISTS
3852: (SELECT 'Attribute row already exists'
3853: FROM PO_ATTRIBUTE_VALUES POATR
3854: WHERE POATR.inventory_item_id = p_inventory_item_id

Line 4348: FROM dual;

4344: FND_GLOBAL.prog_appl_id,
4345: FND_GLOBAL.conc_program_id, -- program_id
4346: sysdate, -- program_update_date
4347: d_mod -- last_updated_program
4348: FROM dual;
4349:
4350: ELSE
4351: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' records present hence update PO_ATTRIBUTE_VALUES_TLP ' || l_rec_tlp_for_lang); END IF;
4352: l_progress := '095';

Line 6524: FROM DUAL

6520: FND_GLOBAL.prog_appl_id, -- program_application_id
6521: FND_GLOBAL.conc_program_id, -- program_id
6522: sysdate, -- program_update_date
6523: d_mod -- last_updated_program
6524: FROM DUAL
6525: WHERE NOT EXISTS
6526: (SELECT 'TLP row for this language already exists'
6527: FROM PO_ATTRIBUTE_VALUES_TLP TLP2
6528: WHERE TLP2.inventory_item_id = p_inventory_item_id