DBA Data[Home] [Help]

APPS.PA_ACCUM_COLUMNS_PKG dependencies on PA_ACCUM_COLUMNS

Line 1: package body PA_ACCUM_COLUMNS_PKG as

1: package body PA_ACCUM_COLUMNS_PKG as
2: /* $Header: PAREPACB.pls 120.0 2005/05/29 12:15:16 appldev noship $ */
3: procedure INSERT_ROW (
4: X_PROJECT_TYPE_CLASS_CODE in VARCHAR2,
5: X_COLUMN_ID in NUMBER,

Line 17: insert into PA_ACCUM_COLUMNS (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into PA_ACCUM_COLUMNS (
18: PROJECT_TYPE_CLASS_CODE,
19: COLUMN_ID,
20: ACCUM_CATEGORY_CODE,
21: ACCUM_COLUMN_CODE,

Line 55: update PA_ACCUM_COLUMNS set

51: X_OWNER IN VARCHAR2,
52: X_DESCRIPTION IN VARCHAR2) is
53: begin
54:
55: update PA_ACCUM_COLUMNS set
56: DESCRIPTION = X_DESCRIPTION,
57: LAST_UPDATE_DATE = sysdate,
58: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
59: LAST_UPDATE_LOGIN = 0

Line 89: update PA_ACCUM_COLUMNS set

85: X_LAST_UPDATED_BY in NUMBER,
86: X_LAST_UPDATE_LOGIN in NUMBER
87: ) is
88: begin
89: update PA_ACCUM_COLUMNS set
90: PROJECT_TYPE_CLASS_CODE = X_PROJECT_TYPE_CLASS_CODE,
91: ACCUM_COLUMN_CODE = X_ACCUM_COLUMN_CODE,
92: ACCUM_CATEGORY_CODE = X_ACCUM_CATEGORY_CODE,
93: ACCUM_FLAG = X_ACCUM_FLAG,

Line 110: end PA_ACCUM_COLUMNS_PKG;

106: raise;
107:
108: end UPDATE_ROW;
109:
110: end PA_ACCUM_COLUMNS_PKG;