APPS.PA_STATUS_COLUMN_SETUP_PKG dependencies on PA_STATUS_COLUMN_SETUP

Line 1: package body PA_STATUS_COLUMN_SETUP_PKG as

1: package body PA_STATUS_COLUMN_SETUP_PKG as
2: /* $Header: PAREPSCB.pls 120.3 2005/08/19 16:50:29 mwasowic ship $ */
3: procedure INSERT_ROW (
4: X_FOLDER_CODE in VARCHAR2,
5: X_COLUMN_ORDER in NUMBER,

Line 18: insert into PA_STATUS_COLUMN_SETUP (

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: begin
18: insert into PA_STATUS_COLUMN_SETUP (
19: FOLDER_CODE,
20: COLUMN_ORDER,
21: FORMAT_CODE,
22: COLUMN_NAME,

Line 60: update PA_STATUS_COLUMN_SETUP set

56: X_OWNER in VARCHAR2,
57: X_COLUMN_PROMPT in VARCHAR2) is
58: begin
59:
60: update PA_STATUS_COLUMN_SETUP set
61: COLUMN_PROMPT = X_COLUMN_PROMPT,
62: LAST_UPDATE_DATE = sysdate,
63: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
64: LAST_UPDATE_LOGIN = 0

Line 92: from PA_STATUS_COLUMN_SETUP;

88:
89: if (g_insertflag IS NULL) then
90: select count(*)
91: into X_COUNT
92: from PA_STATUS_COLUMN_SETUP;
93:
94: if (X_COUNT > 0) then
95: g_insertflag := false;
96: else

Line 109: end PA_STATUS_COLUMN_SETUP_PKG;

105: raise;
106:
107: end GET_INSERT_STATUS;
108:
109: end PA_STATUS_COLUMN_SETUP_PKG;