[Home] [Help]
PACKAGE: APPS.MSC_ATP_CTO
Source
1 PACKAGE MSC_ATP_CTO AUTHID CURRENT_USER AS
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
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(),
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(),
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;
35 G_INCLUDED_ITEM_IS_PRESENT NUMBER := 2;
36
37 G_MODEL_BOM_IS_COLLECTED NUMBER := 2;
38
39 SUCCESS CONSTANT NUMBER := 1;
40 FAIL CONSTANT NUMBER := 2;
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
50 );
51
52 Procedure Match_CTO_Lines(P_session_id IN Number,
53 p_dblink IN VARCHAR2,
54 p_instance_id IN number,
55 x_return_status OUT NOCOPY VARCHAR2);
56
57 Procedure Process_CTO_Sources(p_dblink IN varchar2,
58 p_session_id IN number,
59 p_cto_sources CTO_OSS_SOURCE_PK.OSS_ORGS_LIST_REC_TYPE,
60 p_instance_id IN NUMBER);
61
62 Procedure Get_Mandatory_Components(p_plan_id IN NUMBER,
63 p_instance_id IN NUMBER,
64 p_organization_id IN NUMBER,
65 p_sr_inventory_item_id IN NUMBER,
66 p_quantity IN NUMBER,
67 p_request_date IN DATE,
68 p_dest_inv_item_id IN NUMBER,
69 x_mand_comp_info_rec OUT NOCOPY MSC_ATP_CTO.mand_comp_info_rec
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
79 Procedure Extend_Sources_Rec(P_Source_Rec IN OUT NOCOPY MRP_ATP_PVT.Atp_Source_Typ);
80
81 procedure Populate_Cto_Bom(p_session_id IN number,
82 p_refresh_number IN number,
83 p_dblink IN varchar2);
84
85 Procedure Get_CTO_BOM(p_session_id IN NUMBER,
86 p_comp_rec OUT NOCOPY MRP_ATP_PVT.Atp_Comp_Typ,
87 p_line_id IN NUMBER,
88 p_request_date IN DATE,
89 p_request_quantity IN NUMBER,
90 p_parent_so_quantity IN NUMBER,
91 p_inventory_item_id IN NUMBER,
92 p_organization_id IN NUMBER,
93 p_plan_id IN NUMBER,
94 p_instance_id IN NUMBER,
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,
104 p_base_model_id IN NUMBER,
105 p_request_date IN DATE,
106 p_instance_id IN NUMBER,
107 p_plan_id IN NUMBER,
108 p_organization_id IN NUMBER,
109 p_quantity IN NUMBER,
110 x_model_sr_inv_id OUT NOCOPY NUMBER,
111 x_check_model_capacity_flag OUT NOCOPY NUMBER);
112
113 END MSC_ATP_CTO;
114
115
116