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.CSP_SCH_INT_PVT dependencies on FND_PROFILE

Line 248: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');

244: l_temp_line_id NUMBER;
245: l_total_parts NUMBER := 0;
246: l_subinv_only BOOLEAN := p_subinv_only;
247: --hehxxx
248: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
249:
250: cursor get_line_id is
251: select distinct(crl.requirement_line_id) req_line_id
252: from csp_requirement_lines crl,csp_requirement_headers crh

Line 1099: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or

1095: 'l_final_unavailable_list.count=' || l_final_unavailable_list.count);
1096: end if;
1097:
1098: elsif (l_unavailable_list.count > 0 AND (NOT l_subinv_only) AND
1099: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
1100: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' )) or
1101: (l_unavailable_list.count > 0 and nvl(p_warehouse,FALSE)) THEN
1102: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
1103: ELSE

Line 1100: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' )) or

1096: end if;
1097:
1098: elsif (l_unavailable_list.count > 0 AND (NOT l_subinv_only) AND
1099: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
1100: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' )) or
1101: (l_unavailable_list.count > 0 and nvl(p_warehouse,FALSE)) THEN
1102: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
1103: ELSE
1104: l_final_unavailable_list := l_unavailable_list;

Line 1326: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');

1322: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
1323: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;
1324: l_address_type varchar2(3);
1325: --hehxxx
1326: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
1327: x_options CSP_SCH_INT_PVT.csp_sch_options_tbl_typ;
1328: l_req_line_details_id number := null;
1329: l_old_operating_unit number := null;
1330: l_book_order varchar2(30) := fnd_profile.value('CSP_INIT_IO_STATUS');

Line 1330: l_book_order varchar2(30) := fnd_profile.value('CSP_INIT_IO_STATUS');

1326: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
1327: x_options CSP_SCH_INT_PVT.csp_sch_options_tbl_typ;
1328: l_req_line_details_id number := null;
1329: l_old_operating_unit number := null;
1330: l_book_order varchar2(30) := fnd_profile.value('CSP_INIT_IO_STATUS');
1331: l_need_by_date date := null;
1332:
1333: cursor get_asgn_id is
1334: select task_assignment_id

Line 1744: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

1740: open c2;
1741: fetch c2 into l_requirement_header_id,l_address_type;
1742: close c2;
1743: l_parts_header.requirement_header_id := l_requirement_header_id;
1744: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
1745: l_parts_header.SHIP_TO_LOCATION_ID := l_ship_to_location_id;
1746: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
1747: l_parts_header.dest_subinventory := l_destination_sub_inv;
1748: l_parts_header.operation := 'CREATE';

Line 2114: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

2110: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
2111: END IF;
2112: END LOOP;
2113: IF l_parts_lines.count > 0 THEN
2114: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
2115: l_parts_header.SHIP_TO_LOCATION_ID := l_ship_to_location_id;
2116: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
2117: l_parts_header.dest_subinventory := l_destination_sub_inv;
2118: l_parts_header.OPERATION := 'CREATE';

Line 2191: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

2187: IF l_address_type IS NULL or l_address_type = 'R' OR l_address_type = 'S' THEN
2188: l_requirement_header.address_type := 'R';
2189: l_requirement_header.ship_to_location_id := l_ship_to_location_id;
2190: END IF;
2191: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
2192: CSP_Requirement_Headers_PVT.Update_requirement_headers(
2193: P_Api_Version_Number => 1.0,
2194: P_Init_Msg_List => FND_API.G_FALSE,
2195: P_Commit => FND_API.G_FALSE,

Line 2784: fnd_profile.get('CSP_CANCEL_REASON', l_parts_header.change_Reason);

2780: BEGIN
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;
2782: l_parts_header.order_header_id := p_order_id;
2783: --l_parts_header.operation := 'CANCEL';
2784: fnd_profile.get('CSP_CANCEL_REASON', l_parts_header.change_Reason);
2785:
2786:
2787: CSP_PARTS_ORDER.Cancel_Order(
2788: p_header_rec => l_parts_header,

Line 3039: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

3035: FETCH csp_ship_to_location INTO l_ship_to_location_id;
3036: EXIT WHEN csp_ship_to_location% NOTFOUND;
3037: END LOOP;
3038: CLOSE csp_ship_to_location;
3039: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
3040: l_parts_header.SHIP_TO_LOCATION_ID := l_ship_to_location_id;
3041: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
3042: l_parts_header.OPERATION := 'CREATE';
3043: CSP_PARTS_ORDER.process_order(

Line 3301: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or

3297: END IF;
3298: FOR I IN 1..p_resource_org_subinv.count LOOP
3299: FOR J IN 1..p_parts_list.count LOOP
3300: l_required_quantity := 0;
3301: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
3302: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN
3303: if l_alternate_parts.count >0 THEN
3304: l_alternate_parts.delete;
3305: END IF;

Line 3302: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN

3298: FOR I IN 1..p_resource_org_subinv.count LOOP
3299: FOR J IN 1..p_parts_list.count LOOP
3300: l_required_quantity := 0;
3301: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
3302: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN
3303: if l_alternate_parts.count >0 THEN
3304: l_alternate_parts.delete;
3305: END IF;
3306: if l_supersede_items.count > 0 THEN

Line 3333: IF (fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or

3329: END LOOP;
3330: CLOSE substitutes;
3331: END IF;
3332:
3333: IF (fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
3334: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY') and
3335: nvl(p_trunk,TRUE) THEN
3336: l_att := 0;
3337: IF p_parts_list(J).revision IS NOT NULL THEN

Line 3334: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY') and

3330: CLOSE substitutes;
3331: END IF;
3332:
3333: IF (fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
3334: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY') and
3335: nvl(p_trunk,TRUE) THEN
3336: l_att := 0;
3337: IF p_parts_list(J).revision IS NOT NULL THEN
3338: l_revision_controlled := TRUE;

Line 3643: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');

3639: l_hr_location_id number;
3640:
3641: p_required_parts csp_part_search_pvt.required_parts_tbl;
3642: p_search_params apps.csp_part_search_pvt.search_params_rec;
3643: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3644: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3645: l_alternates boolean := FALSE;
3646:
3647: l_organization_id number;

Line 3644: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');

3640:
3641: p_required_parts csp_part_search_pvt.required_parts_tbl;
3642: p_search_params apps.csp_part_search_pvt.search_params_rec;
3643: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3644: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3645: l_alternates boolean := FALSE;
3646:
3647: l_organization_id number;
3648: l_supplied_quantity number;

Line 3836: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');

3832: l_org_id number := null;
3833: l_sr_org_id number := null;
3834: p_required_parts csp_part_search_pvt.required_parts_tbl;
3835: p_search_params apps.csp_part_search_pvt.search_params_rec;
3836: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3837: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3838: l_alternates boolean := FALSE;
3839: l_choose_option boolean := FALSE;
3840:

Line 3837: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');

3833: l_sr_org_id number := null;
3834: p_required_parts csp_part_search_pvt.required_parts_tbl;
3835: p_search_params apps.csp_part_search_pvt.search_params_rec;
3836: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3837: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3838: l_alternates boolean := FALSE;
3839: l_choose_option boolean := FALSE;
3840:
3841: l_organization_id number;

Line 3857: l_distance_uom varchar2(20):= fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT');

3853: l_src_warehouse varchar2(4000) := null;
3854: l_ship_method varchar2(4000) := null;
3855: l_distance_str varchar2(4000) := null;
3856: l_src_org_code varchar2(3) := null;
3857: l_distance_uom varchar2(20):= fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT');
3858: l_dist_temp_str varchar2(10);
3859: l_ship_method_meaning varchar2(1000);
3860:
3861: begin

Line 4230: l_mrp_database_link := fnd_profile.value(name => 'MRP_ATP_DATABASE_LINK');

4226: OPEN instance;
4227: FETCH instance INTO l_instance_id;
4228: CLOSE instance;
4229: log('do_atp_check', 'l_instance_id: '||l_instance_id);
4230: l_mrp_database_link := fnd_profile.value(name => 'MRP_ATP_DATABASE_LINK');
4231: log('do_atp_check', 'l_mrp_database_link: '||l_mrp_database_link);
4232: If l_mrp_database_link IS NULL Then
4233: Select MRP_ATP_SCHEDULE_TEMP_S.NextVal
4234: Into l_session_id

Line 4265: l_ship_complete_profile := fnd_profile.value(name => 'CSP_SHIP_COMPLETE');

4261: l_atp_rec.Requested_Ship_Date(I) := sysdate ; --'03-MAY-2002' ;
4262: l_atp_rec.Organization_id(I) := p_unavailable_list(I).organization_id;
4263: l_atp_rec.Identifier(I):= p_unavailable_list(I).resource_id + I ;
4264: l_atp_rec.Scenario_Id(I) := 1;
4265: l_ship_complete_profile := fnd_profile.value(name => 'CSP_SHIP_COMPLETE');
4266: IF l_ship_complete_profile ='Y' THEN
4267: IF g_schedular_call = 'Y' THEN
4268: l_atp_rec.ship_set_name(I) := to_char(p_unavailable_list(I).resource_id);
4269: ELSE

Line 4300: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');

4296: log('do_atp_check', 'begin l_atp_rec_out.Inventory_Item_Id loop. count: '||l_atp_rec_out.Inventory_Item_Id.count);
4297: FOR I IN 1..l_atp_rec_out.Inventory_Item_Id.count LOOP
4298: log('do_atp_check', 'l_atp_rec_out.Error_Code('||I||'): '||l_atp_rec_out.Error_Code(I));
4299: IF (l_atp_rec_out.Error_Code(I) <> 0 and l_atp_rec_out.Error_Code(I) <> 150 ) THEN
4300: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');
4301: log('do_atp_check', 'l_assignment_set_id: '||l_assignment_set_id);
4302: OPEN check_buy_from(l_atp_rec.Inventory_Item_Id(I),l_assignment_set_id, l_atp_rec.Organization_id(I));
4303: FETCH check_buy_from INTO l_buy_from;
4304: CLOSE check_buy_from;

Line 5383: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');

5379: l_ship_method_present_for_reg boolean :=false;
5380: BEGIN
5381: l_server_sys_date := sysdate;
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
5384: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
5385:
5386: IF g_interval.latest_time IS NOT NULL
5387: THEN

Line 5384: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

5380: BEGIN
5381: l_server_sys_date := sysdate;
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
5384: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
5385:
5386: IF g_interval.latest_time IS NOT NULL
5387: THEN
5388: l_need_by_date := g_interval.latest_time;

Line 5675: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');

5671: l_default_unit_for_hour varchar2(3);
5672: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_DELIVERY_DATE' ;
5673: BEGIN
5674: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5675: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
5676: OPEN C1(p_relation_ship_id);
5677: LOOP
5678: FETCH C1 INTO l_lead_time,l_lead_time_uom,l_delivery_time,l_cutoff_time, l_timezone_id, l_saftey_zone;
5679: EXIT WHEN C1%NOTFOUND;

Line 6057: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

6053: l_shipping_methode varchar2(30);
6054: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_SHIPPING_METHODE' ;
6055: BEGIN
6056: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6057: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
6058: OPEN C3(p_from_org_id,p_to_org_id);
6059: LOOP
6060: FETCH C3 INTO l_cost,l_relation_ship_id ,l_cutoff_time,l_timezone_id,l_shipping_methode ;
6061: EXIT WHEN C3%NOTFOUND;

Line 6467: log('check_parts_availability', 'profile CSP_INCL_ALTERNATES value: '||fnd_profile.value(name => 'CSP_INCL_ALTERNATES'));

6463: END LOOP;
6464: log('check_parts_availability', 'begin p_parts_list loop again. count: '||p_parts_list.count);
6465: FOR I IN 1..p_parts_list.count
6466: LOOP
6467: log('check_parts_availability', 'profile CSP_INCL_ALTERNATES value: '||fnd_profile.value(name => 'CSP_INCL_ALTERNATES'));
6468: if p_include_alternates is not null then
6469: l_check_alternates := p_include_alternates;
6470: else
6471: l_check_alternates := fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY';

Line 6471: l_check_alternates := fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY';

6467: log('check_parts_availability', 'profile CSP_INCL_ALTERNATES value: '||fnd_profile.value(name => 'CSP_INCL_ALTERNATES'));
6468: if p_include_alternates is not null then
6469: l_check_alternates := p_include_alternates;
6470: else
6471: l_check_alternates := fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY';
6472: end if;
6473: IF l_check_alternates THEN
6474: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id ,p_organization_id => l_temp_org_id ,x_supersede_items => l_supersede_items);
6475: log('check_parts_availability', 'begin l_supersede_items loop. l_supersede_items count: '||l_supersede_items.count);

Line 6629: log('check_parts_availability', 'profile CSP_CHECK_ATP value: '||fnd_profile.value(name => 'CSP_CHECK_ATP'));

6625: LOOP
6626: log('check_parts_availability', 'l_res_ids('||i||'): '||l_res_ids(i));
6627: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
6628: END LOOP;
6629: log('check_parts_availability', 'profile CSP_CHECK_ATP value: '||fnd_profile.value(name => 'CSP_CHECK_ATP'));
6630: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN
6631: log('check_parts_availability', 'l_unavailable_list count: '||l_unavailable_list.count);
6632: IF l_unavailable_list.count >=1 THEN
6633: log('check_parts_availability', 'calling csp_sch_int_pvt.do_atp_check');

Line 6630: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN

6626: log('check_parts_availability', 'l_res_ids('||i||'): '||l_res_ids(i));
6627: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
6628: END LOOP;
6629: log('check_parts_availability', 'profile CSP_CHECK_ATP value: '||fnd_profile.value(name => 'CSP_CHECK_ATP'));
6630: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN
6631: log('check_parts_availability', 'l_unavailable_list count: '||l_unavailable_list.count);
6632: IF l_unavailable_list.count >=1 THEN
6633: log('check_parts_availability', 'calling csp_sch_int_pvt.do_atp_check');
6634: csp_sch_int_pvt.do_atp_check(l_unavailable_list,l_interval,l_available_list,l_final_unavailable_list,l_return_status,x_msg_data,x_msg_count);

Line 6842: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'PRONLY' THEN

6838: END IF;
6839: ELSE
6840: x_availability(loop_count).source_type := 'RES' ;
6841: END IF;
6842: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'PRONLY' THEN
6843: IF NOT quantity_fullfilled THEN
6844: IF l_required_quantity > l_final_available_list(k).available_quantity THEN
6845: x_availability(loop_count).recommended_option := 'Y';
6846: quantity_fullfilled := FALSE;

Line 6941: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');

6937: loop_count := loop_count + 1;
6938: END IF;
6939: END LOOP;
6940: IF NOT quantity_fullfilled THEN
6941: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');
6942: log('check_parts_availability', 'l_assignment_set_id: '||l_assignment_set_id);
6943: OPEN check_buy_from(p_parts_list(I).item_id, l_assignment_set_id,l_temp_org_id);
6944: LOOP
6945: FETCH check_buy_from INTO l_vendor_id, l_vendor_site_id;

Line 7972: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

7968: where ORGANIZATION_ID = c_org_id
7969: and SHIPPING_METHOD = c_ship_method_code;
7970:
7971: BEGIN
7972: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
7973: OPEN csp_resource_calendar;
7974: FETCH csp_resource_calendar INTO l_calendar_code,l_exception_set_id ;
7975: CLOSE csp_resource_calendar;
7976: IF l_calendar_code is null then