DBA Data[Home] [Help]

APPS.OKS_RULE_MIGRATE dependencies on OKS_ACTION_TIMES

Line 37983: DELETE OKS_ACTION_TIMES

37979: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37980:
37981: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37982:
37983: DELETE OKS_ACTION_TIMES
37984: WHERE CLE_ID = L_CLE_ID
37985: AND DNZ_CHR_ID = L_DNZ_CHR_ID;
37986:
37987: DELETE OKS_ACTION_TIME_TYPES

Line 38186: insert into oks_action_times oat (

38182:
38183:
38184: BEGIN
38185:
38186: insert into oks_action_times oat (
38187: id, cov_action_type_id, cle_id, dnz_chr_id, sun_duration,
38188: mon_duration, tue_duration, wed_duration, thu_duration,
38189: fri_duration, sat_duration, uom_code, created_by, creation_date,
38190: last_updated_by, last_update_date, last_update_login,

Line 38299: DELETE OKS_ACTION_TIMES_H

38295: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
38296:
38297: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
38298:
38299: DELETE OKS_ACTION_TIMES_H
38300: WHERE CLE_ID = L_CLE_ID
38301: AND DNZ_CHR_ID = L_DNZ_CHR_ID
38302: AND MAJOR_VERSION = L_MAJOR_VERSION;
38303:

Line 38518: insert into oks_action_times_h oat (

38514:
38515:
38516: BEGIN
38517:
38518: insert into oks_action_times_h oat (
38519: id, cov_action_type_id, cle_id, dnz_chr_id, sun_duration,
38520: mon_duration, tue_duration, wed_duration, thu_duration,
38521: fri_duration, sat_duration, uom_code, created_by, creation_date,
38522: last_updated_by, last_update_date, last_update_login,