DBA Data[Home] [Help]

APPS.FND_DICTIONARY_PKG dependencies on FND_LOAD_UTIL

Line 1703: f_luby := fnd_load_util.owner_id(x_user_id);

1699: app_exception.raise_exception;
1700: end;
1701:
1702: -- Translate owner to file_last_updated_by
1703: f_luby := fnd_load_util.owner_id(x_user_id);
1704:
1705: -- Translate char last_update_date to date
1706: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1707:

Line 1715: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

1711: from FND_TABLES
1712: where APPLICATION_ID = appl_id
1713: and TABLE_NAME = x_table_name;
1714:
1715: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1716: db_ludate, X_CUSTOM_MODE)) then
1717:
1718: -- Resolve USER_TABLE_NAME by pre-pending '@'
1719: update FND_TABLES

Line 1824: f_luby := fnd_load_util.owner_id(x_user_id);

1820: ResolveConflictColumn(appl_id, tab_id, x_column_name, x_user_column_name,
1821: x_column_sequence);
1822:
1823: -- Translate owner to file_last_updated_by
1824: f_luby := fnd_load_util.owner_id(x_user_id);
1825:
1826: -- Translate char last_update_date to date
1827: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1828:

Line 1837: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

1833: where APPLICATION_ID = appl_id
1834: and TABLE_ID = tab_id
1835: and COLUMN_NAME = x_column_name;
1836:
1837: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1838: db_ludate, X_CUSTOM_MODE)) then
1839:
1840: update FND_COLUMNS set
1841: USER_COLUMN_NAME = x_user_column_name,

Line 1922: f_luby := fnd_load_util.owner_id(x_user_id);

1918: from FND_APPLICATION A
1919: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1920:
1921: -- Translate owner to file_last_updated_by
1922: f_luby := fnd_load_util.owner_id(x_user_id);
1923:
1924: -- Translate char last_update_date to date
1925: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1926:

Line 1935: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

1931: where APPLICATION_ID = appl_id
1932: and TABLE_NAME = x_table_name
1933: and COLUMN_NAME = x_column_name;
1934:
1935: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1936: db_ludate, X_CUSTOM_MODE)) then
1937:
1938: update FND_HISTOGRAM_COLS set
1939: PARTITION = x_partition,

Line 2035: f_luby := fnd_load_util.owner_id(x_user_id);

2031:
2032: if (x_phase_mode = 'BEGIN') then
2033:
2034: -- Translate owner to file_last_updated_by
2035: f_luby := fnd_load_util.owner_id(x_user_id);
2036:
2037: -- Translate char last_update_date to date
2038: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
2039:

Line 2056: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

2052: where APPLICATION_ID = appl_id
2053: and TABLE_ID = tab_id
2054: and INDEX_NAME = x_index_name;
2055:
2056: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2057: db_ludate, X_CUSTOM_MODE)) then
2058:
2059: update FND_INDEXES set
2060: UNIQUENESS = x_uniqueness,

Line 2211: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then

2207: end if;
2208:
2209: -- Bug2631776 perform check to see if update occurs or not.
2210:
2211: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then
2212:
2213: -- The new child entity rows from the data file are kept so
2214: -- delete the existing db child entity rows.
2215:

Line 2344: f_luby := fnd_load_util.owner_id(x_user_id);

2340: app_exception.raise_exception;
2341: end;
2342:
2343: -- Translate owner to file_last_updated_by
2344: f_luby := fnd_load_util.owner_id(x_user_id);
2345:
2346: -- Translate char last_update_date to date
2347: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
2348:

Line 2486: f_luby := fnd_load_util.owner_id(x_user_id);

2482:
2483: if (x_phase_mode = 'BEGIN') then
2484:
2485: -- Translate owner to file_last_updated_by
2486: f_luby := fnd_load_util.owner_id(x_user_id);
2487:
2488: -- Translate char last_update_date to date
2489: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
2490:

Line 2502: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

2498: and PRIMARY_KEY_NAME = x_primary_key_name;
2499:
2500: if (pkmode = 'UPDATE') then
2501:
2502: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2503: db_ludate, X_CUSTOM_MODE)) then
2504: update FND_PRIMARY_KEYS set
2505: PRIMARY_KEY_TYPE = x_primary_key_type,
2506: AUDIT_KEY_FLAG = x_audit_key_flag,

Line 2652: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then

2648: end if;
2649:
2650: -- Bug2631776 perform check to see if update occurs or not.
2651:
2652: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then
2653:
2654: -- The new child entity rows from the data file are kept so
2655: -- delete the existing db child entity rows.
2656:

Line 2787: f_luby := fnd_load_util.owner_id(x_user_id);

2783: app_exception.raise_exception;
2784: end;
2785:
2786: -- Translate owner to file_last_updated_by
2787: f_luby := fnd_load_util.owner_id(x_user_id);
2788:
2789: -- Translate char last_update_date to date
2790: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
2791:

Line 2906: f_luby := fnd_load_util.owner_id(x_user_id);

2902: if (x_phase_mode = 'BEGIN') then
2903:
2904:
2905: -- Translate owner to file_last_updated_by
2906: f_luby := fnd_load_util.owner_id(x_user_id);
2907:
2908: -- Translate char last_update_date to date
2909: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
2910:

Line 2927: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

2923: where APPLICATION_ID = appl_id
2924: and TABLE_ID = tab_id
2925: and FOREIGN_KEY_NAME = x_foreign_key_name;
2926:
2927: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2928: db_ludate, X_CUSTOM_MODE)) then
2929:
2930: update FND_FOREIGN_KEYS set
2931: PRIMARY_KEY_APPLICATION_ID = pk_appl_id,

Line 3078: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then

3074: end if;
3075:
3076: -- Bug2631776 perform check to see if update occurs or not.
3077:
3078: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then
3079:
3080: -- The new child entity rows from the data file are kept so
3081: -- delete the existing db child entity rows.
3082:

Line 3213: f_luby := fnd_load_util.owner_id(x_user_id);

3209: app_exception.raise_exception;
3210: end;
3211:
3212: -- Translate owner to file_last_updated_by
3213: f_luby := fnd_load_util.owner_id(x_user_id);
3214:
3215: -- Translate char last_update_date to date
3216: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
3217:

Line 3300: f_luby := fnd_load_util.owner_id(x_user_id);

3296: app_exception.raise_exception;
3297: end;
3298:
3299: -- Translate owner to file_last_updated_by
3300: f_luby := fnd_load_util.owner_id(x_user_id);
3301:
3302: -- Translate char last_update_date to date
3303: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
3304:

Line 3312: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

3308: from FND_SEQUENCES
3309: where APPLICATION_ID = appl_id
3310: and SEQUENCE_NAME = x_sequence_name;
3311:
3312: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3313: db_ludate, X_CUSTOM_MODE)) then
3314:
3315:
3316: -- Check if this is a new table or old table

Line 3398: f_luby := fnd_load_util.owner_id(x_user_id);

3394:
3395: if (x_phase_mode = 'BEGIN') then
3396:
3397: -- Translate owner to file_last_updated_by
3398: f_luby := fnd_load_util.owner_id(x_user_id);
3399:
3400: -- Translate char last_update_date to date
3401: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
3402:

Line 3417: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

3413: from FND_VIEWS
3414: where APPLICATION_ID = appl_id
3415: and VIEW_NAME = x_view_name;
3416:
3417: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3418: db_ludate, X_CUSTOM_MODE)) then
3419:
3420: update FND_VIEWS set
3421: TEXT = x_text,

Line 3521: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then

3517: end if;
3518:
3519: -- Bug2631776 perform check to see if update occurs or not.
3520:
3521: if (fnd_load_util.upload_test(child_file_luby, child_file_ludate, child_db_luby, child_db_ludate, x_custom_mode)) then
3522:
3523: -- The new child entity rows from the data file are kept so
3524: -- delete the existing db child entity rows.
3525:

Line 3608: f_luby := fnd_load_util.owner_id(x_user_id);

3604: where V.APPLICATION_ID = appl_id
3605: and V.VIEW_NAME = x_view_name;
3606:
3607: -- Translate owner to file_last_updated_by
3608: f_luby := fnd_load_util.owner_id(x_user_id);
3609:
3610: -- Translate char last_update_date to date
3611: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
3612: