APPS.MSC_BAL_UTILS dependencies on MRP_BAL_UTILS

Line 5: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , extend_amount NUMBER );

1: PACKAGE BODY MSC_BAL_UTILS AS
2: /* $Header: MSCUBALB.pls 120.8 2007/12/14 07:31:47 sbnaik ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
4:
5: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , extend_amount NUMBER );
6: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , trim_amount NUMBER );
7:
8: PROCEDURE populate_temp_table (p_session_id NUMBER,
9: p_order_by VARCHAR2,

Line 6: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , trim_amount NUMBER );

2: /* $Header: MSCUBALB.pls 120.8 2007/12/14 07:31:47 sbnaik ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
4:
5: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , extend_amount NUMBER );
6: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , trim_amount NUMBER );
7:
8: PROCEDURE populate_temp_table (p_session_id NUMBER,
9: p_order_by VARCHAR2,
10: p_where VARCHAR2,

Line 15: l_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;

11: p_overwrite NUMBER,
12: p_org_id NUMBER,
13: p_exclude_picked NUMBER default 0) IS
14: l_stmt VARCHAR2(4000);
15: l_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;
16: filter_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;
17: j NUMBER;
18: TYPE curtype IS REF CURSOR;
19: cv CurType;

Line 16: filter_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;

12: p_org_id NUMBER,
13: p_exclude_picked NUMBER default 0) IS
14: l_stmt VARCHAR2(4000);
15: l_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;
16: filter_mrp_oe_rec mrp_bal_utils.mrp_oe_rec;
17: j NUMBER;
18: TYPE curtype IS REF CURSOR;
19: cv CurType;
20: l_seq NUMBER;

Line 1393: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec, extend_amount NUMBER ) IS

1389: x_msg_data := substr(sqlerrm,1,100);
1390: END execute_command;
1391:
1392:
1393: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec, extend_amount NUMBER ) IS
1394: BEGIN
1395: p_nodes.line_id.extend( extend_amount );
1396: p_nodes.ship_set_id.extend( extend_amount );
1397: p_nodes.arrival_set_id.extend( extend_amount );

Line 1405: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.seq_alter , extend_amount NUMBER ) IS

1401: p_nodes.item_type_code.extend(extend_amount);
1402: p_nodes.order_number.extend(extend_amount);
1403: END extend;
1404:
1405: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.seq_alter , extend_amount NUMBER ) IS
1406: BEGIN
1407: p_nodes.order_line_id.extend( extend_amount );
1408: p_nodes.ship_set_id.extend( extend_amount );
1409: p_nodes.arrival_set_id.extend( extend_amount );

Line 1413: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec, trim_amount NUMBER ) IS

1409: p_nodes.arrival_set_id.extend( extend_amount );
1410: p_nodes.seq_diff.extend( extend_amount );
1411: END extend;
1412:
1413: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec, trim_amount NUMBER ) IS
1414: BEGIN
1415: p_nodes.line_id.trim( trim_amount );
1416: p_nodes.ship_set_id.trim( trim_amount );
1417: p_nodes.arrival_set_id.trim( trim_amount );

Line 1656: p_seq_alter IN OUT NoCopy mrp_bal_utils.seq_alter,

1652: END IF;
1653: END call_oe_api;
1654:
1655: PROCEDURE update_seq(p_session_id NUMBER,
1656: p_seq_alter IN OUT NoCopy mrp_bal_utils.seq_alter,
1657: x_msg_count OUT NoCopy NUMBER,
1658: x_msg_data OUT NoCopy VARCHAR2,
1659: x_return_status OUT NoCopy VARCHAR2)
1660: IS

Line 1671: record_firm_filter mrp_bal_utils.seq_alter;

1667: l_stmt VARCHAR2(2000);
1668: cv CurType;
1669: a NUMBER;
1670: l_num_rec NUMBER;
1671: record_firm_filter mrp_bal_utils.seq_alter;
1672: my_count NUMBER;
1673:
1674: BEGIN
1675: delete from mrp_atp_schedule_temp