DBA Data[Home] [Help]

APPS.PA_CINT_RATE_PKG dependencies on PA_CINT_RATE_INFO_ALL

Line 151: print_msg('inserting row into pa_cint_rate_info_all ');

147: BEGIN
148: x_return_status := 'S';
149: x_error_msg_code := Null;
150:
151: print_msg('inserting row into pa_cint_rate_info_all ');
152: INSERT INTO pa_cint_rate_info_all
153: ( IND_COST_CODE
154: ,ORG_ID
155: ,EXP_ORG_SOURCE

Line 152: INSERT INTO pa_cint_rate_info_all

148: x_return_status := 'S';
149: x_error_msg_code := Null;
150:
151: print_msg('inserting row into pa_cint_rate_info_all ');
152: INSERT INTO pa_cint_rate_info_all
153: ( IND_COST_CODE
154: ,ORG_ID
155: ,EXP_ORG_SOURCE
156: ,PROJ_AMT_THRESHOLD

Line 193: FROM pa_cint_rate_info_all

189:
190: /* Retrive the rowid and pass it to Forms */
191: Select rowid
192: INTO x_rowid
193: FROM pa_cint_rate_info_all
194: WHERE IND_COST_CODE = p_ind_cost_code
195: AND EXP_ORG_SOURCE = p_EXP_ORG_SOURCE
196: AND ORG_ID = p_org_id;
197:

Line 231: UPDATE pa_cint_rate_info_all

227: BEGIN
228: x_return_status := 'S';
229: x_error_msg_code := Null;
230:
231: UPDATE pa_cint_rate_info_all
232: SET EXP_ORG_SOURCE = p_EXP_ORG_SOURCE
233: ,PROJ_AMT_THRESHOLD = p_PROJ_AMT_THRESHOLD
234: ,TASK_AMT_THRESHOLD = p_TASK_AMT_THRESHOLD
235: ,PROJ_DURATION_THRESHOLD = p_PROJ_DURATION_THRESHOLD

Line 264: DELETE from pa_cint_rate_info_all

260: x_return_status VARCHAR2(1000):= 'S';
261: x_error_msg_code VARCHAR2(1000) := Null;
262:
263: BEGIN
264: DELETE from pa_cint_rate_info_all
265: WHERE ind_cost_code = p_ind_cost_code
266: AND org_id = p_org_id ;
267:
268: EXCEPTION