[Home] [Help]
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
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
3537: FND_GLOBAL.prog_appl_id, -- program_application_id
3538: FND_GLOBAL.conc_program_id, -- program_id
3539: sysdate, -- program_update_date
3540: d_mod -- last_updated_program
3541: FROM DUAL
3542: WHERE NOT EXISTS
3543: (SELECT 'TLP row for this language already exists'
3544: FROM PO_ATTRIBUTE_VALUES_TLP TLP2
3545: WHERE TLP2.po_line_id = p_po_line_id
3704: FND_GLOBAL.prog_appl_id, -- program_application_id
3705: FND_GLOBAL.conc_program_id, -- program_id
3706: sysdate, -- program_update_date
3707: d_mod -- last_updated_program
3708: FROM DUAL
3709: WHERE NOT EXISTS
3710: (SELECT 'Attribute row already exists'
3711: FROM PO_ATTRIBUTE_VALUES POATR
3712: WHERE POATR.po_line_id = p_po_line_id
3845: FND_GLOBAL.prog_appl_id, -- program_application_id
3846: FND_GLOBAL.conc_program_id, -- program_id
3847: sysdate, -- program_update_date
3848: d_mod -- last_updated_program
3849: FROM DUAL
3850: WHERE NOT EXISTS
3851: (SELECT 'Attribute row already exists'
3852: FROM PO_ATTRIBUTE_VALUES POATR
3853: WHERE POATR.inventory_item_id = p_inventory_item_id
4323: FND_GLOBAL.prog_appl_id,
4324: FND_GLOBAL.conc_program_id, -- program_id
4325: sysdate, -- program_update_date
4326: d_mod -- last_updated_program
4327: FROM dual;
4328:
4329: ELSE
4330: 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;
4331: l_progress := '095';
6387: FND_GLOBAL.prog_appl_id, -- program_application_id
6388: FND_GLOBAL.conc_program_id, -- program_id
6389: sysdate, -- program_update_date
6390: d_mod -- last_updated_program
6391: FROM DUAL
6392: WHERE NOT EXISTS
6393: (SELECT 'TLP row for this language already exists'
6394: FROM PO_ATTRIBUTE_VALUES_TLP TLP2
6395: WHERE TLP2.inventory_item_id = p_inventory_item_id