1822: else
1823: f_luby := 0;
1824: end if;*/
1825:
1826: f_luby := fnd_load_util.owner_id(P_OWNER);
1827:
1828: -- Translate char last_update_date to date
1829: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
1830:
1839: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1840: /*if ((p_cust_mode = 'FORCE') or
1841: ((f_luby = 0) and (db_luby = 1)) or
1842: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
1843: /* if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
1844: p_cust_mode))
1845: then*/
1846: -- seed data must not be changed by customers.Hence overwriting data always
1847: -- so that it covers up any changes by mistake
1917: else
1918: f_luby := 0;
1919: end if;*/
1920:
1921: f_luby := fnd_load_util.owner_id(P_OWNER);
1922:
1923: -- Translate char last_update_date to date
1924: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
1925:
1935: -- 5953806 - replaced to if statement to follow FNDLOAD standards
1936: /*if ((p_cust_mode = 'FORCE') or
1937: ((f_luby = 0) and (db_luby = 1)) or
1938: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
1939: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
1940: p_cust_mode))
1941: then*/
1942: -- seed data must not be changed by customers.Hence overwriting data always
1943: -- so that it covers up any changes by mistake
2048: else
2049: f_luby := 0;
2050: end if;*/
2051:
2052: f_luby := fnd_load_util.owner_id(P_OWNER);
2053:
2054: -- Translate char last_update_date to date
2055: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
2056:
2074: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2075: /*if ((p_cust_mode = 'FORCE') or
2076: ((f_luby = 0) and (db_luby = 1)) or
2077: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2078: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2079: p_cust_mode))
2080: then*/
2081: -- seed data must not be changed by customers.Hence overwriting data always
2082: -- so that it covers up any changes by mistake
2267: else
2268: f_luby := 0;
2269: end if;*/
2270:
2271: f_luby := fnd_load_util.owner_id(P_OWNER);
2272:
2273: -- Translate char last_update_date to date
2274: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
2275:
2288: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2289: /*if ((p_cust_mode = 'FORCE') or
2290: ((f_luby = 0) and (db_luby = 1)) or
2291: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2292: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2293: p_cust_mode))
2294: then*/
2295: -- seed data must not be changed by customers.Hence overwriting data always
2296: -- so that it covers up any changes by mistake
2381: else
2382: f_luby := 0;
2383: end if;*/
2384:
2385: f_luby := fnd_load_util.owner_id(P_OWNER);
2386:
2387: -- Translate char last_update_date to date
2388: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
2389:
2401: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2402: /*if ((p_cust_mode = 'FORCE') or
2403: ((f_luby = 0) and (db_luby = 1)) or
2404: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2405: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2406: p_cust_mode))
2407: then*/
2408: -- seed data must not be changed by customers.Hence overwriting data always
2409: -- so that it covers up any changes by mistake
2498: else
2499: f_luby := 0;
2500: end if;*/
2501:
2502: f_luby := fnd_load_util.owner_id(P_OWNER);
2503:
2504: -- Translate char last_update_date to date
2505: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2506:
2518: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2519: /*if ((p_cust_mode = 'FORCE') or
2520: ((f_luby = 0) and (db_luby = 1)) or
2521: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2522: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2523: p_cust_mode))
2524: then*/
2525: -- seed data must not be changed by customers.Hence overwriting data always
2526: -- so that it covers up any changes by mistake
2656: else
2657: f_luby := 0;
2658: end if;*/
2659:
2660: f_luby := fnd_load_util.owner_id(P_OWNER);
2661:
2662: -- Translate char last_update_date to date
2663: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2664:
2677: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2678: /*if ((p_cust_mode = 'FORCE') or
2679: ((f_luby = 0) and (db_luby = 1)) or
2680: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2681: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2682: p_cust_mode))
2683: then*/
2684: -- seed data must not be changed by customers.Hence overwriting data always
2685: -- so that it covers up any changes by mistake
2773: else
2774: f_luby := 0;
2775: end if;*/
2776:
2777: f_luby := fnd_load_util.owner_id(P_OWNER);
2778:
2779: -- Translate char last_update_date to date
2780: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
2781:
2793: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2794: /*if ((p_cust_mode = 'FORCE') or
2795: ((f_luby = 0) and (db_luby = 1)) or
2796: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2797: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2798: p_cust_mode))
2799: then*/
2800: -- seed data must not be changed by customers.Hence overwriting data always
2801: -- so that it covers up any changes by mistake
2906: else
2907: f_luby := 0;
2908: end if;*/
2909:
2910: f_luby := fnd_load_util.owner_id(P_OWNER);
2911:
2912: -- Translate char last_update_date to date
2913: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
2914:
2923: -- 5953806 - replaced to if statement to follow FNDLOAD standards
2924: /*if ((p_cust_mode = 'FORCE') or
2925: ((f_luby = 0) and (db_luby = 1)) or
2926: ((f_luby = db_luby) and (f_ludate > db_ludate)))*/
2927: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
2928: p_cust_mode))
2929: then*/
2930: -- seed data must not be changed by customers.Hence overwriting data always
2931: -- so that it covers up any changes by mistake
3054:
3055: BEGIN
3056:
3057: -- Translate owner to file_last_updated_by
3058: f_luby := fnd_load_util.owner_id(P_OWNER);
3059:
3060: -- Translate char last_update_date to date
3061: f_ludate := nvl(to_date(p_ludate, 'YYYY/MM/DD'), sysdate);
3062:
3067: where name = p_name;
3068:
3069: -- Update record only as per standard
3070:
3071: /*if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
3072: p_cust_mode))
3073: then*/
3074: -- seed data must not be changed by customers.Hence overwriting data always
3075: -- so that it covers up any changes by mistake