APPS.PN_VAR_TEMPLATE_PKG dependencies on PN_VAR_TEMPLATES_ALL

Line 60: from PN_VAR_TEMPLATES_ALL

56: ) is
57:
58: cursor C is
59: select ROWID
60: from PN_VAR_TEMPLATES_ALL
61: where AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID;
62:
63: l_return_status VARCHAR2(30) := NULL;
64:

Line 75: insert into PN_VAR_TEMPLATES_ALL (

71: into X_AGREEMENT_TEMPLATE_ID
72: FROM DUAL;
73: END IF;
74:
75: insert into PN_VAR_TEMPLATES_ALL (
76: AGREEMENT_TEMPLATE_ID,
77: AGREEMENT_TEMPLATE,
78: PURPOSE_CODE,
79: TYPE_CODE,

Line 234: from PN_VAR_TEMPLATES_ALL

230: ) is
231: cursor c1
232: is
233: select *
234: from PN_VAR_TEMPLATES_ALL
235: where AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID
236: for update of AGREEMENT_TEMPLATE_ID nowait;
237:
238: tlinfo c1%rowtype;

Line 600: update PN_VAR_TEMPLATES_ALL set

596: BEGIN
597:
598: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');
599:
600: update PN_VAR_TEMPLATES_ALL set
601: AGREEMENT_TEMPLATE = X_AGREEMENT_TEMPLATE,
602: PURPOSE_CODE = X_PURPOSE_CODE,
603: TYPE_CODE = X_TYPE_CODE,
604: CUMULATIVE_VOL = X_CUMULATIVE_VOL,

Line 665: delete from PN_VAR_TEMPLATES_ALL

661: BEGIN
662:
663: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (+)');
664:
665: delete from PN_VAR_TEMPLATES_ALL
666: where AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID;
667:
668: if (sql%notfound) then
669: raise no_data_found;

Line 688: FROM pn_var_templates_all

684: SELECT 1
685: INTO l_dummy
686: FROM DUAL
687: WHERE NOT EXISTS (SELECT 1
688: FROM pn_var_templates_all
689: WHERE agreement_template = x_name
690: AND ((x_template_id IS NULL)
691: OR (agreement_template_id <> x_template_id))
692: AND nvl(org_id, -99) = nvl(x_org_id,nvl(org_id, -99))