DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on PO_UDA_AG_TEMPLATES_S

Line 3279: UPDATE po_uda_ag_templates SET database_view_name = l_view_name

3275: -- EXECUTE IMMEDIATE (l_create_view);
3276: END IF;
3277:
3278: /*update database_view_name in po_ag_templates table*/
3279: UPDATE po_uda_ag_templates SET database_view_name = l_view_name
3280: WHERE template_id = p_template_id;
3281:
3282: x_template_view_name := l_view_name;
3283:

Line 5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;

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;
5281:
5282: BEGIN
5283: IF (PO_LOG.d_proc) THEN
5284: PO_LOG.proc_begin(d_module);