APPS.PO_UDA_TEMPLATES_UTIL dependencies on PO_UDA_AG_TEMPLATES_TL

Line 5276: FROM po_uda_ag_templates_tl tl

5272: WHERE b.template_id = p_src_template_id;
5273:
5274: CURSOR c_src_template_tl_details(p_src_template_id NUMBER) IS
5275: SELECT tl.display_name, tl.comments, tl.LANGUAGE, tl.SOURCE_LANG
5276: FROM po_uda_ag_templates_tl tl
5277: WHERE tl.template_id = p_src_template_id;
5278:
5279: CURSOR c_gen_template_seq IS
5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;

Line 5327: INSERT INTO po_uda_ag_templates_tl(template_id,

5323: END LOOP;
5324:
5325: FOR c_src_template_tl_details_rec IN c_src_template_tl_details(p_src_template_id) LOOP
5326:
5327: INSERT INTO po_uda_ag_templates_tl(template_id,
5328: display_name,
5329: comments,
5330: LANGUAGE,
5331: source_lang,

Line 5751: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt

5747:
5748: --Get the dummy classfication code,Revision -to display in the attribute group page
5749: SELECT ptl.display_name || ', Rev ' || pt.revision
5750: INTO l_dummy_classfication_code
5751: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt
5752: WHERE ptl.template_id = pt.template_id
5753: AND ptl.template_id = p_classification_code
5754: AND language = USERENV('LANG');
5755:

Line 5863: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt

5859:
5860: --Get the dummy classification code
5861: SELECT ptl.display_name || ', Rev ' || pt.revision
5862: INTO l_template_name
5863: FROM po_uda_ag_templates_tl ptl,po_uda_ag_templates pt
5864: WHERE ptl.template_id = pt.template_id
5865: AND ptl.template_id = l_template_id
5866: AND language = USERENV('LANG');
5867: