378: decode(p_territory_code, null, decode(p_undefined_location, 'Y', 'ACTIVE', 'INVALID'), 'ACTIVE'),
379: --CREATION_DATE,
380: sysdate,
381: --CREATED_BY,
382: fnd_global.user_id,
383: --LAST_UPDATE_DATE,
384: sysdate,
385: --LAST_UPDATED_BY,
386: fnd_global.user_id,
382: fnd_global.user_id,
383: --LAST_UPDATE_DATE,
384: sysdate,
385: --LAST_UPDATED_BY,
386: fnd_global.user_id,
387: --LAST_UPDATE_LOGIN,
388: fnd_global.login_id,
389: --LOCATION_TYPE,
390: p_location_type,
384: sysdate,
385: --LAST_UPDATED_BY,
386: fnd_global.user_id,
387: --LAST_UPDATE_LOGIN,
388: fnd_global.login_id,
389: --LOCATION_TYPE,
390: p_location_type,
391: --CITY_LOCALITY_ID,
392: p_city_locality_id,
418: initcap(l_description),
419: --CREATION_DATE,
420: sysdate,
421: --CREATED_BY,
422: fnd_global.user_id,
423: --LAST_UPDATE_LOGIN,
424: fnd_global.login_id,
425: --LAST_UPDATE_DATE,
426: sysdate,
420: sysdate,
421: --CREATED_BY,
422: fnd_global.user_id,
423: --LAST_UPDATE_LOGIN,
424: fnd_global.login_id,
425: --LAST_UPDATE_DATE,
426: sysdate,
427: --LAST_UPDATED_BY,
428: fnd_global.user_id,
424: fnd_global.login_id,
425: --LAST_UPDATE_DATE,
426: sysdate,
427: --LAST_UPDATED_BY,
428: fnd_global.user_id,
429: --LANGUAGE,
430: L.LANGUAGE_CODE,
431: --SOURCE_LANG
432: NVL(userenv('LANG'),BASE.LANGUAGE_CODE)
819: decode(p_use_free_acc_add, 'Y', 'SINGLE', null),
820: --CREATION_DATE,
821: SYSDATE,
822: --CREATED_BY,
823: fnd_global.user_id,
824: --LAST_UPDATE_LOGIN,
825: fnd_global.login_id,
826: --LAST_UPDATE_DATE,
827: SYSDATE,
821: SYSDATE,
822: --CREATED_BY,
823: fnd_global.user_id,
824: --LAST_UPDATE_LOGIN,
825: fnd_global.login_id,
826: --LAST_UPDATE_DATE,
827: SYSDATE,
828: --LAST_UPDATED_BY
829: fnd_global.user_id
825: fnd_global.login_id,
826: --LAST_UPDATE_DATE,
827: SYSDATE,
828: --LAST_UPDATED_BY
829: fnd_global.user_id
830: );
831:
832: return l_policy_id;
833:
878: 'SAVED',
879: --CREATION_DATE,
880: SYSDATE,
881: --CREATED_BY,
882: fnd_global.user_id,
883: --LAST_UPDATE_LOGIN,
884: fnd_global.login_id,
885: --LAST_UPDATE_DATE,
886: SYSDATE,
880: SYSDATE,
881: --CREATED_BY,
882: fnd_global.user_id,
883: --LAST_UPDATE_LOGIN,
884: fnd_global.login_id,
885: --LAST_UPDATE_DATE,
886: SYSDATE,
887: --LAST_UPDATED_BY
888: fnd_global.user_id
884: fnd_global.login_id,
885: --LAST_UPDATE_DATE,
886: SYSDATE,
887: --LAST_UPDATED_BY
888: fnd_global.user_id
889: );
890:
891: return l_schedule_option_id;
892:
935: p_period_start_date,
936: --CREATION_DATE,
937: SYSDATE,
938: --CREATED_BY,
939: fnd_global.user_id,
940: --LAST_UPDATE_LOGIN,
941: fnd_global.login_id,
942: --LAST_UPDATE_DATE,
943: SYSDATE,
937: SYSDATE,
938: --CREATED_BY,
939: fnd_global.user_id,
940: --LAST_UPDATE_LOGIN,
941: fnd_global.login_id,
942: --LAST_UPDATE_DATE,
943: SYSDATE,
944: --LAST_UPDATED_BY
945: fnd_global.user_id
941: fnd_global.login_id,
942: --LAST_UPDATE_DATE,
943: SYSDATE,
944: --LAST_UPDATED_BY
945: fnd_global.user_id
946: );
947:
948: return l_schedule_period_id;
949:
1082: p_effective_end_date,
1083: --CREATION_DATE,
1084: SYSDATE,
1085: --CREATED_BY,
1086: fnd_global.user_id,
1087: --LAST_UPDATE_LOGIN,
1088: fnd_global.login_id,
1089: --LAST_UPDATE_DATE,
1090: SYSDATE,
1084: SYSDATE,
1085: --CREATED_BY,
1086: fnd_global.user_id,
1087: --LAST_UPDATE_LOGIN,
1088: fnd_global.login_id,
1089: --LAST_UPDATE_DATE,
1090: SYSDATE,
1091: --LAST_UPDATED_BY
1092: fnd_global.user_id
1088: fnd_global.login_id,
1089: --LAST_UPDATE_DATE,
1090: SYSDATE,
1091: --LAST_UPDATED_BY
1092: fnd_global.user_id
1093: );
1094:
1095: return l_policy_line_id;
1096:
1226: p_effective_end_date,
1227: --CREATION_DATE,
1228: SYSDATE,
1229: --CREATED_BY,
1230: fnd_global.user_id,
1231: --LAST_UPDATE_LOGIN,
1232: fnd_global.login_id,
1233: --LAST_UPDATE_DATE,
1234: SYSDATE,
1228: SYSDATE,
1229: --CREATED_BY,
1230: fnd_global.user_id,
1231: --LAST_UPDATE_LOGIN,
1232: fnd_global.login_id,
1233: --LAST_UPDATE_DATE,
1234: SYSDATE,
1235: --LAST_UPDATED_BY
1236: fnd_global.user_id
1232: fnd_global.login_id,
1233: --LAST_UPDATE_DATE,
1234: SYSDATE,
1235: --LAST_UPDATED_BY
1236: fnd_global.user_id
1237: );
1238:
1239: return l_night_rate_line_id;
1240:
3416: BEGIN
3417:
3418: --g_debug_switch := p_debug_switch;
3419: g_debug_switch := 'Y';
3420: g_last_updated_by := to_number(FND_GLOBAL.USER_ID);
3421: g_last_update_login := to_number(FND_GLOBAL.LOGIN_ID);
3422: g_invalid_locs := Invalid_Locs('');
3423: g_zero_rates := Zero_Rates('');
3424:
3417:
3418: --g_debug_switch := p_debug_switch;
3419: g_debug_switch := 'Y';
3420: g_last_updated_by := to_number(FND_GLOBAL.USER_ID);
3421: g_last_update_login := to_number(FND_GLOBAL.LOGIN_ID);
3422: g_invalid_locs := Invalid_Locs('');
3423: g_zero_rates := Zero_Rates('');
3424:
3425:
3422: g_invalid_locs := Invalid_Locs('');
3423: g_zero_rates := Zero_Rates('');
3424:
3425:
3426: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3427:
3428: IF g_debug_switch = 'Y' THEN
3429: --
3430: put_line('------------------------------------------------------------');