APPS.PJM_PROJECT_PARAMS_PKG dependencies on PJM_PROJECT_PARAMETERS

Line 46: SELECT rowid FROM pjm_project_parameters

42: , X_LAST_UPDATE_LOGIN IN NUMBER
43: ) IS
44:
45: CURSOR c IS
46: SELECT rowid FROM pjm_project_parameters
47: WHERE project_id = X_project_id
48: AND organization_id = X_organization_id
49: ;
50:

Line 53: INSERT INTO pjm_project_parameters

49: ;
50:
51: BEGIN
52:
53: INSERT INTO pjm_project_parameters
54: ( project_id
55: , organization_id
56: , creation_date
57: , created_by

Line 204: FROM pjm_project_parameters

200: , attribute12
201: , attribute13
202: , attribute14
203: , attribute15
204: FROM pjm_project_parameters
205: WHERE project_id = X_project_id
206: AND organization_id = X_organization_id
207: FOR UPDATE OF project_id NOWAIT;
208:

Line 355: UPDATE pjm_project_parameters

351: , X_LAST_UPDATE_LOGIN IN NUMBER
352: ) IS
353: BEGIN
354:
355: UPDATE pjm_project_parameters
356: SET costing_group_id = X_costing_group_id
357: , wip_acct_class_code = X_wip_acct_class_code
358: , eam_acct_class_code = X_eam_acct_class_code
359: , ipv_expenditure_type = X_ipv_expenditure_type

Line 403: DELETE FROM pjm_project_parameters

399: , X_ORGANIZATION_ID IN NUMBER
400: ) IS
401: BEGIN
402:
403: DELETE FROM pjm_project_parameters
404: WHERE project_id = X_project_id
405: AND organization_id = X_organization_id;
406:
407: IF (sql%notfound ) THEN

Line 426: FROM pjm_project_parameters

422: -- pragma autonomous_transaction;
423:
424: CURSOR pp IS
425: SELECT organization_id
426: FROM pjm_project_parameters
427: WHERE project_id = X_project_id
428: FOR UPDATE OF planning_group NOWAIT;
429:
430: BEGIN

Line 434: UPDATE pjm_project_parameters

430: BEGIN
431:
432: FOR pprec IN pp LOOP
433:
434: UPDATE pjm_project_parameters
435: SET planning_group = X_planning_group
436: , last_update_date = sysdate
437: , last_updated_by = fnd_global.user_id
438: , last_update_login = fnd_global.login_id