DBA Data[Home] [Help]

APPS.CN_INT_ASSIGN_PKG dependencies on CN_CAL_PER_INT_TYPES_ALL

Line 30: FROM cn_cal_per_int_types_all

26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
28: CURSOR c IS
29: SELECT ROWID
30: FROM cn_cal_per_int_types_all
31: WHERE cal_per_int_type_id = x_cal_per_int_type_id;
32: l_dummy ROWID;
33: BEGIN
34: IF (x_cal_per_int_type_id IS NULL) THEN

Line 95: FROM cn_cal_per_int_types_all

91: )
92: IS
93: CURSOR c IS
94: SELECT cal_period_id, interval_number, interval_type_id, org_id
95: FROM cn_cal_per_int_types_all
96: WHERE cal_per_int_type_id = x_cal_per_int_type_id
97: FOR UPDATE OF cal_per_int_type_id nowait;
98:
99: rec c%ROWTYPE;

Line 128: UPDATE cn_cal_per_int_types_all SET

124: app_exception.raise_exception;
125: END IF;
126: CLOSE c;
127:
128: UPDATE cn_cal_per_int_types_all SET
129: interval_number = x_interval_number,
130: last_update_date = x_last_update_date,
131: last_updated_by = x_last_updated_by,
132: last_update_login = x_last_update_login