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

Line 6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

2: /* $Header: MSCCTOPS.pls 120.3 2007/12/12 10:24:35 sbnaik ship $ */
3:
4:
5: TYPE mand_comp_info_rec is RECORD (
6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp

Line 7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

3:
4:
5: TYPE mand_comp_info_rec is RECORD (
6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),

4:
5: TYPE mand_comp_info_rec is RECORD (
6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),

5: TYPE mand_comp_info_rec is RECORD (
6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp

6: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

7: quantity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

Line 12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

8: atp_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421

Line 13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

9: atp_components_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

10: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),-- For time_phased_atp
11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

11: bom_item_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: fixed_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

13: variable_lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421

Line 18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

14: dest_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920

Line 19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

15: uom_code MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920

Line 20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

16: --4570421
17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
24: );

Line 21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421

17: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
24: );
25:

Line 22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920

18: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
24: );
25:
26: TYPE Item_Sourcing_Info_Rec is RECORD (

Line 23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920

19: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
20: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
21: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
22: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
24: );
25:
26: TYPE Item_Sourcing_Info_Rec is RECORD (
27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

23: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
24: );
25:
26: TYPE Item_Sourcing_Info_Rec is RECORD (
27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: ato_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: match_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr());
31:

Line 28: line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

24: );
25:
26: TYPE Item_Sourcing_Info_Rec is RECORD (
27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: ato_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: match_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr());
31:
32: G_MODEL_QUNATITY NUMBER;

Line 29: ato_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

25:
26: TYPE Item_Sourcing_Info_Rec is RECORD (
27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: ato_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: match_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr());
31:
32: G_MODEL_QUNATITY NUMBER;
33: G_MODEL_IS_PRESENT NUMBER := 2;

Line 30: match_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr());

26: TYPE Item_Sourcing_Info_Rec is RECORD (
27: sr_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
28: line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
29: ato_line_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
30: match_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr());
31:
32: G_MODEL_QUNATITY NUMBER;
33: G_MODEL_IS_PRESENT NUMBER := 2;
34: G_MODEL_IS_PRESENT_IN_SET NUMBER := 2;

Line 45: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

41:
42:
43:
44: PROCEDURE Check_Lines_For_CTO_ATP (
45: p_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
46: p_session_id IN number,
47: p_dblink IN varchar2,
48: p_instance_id IN number,
49: x_return_status OUT NoCopy VARCHAR2

Line 74: p_line_ids IN MRP_ATP_PUB.number_arr,

70: );
71:
72:
73: Procedure Validate_CTO_Sources (P_SOURCE_LIST IN OUT NOCOPY MRP_ATP_PVT.Atp_Source_Typ,
74: p_line_ids IN MRP_ATP_PUB.number_arr,
75: p_instance_id IN number,
76: p_session_id IN number,
77: x_return_status OUT NOCOPY varchar2);
78:

Line 99: p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

95: p_fixed_lt IN NUMBER,
96: p_variable_lt IN NUMBER);
97:
98: Procedure Maintain_OS_Sourcing(p_instance_id IN Number,
99: p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
100: p_status IN Number);
101:
102:
103: PROCEDURE Check_Base_Model_For_Cap_Check(p_config_inventory_item_id IN NUMBER,