3: --
4: -- Package Name
5: -- CN_INT_TYPE_PKG
6: -- Purpose
7: -- Table handler for CN_INTERVAL_TYPES
8: -- Form
9: -- CNINTTP
10: -- Block
11: -- INTERVAL_TYPES
115: -- Purpose
116: -- Populate the table cn_cal_per_int_types after creating an interval type
117: -- *--------------------------------------------------------------------------*/
118: PROCEDURE post_insert
119: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
116: -- Populate the table cn_cal_per_int_types after creating an interval type
117: -- *--------------------------------------------------------------------------*/
118: PROCEDURE post_insert
119: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
117: -- *--------------------------------------------------------------------------*/
118: PROCEDURE post_insert
119: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
125: x_org_id cn_interval_types.org_id%TYPE
118: PROCEDURE post_insert
119: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
125: x_org_id cn_interval_types.org_id%TYPE
126: );
119: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
125: x_org_id cn_interval_types.org_id%TYPE
126: );
127:
120: x_last_update_date cn_interval_types.last_update_date%TYPE,
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
125: x_org_id cn_interval_types.org_id%TYPE
126: );
127:
128: --/*--------------------------------------------------------------------------*
121: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
122: x_creation_date cn_interval_types.creation_date%TYPE,
123: x_created_by cn_interval_types.created_by%TYPE,
124: x_last_update_login cn_interval_types.last_update_login%TYPE,
125: x_org_id cn_interval_types.org_id%TYPE
126: );
127:
128: --/*--------------------------------------------------------------------------*
129: -- Prodedure Name
130: -- post_delete
131: -- Purpose
132: -- Delete the corresponding records in cn_cal_per_int_types after deleting an interval type
133: -- *--------------------------------------------------------------------------*/
134: PROCEDURE post_delete( x_interval_type_id cn_interval_types.interval_type_id%TYPE);
135:
136: -- --------------------------------------------------------------------+
137: -- Procedure : LOAD_ROW
138: -- Description : Called by FNDLOAD to upload seed datas, this procedure