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.9 2007/12/12 10:24:17 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.9 2007/12/12 10:24:17 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 53: MSC_ATP_CTO.Match_CTO_Lines(p_session_id, p_dblink, p_instance_id, l_return_status);

49: IF PG_DEBUG in ('Y', 'C') THEN
50: msc_sch_wb.atp_debug('***** Call Matching *****');
51: END IF;
52:
53: MSC_ATP_CTO.Match_CTO_Lines(p_session_id, p_dblink, p_instance_id, l_return_status);
54:
55: IF PG_DEBUG in ('Y', 'C') THEN
56: msc_sch_wb.atp_debug('***** l_return_status := ' || l_return_status);
57: msc_sch_wb.atp_debug('*** G_RET_STS_SUCCESS := ' || FND_API.G_RET_STS_SUCCESS);

Line 502: x_mand_comp_info_rec OUT NOCOPY MSC_ATP_CTO.mand_comp_info_rec

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

Line 919: MSC_ATP_CTO.Extend_Sources_Rec(l_match_source_list);

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

Line 1255: IF p_status = MSC_ATP_CTO.Success THEN

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

Line 1263: ELSIF p_status = MSC_ATP_CTO.FAIL THEN

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

Line 1392: END MSC_ATP_CTO;

1388: x_check_model_capacity_flag := 2;
1389:
1390: END Check_Base_Model_For_Cap_Check;
1391:
1392: END MSC_ATP_CTO;