APPS.MSC_ATP_CTO dependencies on MSC_ATP_CTO

Line 1: PACKAGE BODY MSC_ATP_CTO AS

1: PACKAGE BODY MSC_ATP_CTO AS
2: /* $Header: MSCCTOPB.pls 120.12 2011/08/10 07:31:16 sbnaik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_CTO';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_CTO';

1: PACKAGE BODY MSC_ATP_CTO AS
2: /* $Header: MSCCTOPB.pls 120.12 2011/08/10 07:31:16 sbnaik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_CTO';
5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
7:
8: PROCEDURE Check_Lines_For_CTO_ATP (

Line 54: MSC_ATP_CTO.Match_CTO_Lines(p_session_id, p_dblink, p_instance_id, l_return_status);

50: msc_sch_wb.atp_debug('***** Call Matching *****');
51: END IF;
52:
53: --If WebService call then donot call CTO API
54: MSC_ATP_CTO.Match_CTO_Lines(p_session_id, p_dblink, p_instance_id, l_return_status);
55:
56: IF PG_DEBUG in ('Y', 'C') THEN
57: msc_sch_wb.atp_debug('***** l_return_status := ' || l_return_status);
58: msc_sch_wb.atp_debug('*** G_RET_STS_SUCCESS := ' || FND_API.G_RET_STS_SUCCESS);

Line 504: x_mand_comp_info_rec OUT NOCOPY MSC_ATP_CTO.mand_comp_info_rec

500: p_sr_inventory_item_id IN NUMBER,
501: p_quantity IN NUMBER,
502: p_request_date IN DATE,
503: p_dest_inv_item_id IN NUMBER,
504: x_mand_comp_info_rec OUT NOCOPY MSC_ATP_CTO.mand_comp_info_rec
505: )
506:
507: IS
508: l_inventory_item_id number;

Line 922: MSC_ATP_CTO.Extend_Sources_Rec(l_match_source_list);

918: msc_sch_wb.atp_debug('Extend sources array and add org to it');
919: END IF;
920:
921: --a matching source found
922: MSC_ATP_CTO.Extend_Sources_Rec(l_match_source_list);
923:
924: l_count := l_match_source_list.Organization_Id.count;
925:
926: l_match_source_list.Organization_Id(l_count) :=

Line 1258: IF p_status = MSC_ATP_CTO.Success THEN

1254: IS
1255: i number;
1256: BEGIN
1257:
1258: IF p_status = MSC_ATP_CTO.Success THEN
1259: -- delete the old data
1260: FORALL i in 1..p_atp_rec.inventory_item_id.count
1261: Delete from msc_cto_sources
1262: where sr_instance_id = p_instance_id

Line 1266: ELSIF p_status = MSC_ATP_CTO.FAIL THEN

1262: where sr_instance_id = p_instance_id
1263: and ato_line_id = p_atp_rec.identifier(i)
1264: and status_flag = 2;
1265:
1266: ELSIF p_status = MSC_ATP_CTO.FAIL THEN
1267: --first delete the new data
1268: FORALL i in 1..p_atp_rec.inventory_item_id.count
1269: Delete from msc_cto_sources
1270: where sr_instance_id = p_instance_id

Line 1395: END MSC_ATP_CTO;

1391: x_check_model_capacity_flag := 2;
1392:
1393: END Check_Base_Model_For_Cap_Check;
1394:
1395: END MSC_ATP_CTO;