APPS.PA_RESOURCE_FORMATS_PKG dependencies on PA_RESOURCE_FORMATS

Line 1: package body PA_RESOURCE_FORMATS_PKG as

1: package body PA_RESOURCE_FORMATS_PKG as
2: /* $Header: PAREPRFB.pls 120.0 2005/05/29 11:17:45 appldev noship $ */
3: procedure INSERT_ROW (
4: X_RESOURCE_FORMAT_ID in NUMBER,
5: X_PERSON_ID_FLAG in VARCHAR2,

Line 26: insert into PA_RESOURCE_FORMATS (

22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: begin
26: insert into PA_RESOURCE_FORMATS (
27: RESOURCE_FORMAT_ID,
28: PERSON_ID_FLAG,
29: JOB_ID_FLAG,
30: ORGANIZATION_ID_FLAG,

Line 82: update PA_RESOURCE_FORMATS set

78: X_OWNER in VARCHAR2,
79: X_DESCRIPTION in VARCHAR2) is
80: begin
81:
82: update PA_RESOURCE_FORMATS set
83: DESCRIPTION = X_DESCRIPTION,
84: LAST_UPDATE_DATE = sysdate,
85: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
86: LAST_UPDATE_LOGIN = 0

Line 123: update PA_RESOURCE_FORMATS set

119: X_LAST_UPDATED_BY in NUMBER,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: begin
123: update PA_RESOURCE_FORMATS set
124: PERSON_ID_FLAG = X_PERSON_ID_FLAG,
125: JOB_ID_FLAG = X_JOB_ID_FLAG,
126: ORGANIZATION_ID_FLAG = X_ORGANIZATION_ID_FLAG,
127: VENDOR_ID_FLAG = X_VENDOR_ID_FLAG,

Line 153: end PA_RESOURCE_FORMATS_PKG;

149: raise;
150:
151: end UPDATE_ROW;
152:
153: end PA_RESOURCE_FORMATS_PKG;