APPS.PJI_SYSTEM_SETTINGS_PKG dependencies on PJI_SYSTEM_SETTINGS

Line 1: PACKAGE BODY PJI_SYSTEM_SETTINGS_PKG AS

1: PACKAGE BODY PJI_SYSTEM_SETTINGS_PKG AS
2: /* $Header: PJISYSTB.pls 120.1.12020000.2 2012/07/18 10:57:22 admarath ship $ */
3: PROCEDURE insert_row (
4: p_setting_id IN NUMBER,
5: p_pa_period_flag IN VARCHAR2,

Line 27: INSERT INTO pji_system_settings (

23: x_msg_data OUT NOCOPY VARCHAR2
24: ) IS
25: BEGIN
26:
27: INSERT INTO pji_system_settings (
28: SETTING_ID ,
29: PA_PERIOD_FLAG ,
30: GL_PERIOD_FLAG ,
31: PLANAMT_ALLOC_METHOD ,

Line 107: UPDATE pji_system_settings SET

103: l_msg_count NUMBER;
104: l_msg_data VARCHAR2(30);
105: BEGIN
106:
107: UPDATE pji_system_settings SET
108: PA_PERIOD_FLAG = p_PA_PERIOD_FLAG,
109: GL_PERIOD_FLAG = p_GL_PERIOD_FLAG,
110: PLANAMT_ALLOC_METHOD = p_PLANAMT_ALLOC_METHOD,
111: PRJ_CURR_FLAG = p_PRJ_CURR_FLAG,

Line 163: delete from PJI_SYSTEM_SETTINGS where SETTING_ID = p_SETTING_ID;

159: ) IS
160: BEGIN
161:
162:
163: delete from PJI_SYSTEM_SETTINGS where SETTING_ID = p_SETTING_ID;
164:
165: END delete_row;
166:
167: END; --end package pji_system_settings

Line 167: END; --end package pji_system_settings

163: delete from PJI_SYSTEM_SETTINGS where SETTING_ID = p_SETTING_ID;
164:
165: END delete_row;
166:
167: END; --end package pji_system_settings