APPS.PER_PROPOSAL_TEMPLATES_PKG dependencies on PER_PROPOSAL_TEMPLATES

Line 1: package body PER_PROPOSAL_TEMPLATES_PKG as

1: package body PER_PROPOSAL_TEMPLATES_PKG as
2: /* $Header: hruptlct.pkb 115.2 1999/11/09 15:05:20 pkm ship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out DATE,

Line 36: insert into PER_PROPOSAL_TEMPLATES (

32: X_LAST_UPDATED_BY in VARCHAR2,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: begin
36: insert into PER_PROPOSAL_TEMPLATES (
37: PROPOSAL_TEMPLATE_ID,
38: PROPOSAL_NAME,
39: DESCRIPTION,
40: TYPE,

Line 66: from PER_PROPOSAL_TEMPLATES

62: cursor CSR_PROPOSAL_NAME (
63: X_PROPOSAL_TEMPLATE_ID in NUMBER
64: ) is
65: select PROPOSAL_NAME
66: from PER_PROPOSAL_TEMPLATES
67: where PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID
68: for update of PROPOSAL_NAME nowait;
69: RECINFO CSR_PROPOSAL_NAME%rowtype;
70: begin

Line 91: update PER_PROPOSAL_TEMPLATES set

87: X_LAST_UPDATED_BY in VARCHAR2,
88: X_LAST_UPDATE_LOGIN in NUMBER
89: ) is
90: begin
91: update PER_PROPOSAL_TEMPLATES set
92: PROPOSAL_NAME = X_PROPOSAL_NAME,
93: DESCRIPTION = X_DESCRIPTION,
94: TYPE = X_TYPE,
95: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 108: delete from PER_PROPOSAL_TEMPLATES

104: procedure DELETE_ROW (
105: X_PROPOSAL_TEMPLATE_ID in NUMBER
106: ) is
107: begin
108: delete from PER_PROPOSAL_TEMPLATES
109: where PROPOSAL_TEMPLATE_ID = X_PROPOSAL_TEMPLATE_ID;
110: if (sql%notfound) then
111: raise no_data_found;
112: end if;

Line 182: update PER_PROPOSAL_TEMPLATES

178: X_LAST_UPDATE_DATE,
179: X_LAST_UPDATED_BY,
180: X_LAST_UPDATE_LOGIN
181: );
182: update PER_PROPOSAL_TEMPLATES
183: set PROPOSAL_NAME = X_PROPOSAL_NAME,
184: DESCRIPTION = X_DESCRIPTION,
185: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 193: end PER_PROPOSAL_TEMPLATES_PKG;

189: and userenv('LANG') = (Select language_code
190: from FND_LANGUAGES where installed_flag = 'B');
191: end TRANSLATE_ROW;
192: --
193: end PER_PROPOSAL_TEMPLATES_PKG;