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_ATP_PUB dependencies on MRP_ATP_PUB

Line 10: G_ATP_BOM_REC MRP_ATP_PUB.ATP_BOM_Rec_Typ;

6: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP');
7: G_CTO_FLAG NUMBER := 0;
8: G_CALL_ATP number :=2; --4421391, the flag will track whether debug/session is set or not.
9: --G_ATP_CHECK VARCHAR2(1) := 'N'; /* Bug 2249504 */
10: G_ATP_BOM_REC MRP_ATP_PUB.ATP_BOM_Rec_Typ;
11: --G_DB_PROFILE VARCHAR2(128); bug3049003 changed from G_DB_PROFILE to l_a2m_dblink
12:
13: -- This package contains 2 public procedures : Call_ATP and Call_ATP_No_Commit.
14: -- Call_ATP and Call_ATP_No_Commit are almost the same except

Line 25: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

21:
22: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
23:
24: PROCEDURE Check_CTO(
25: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
26: p_session_id IN NUMBER,
27: --p_db_profile IN VARCHAR2,
28: --p_atp_check IN OUT NoCopy VARCHAR2,
29: --x_atp_bom_rec OUT NoCopy MRP_ATP_PUB.ATP_BOM_Rec_Typ,

Line 29: --x_atp_bom_rec OUT NoCopy MRP_ATP_PUB.ATP_BOM_Rec_Typ,

25: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
26: p_session_id IN NUMBER,
27: --p_db_profile IN VARCHAR2,
28: --p_atp_check IN OUT NoCopy VARCHAR2,
29: --x_atp_bom_rec OUT NoCopy MRP_ATP_PUB.ATP_BOM_Rec_Typ,
30: x_return_status OUT NoCopy VARCHAR2,
31: x_msg_count OUT NoCopy NUMBER,
32: x_msg_data OUT NoCopy VARCHAR2 )
33: IS

Line 45: Procedure Update_Custom_Information(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

41: null;
42: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
43: --ROLLBACK;
44: END Check_CTO;
45: Procedure Update_Custom_Information(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
46: p_session_id IN NUMBER
47: )
48: IS
49: i number;

Line 103: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

99: -- transaction and not of ATP autonomous transaction to maintain correct Demand picture.
100:
101: PROCEDURE post_atp_cto(
102: p_session_id IN NUMBER,
103: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
104: x_return_status OUT NoCopy VARCHAR2,
105: x_msg_data OUT NoCopy VARCHAR2,
106: x_msg_count OUT NoCopy NUMBER
107: )

Line 173: Procedure Subst_Workflow(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ)

169: END IF;
170: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
171: END disable_trace; --4421391
172:
173: Procedure Subst_Workflow(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ)
174:
175: IS
176: l_sales_rep VARCHAR2(250);
177: l_customer_contact VARCHAR2(250);

Line 304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

300:
301:
302: PROCEDURE Call_ATP_Commit (
303: p_session_id IN OUT NoCopy NUMBER,
304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

Line 305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

301:
302: PROCEDURE Call_ATP_Commit (
303: p_session_id IN OUT NoCopy NUMBER,
304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
309: x_return_status OUT NoCopy VARCHAR2,

Line 306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

302: PROCEDURE Call_ATP_Commit (
303: p_session_id IN OUT NoCopy NUMBER,
304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
309: x_return_status OUT NoCopy VARCHAR2,
310: x_msg_data OUT NoCopy VARCHAR2,

Line 307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

303: p_session_id IN OUT NoCopy NUMBER,
304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
309: x_return_status OUT NoCopy VARCHAR2,
310: x_msg_data OUT NoCopy VARCHAR2,
311: x_msg_count OUT NoCopy NUMBER

Line 308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

304: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
305: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
306: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
307: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
308: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
309: x_return_status OUT NoCopy VARCHAR2,
310: x_msg_data OUT NoCopy VARCHAR2,
311: x_msg_count OUT NoCopy NUMBER
312: ) IS

Line 464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

460:
461:
462: PROCEDURE Call_ATP (
463: p_session_id IN OUT NoCopy NUMBER,
464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

Line 465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

461:
462: PROCEDURE Call_ATP (
463: p_session_id IN OUT NoCopy NUMBER,
464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
469: x_return_status OUT NoCopy VARCHAR2,

Line 466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

462: PROCEDURE Call_ATP (
463: p_session_id IN OUT NoCopy NUMBER,
464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,

Line 467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

463: p_session_id IN OUT NoCopy NUMBER,
464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER

Line 468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

464: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
465: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
466: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
467: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
468: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
469: x_return_status OUT NoCopy VARCHAR2,
470: x_msg_data OUT NoCopy VARCHAR2,
471: x_msg_count OUT NoCopy NUMBER
472: ) IS

Line 476: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

472: ) IS
473:
474: i PLS_INTEGER;
475: --l_db_profile VARCHAR2(128);
476: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
477:
478: -- Bug 2387242 : krajan
479: -- Variables for SQL trace setup
480: C INTEGER;

Line 877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

873:
874:
875: PROCEDURE Call_ATP_No_Commit (
876: p_session_id IN OUT NoCopy NUMBER,
877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

Line 878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

874:
875: PROCEDURE Call_ATP_No_Commit (
876: p_session_id IN OUT NoCopy NUMBER,
877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
882: x_return_status OUT NoCopy VARCHAR2,

Line 879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

875: PROCEDURE Call_ATP_No_Commit (
876: p_session_id IN OUT NoCopy NUMBER,
877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
882: x_return_status OUT NoCopy VARCHAR2,
883: x_msg_data OUT NoCopy VARCHAR2,

Line 880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

876: p_session_id IN OUT NoCopy NUMBER,
877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
882: x_return_status OUT NoCopy VARCHAR2,
883: x_msg_data OUT NoCopy VARCHAR2,
884: x_msg_count OUT NoCopy NUMBER

Line 881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,

877: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
878: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
879: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
880: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
881: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ,
882: x_return_status OUT NoCopy VARCHAR2,
883: x_msg_data OUT NoCopy VARCHAR2,
884: x_msg_count OUT NoCopy NUMBER
885: ) IS

Line 902: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

898:
899: l_assign_set_id NUMBER;
900: plsql_block VARCHAR2(10000);
901: i PLS_INTEGER;
902: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
903: l_atp_rec_temp MRP_ATP_PUB.ATP_Rec_Typ;
904: l_atp_bom_flag MRP_ATP_PUB.number_arr;
905: l_shipset_stat_rec MRP_ATP_PUB.shipset_status_rec_type;
906:

Line 903: l_atp_rec_temp MRP_ATP_PUB.ATP_Rec_Typ;

899: l_assign_set_id NUMBER;
900: plsql_block VARCHAR2(10000);
901: i PLS_INTEGER;
902: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
903: l_atp_rec_temp MRP_ATP_PUB.ATP_Rec_Typ;
904: l_atp_bom_flag MRP_ATP_PUB.number_arr;
905: l_shipset_stat_rec MRP_ATP_PUB.shipset_status_rec_type;
906:
907: l_source_organization_id NUMBER;

Line 904: l_atp_bom_flag MRP_ATP_PUB.number_arr;

900: plsql_block VARCHAR2(10000);
901: i PLS_INTEGER;
902: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
903: l_atp_rec_temp MRP_ATP_PUB.ATP_Rec_Typ;
904: l_atp_bom_flag MRP_ATP_PUB.number_arr;
905: l_shipset_stat_rec MRP_ATP_PUB.shipset_status_rec_type;
906:
907: l_source_organization_id NUMBER;
908: l_customer_id NUMBER;

Line 905: l_shipset_stat_rec MRP_ATP_PUB.shipset_status_rec_type;

901: i PLS_INTEGER;
902: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
903: l_atp_rec_temp MRP_ATP_PUB.ATP_Rec_Typ;
904: l_atp_bom_flag MRP_ATP_PUB.number_arr;
905: l_shipset_stat_rec MRP_ATP_PUB.shipset_status_rec_type;
906:
907: l_source_organization_id NUMBER;
908: l_customer_id NUMBER;
909: l_to_organization_id NUMBER;

Line 986: l_custom_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

982: L_RETURN_NUM NUMBER;
983: L_MOVE_PAST_DUE_TO_SYSDATE varchar2(1); -- Bug 5584634/5618929
984:
985: --custom_api
986: l_custom_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
987: l_modify_flag number;
988: l_custom_ret_sts varchar2(30);
989: BEGIN
990: --Started change for bug 4421391

Line 2879: l_identifier1 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2875:
2876: IS
2877:
2878: l_end_refresh_number NUMBER := NULL;
2879: l_identifier1 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2880: l_identifier2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2881: l_identifier3 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2882:
2883: BEGIN

Line 2880: l_identifier2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2876: IS
2877:
2878: l_end_refresh_number NUMBER := NULL;
2879: l_identifier1 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2880: l_identifier2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2881: l_identifier3 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2882:
2883: BEGIN
2884: IF PG_DEBUG in ('Y', 'C') THEN

Line 2881: l_identifier3 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2877:
2878: l_end_refresh_number NUMBER := NULL;
2879: l_identifier1 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2880: l_identifier2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2881: l_identifier3 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2882:
2883: BEGIN
2884: IF PG_DEBUG in ('Y', 'C') THEN
2885: msc_sch_wb.atp_debug('Inside Procedure UPDATE_TABLES');