eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_NET_RES_INST_AVAIL

Line 1: PACKAGE BODY MSC_NET_RES_INST_AVAILABILITY AS

1: PACKAGE BODY MSC_NET_RES_INST_AVAILABILITY AS
2: /* $Header: MSCNRIAB.pls 120.2 2006/01/12 03:28:15 abhikuma noship $ */
3:
4:
5: var_gt_user_id number;

Line 115: UPDATE msc_net_res_inst_avail

111: if var_time1 < var_from_time then
112: var_date1 := var_date1 + 1;
113: end if;
114:
115: UPDATE msc_net_res_inst_avail
116: SET shift_date = var_date1,
117: from_time = var_time1,
118: to_time = var_time2
119: WHERE rowid = var_rowid;

Line 136: DELETE from msc_net_res_inst_avail

132: */
133: --dbms_output.put_line('about to delete');
134: log_message('about to delete');
135:
136: DELETE from msc_net_res_inst_avail
137: WHERE rowid = var_rowid;
138: --dbms_output.put_line('delete row count ' || sql%rowcount);
139: log_message('delete row count ' || sql%rowcount);
140: END delete_avail;

Line 186: INSERT into msc_net_res_inst_avail(

182: ' units '|| to_char(var_cap_units));
183: end if;
184: */
185:
186: INSERT into msc_net_res_inst_avail(
187: inst_transaction_id,
188: plan_id,
189: sr_instance_id,
190: organization_id,

Line 215: VALUES( msc_net_res_inst_avail_s.NEXTVAL,

211: program_application_id,
212: program_id,
213: program_update_date,
214: refresh_number)
215: VALUES( msc_net_res_inst_avail_s.NEXTVAL,
216: -1,
217: var_sr_instance_id,
218: var_organization_id,
219: var_department_id,

Line 339: FROM msc_net_res_inst_avail

335: DECODE(LEAST(to_time, from_time),
336: to_time, to_time + 24*3600,
337: to_time) to_time,
338: rowid
339: FROM msc_net_res_inst_avail
340: WHERE plan_id = -1
341: AND department_id = arg_department_id
342: AND resource_id = arg_resource_id
343: AND res_instance_id = arg_instance_id

Line 374: INSERT into msc_net_res_inst_avail(

370:
371: -- IF NOT 24HR
372: if arg_24hr_flag = 2 THEN
373:
374: INSERT into msc_net_res_inst_avail(
375: inst_transaction_id,
376: plan_id,
377: sr_instance_id,
378: organization_id,

Line 403: select msc_net_res_inst_avail_s.NEXTVAL,

399: program_application_id,
400: program_id,
401: program_update_date,
402: refresh_number)
403: select msc_net_res_inst_avail_s.NEXTVAL,
404: -1,
405: arg_sr_instance_id,
406: arg_organization_id,
407: arg_department_id,

Line 481: FROM msc_net_res_inst_avail

477:
478: -- debug
479: /*
480: select count(*) into var_rowcount
481: FROM msc_net_res_inst_avail
482: where resource_id = arg_resource_id
483: and instance_id = arg_instance_id
484: and department_id = arg_department_id;
485:

Line 492: insert into msc_net_res_inst_avail(

488: else
489:
490: --dbms_output.put_line(' Inserted -- it is a 24 hrs');
491: log_message(' Inserted -- it is a 24 hrs');
492: insert into msc_net_res_inst_avail(
493: inst_transaction_id,
494: plan_id,
495: sr_instance_id,
496: organization_id,

Line 521: select msc_net_res_inst_avail_s.NEXTVAL,

517: program_application_id,
518: program_id,
519: program_update_date,
520: refresh_number)
521: select msc_net_res_inst_avail_s.NEXTVAL,
522: -1,
523: arg_sr_instance_id,
524: arg_organization_id,
525: arg_department_id,

Line 732: INSERT into msc_net_res_inst_avail(

728:
729: -- Finally add the availability from the add workday type modifications
730: --dbms_output.put_line('going to insert added workdays');
731: log_message('going to insert added workdays');
732: INSERT into msc_net_res_inst_avail(
733: inst_transaction_id,
734: plan_id,
735: sr_instance_id,
736: organization_id,

Line 761: select msc_net_res_inst_avail_s.NEXTVAL,

757: program_application_id,
758: program_id,
759: program_update_date,
760: refresh_number)
761: select msc_net_res_inst_avail_s.NEXTVAL,
762: -1,
763: arg_sr_instance_id,
764: arg_organization_id,
765: arg_department_id,

Line 1070: --dbms_output.put_line('Delete msc_net_res_inst_avail');

1066:
1067: if arg_refresh_flag = 2 then
1068: -- v_stmt := 100;
1069:
1070: --dbms_output.put_line('Delete msc_net_res_inst_avail');
1071: log_message('Delete msc_net_res_inst_avail');
1072:
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid

Line 1071: log_message('Delete msc_net_res_inst_avail');

1067: if arg_refresh_flag = 2 then
1068: -- v_stmt := 100;
1069:
1070: --dbms_output.put_line('Delete msc_net_res_inst_avail');
1071: log_message('Delete msc_net_res_inst_avail');
1072:
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid
1075: from msc_net_res_inst_avail res,

Line 1073: delete from msc_net_res_inst_avail

1069:
1070: --dbms_output.put_line('Delete msc_net_res_inst_avail');
1071: log_message('Delete msc_net_res_inst_avail');
1072:
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid
1075: from msc_net_res_inst_avail res,
1076: msc_resource_changes chg,
1077: msc_department_resources dept

Line 1075: from msc_net_res_inst_avail res,

1071: log_message('Delete msc_net_res_inst_avail');
1072:
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid
1075: from msc_net_res_inst_avail res,
1076: msc_resource_changes chg,
1077: msc_department_resources dept
1078: where res.organization_id = arg_organization_id
1079: and res.sr_instance_id = arg_sr_instance_id

Line 1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');

1152:
1153: LOG_MESSAGE('========================================');
1154: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1155: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RES_INSTANCES');
1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
1157: LOG_MESSAGE(FND_MESSAGE.GET);
1158:
1159: LOG_MESSAGE(SQLERRM);
1160:

Line 1183: END MSC_NET_RES_INST_AVAILABILITY;

1179: END IF;
1180: END LOG_MESSAGE;
1181:
1182:
1183: END MSC_NET_RES_INST_AVAILABILITY;