[Home] [Help]
PACKAGE: APPS.MSC_SUPPLIER_PWB
Source
1 package msc_supplier_pwb AUTHID CURRENT_USER as
2 /* $Header: MSCFNSCS.pls 120.0.12020000.3 2013/05/07 06:24:47 snilagir ship $ */
3
4 --global constants
5 g_resp_app_name CONSTANT varchar2(20) := 'MSC';
6 g_resp_key_name CONSTANT varchar2(100) := 'MSC_ADV_SUPPLY_CHAIN_SUPPLIER';
7 g_secgrp_key_name CONSTANT varchar2(100) := 'STANDARD';
8 g_func_name CONSTANT varchar2(100) := 'MSCFNSCW-VSPWB';
9
10 --Function Groups
11 --1. Items : 11,19
12 --2. Resources : 2
13 --3. Supplier : 3
14 --4. Supply Chain :10,14,15
15 --5. Plan Output : 1,7,8,28m26,18,21A
16 --6. Gantt Chart : 9
17 --7. Kpis : 5
18 --8. Pegging : 6
19 --9. Execute Plan : 23,21B
20 --10. Replan : 20
21 --11. CP : 23B
22 --12. Undo : 25
23 --13. Plan Settings 22,24
24 --14. Bom/Routings 12,13,17,4,16
25 --15. Resource Batches
26 /*---------------------Enhancement for LA by :Satyagi---------*/
27 --16. Liability
28 /*----------------------Enhancement for LA by :Satyagi---------*/
29 g_item_grp boolean;
30 g_res_grp boolean;
31 g_sup_grp boolean;
32 g_schain_grp boolean;
33 g_plan_grp boolean;
34 g_gc_grp boolean;
35 g_kpi_grp boolean;
36 g_peg_grp boolean;
37 g_exepln_grp boolean;
38 g_replan_grp boolean;
39 g_cp_grp boolean;
40 g_undo_grp boolean;
41 g_opt_grp boolean;
42 g_bom_grp boolean;
43 g_invlv_grp boolean;
44 g_res_batch_grp boolean;
45 g_new_res_plan_grp boolean ;
46 g_new_mat_plan_grp boolean ;
47 g_imm_grp boolean ;
48 g_orders_grp boolean ;
49
50 /*---------------------Enhancement for LA by :Satyagi---------*/
51 g_liability_grp boolean;
52 /*----------------------Enhancement for LA by :Satyagi---------*/
53 --Function Names
54
55 --1.Exceptions - Actions, Exception Details, Related Exceptions,Save Actions
56 --2.Resources - Resources, Resource Requirements, Resource Availability,
57 --3.Supplier - Supplier capacity, Supplier Flex fences, Supplier variability
58 --4.Operations - Routing Operations, Operation Networks
59 --5.Key Indicators 6.Pegging 7.HzPlan 8.Vert Plan 9.GC 10.SCBill 11.Items 12.Components
60 --13.Where Used 14.Sourcing 15.Destination 16.ProcEff 17.Coprod 18.SS 19.PSub
61 --20.Replan - Start ,Stop ,Online Replan,Status,Batch Replan,Launch,Copy,Purge Plan.
62 --21a.View Notifications 21b. Launch notifications
63 --22.Options - Plan Options
64 --23a.Release - Select All for Release, Release
65 --23b.collaboration - publish order forecast, supply commits
66 --24.Pref
67 --25.Undo 26.PCR
68 --27.PDR. not used
69 --28.supply/demand
70 /*---------------------Enhancement for LA by :Satyagi---------*/
71 --29.Liability
72 /*----------------------Enhancement for LA by :Satyagi---------*/
73 g_excp_fn NUMBER := 2 ;
74 g_res_fn NUMBER := 2 ;
75 g_supp_fn NUMBER := 2 ;
76 g_oper_fn NUMBER := 2 ;
77 g_kpi_fn NUMBER := 2 ;
78 g_peg_fn NUMBER := 2 ;
79 g_hz_fn NUMBER := 2 ;
80 g_vert_fn NUMBER := 2 ;
81 g_gc_fn NUMBER := 2 ;
82 g_bill_fn NUMBER := 2 ;
83 g_item_fn NUMBER := 2 ;
84 g_comp_fn NUMBER := 2 ;
85 g_used_fn NUMBER := 2 ;
86 g_sour_fn NUMBER := 2 ;
87 g_dest_fn NUMBER := 2 ;
88 g_peff_fn NUMBER := 2 ;
89 g_coprod_fn NUMBER := 2 ;
90 g_ss_fn NUMBER := 2 ;
91 g_psub_fn NUMBER := 2 ;
92 g_replan_fn NUMBER := 2 ;
93 g_21a_fn NUMBER := 2 ;
94 g_21b_fn NUMBER := 2 ;
95 g_option_fn NUMBER := 2 ;
96 g_23a_fn NUMBER := 2 ;
97 g_23b_fn NUMBER := 2 ;
98 g_pref_fn NUMBER := 2 ;
99 g_undo_fn NUMBER := 2 ;
100 --g_pdr_fn NUMBER := 2 ;
101 g_pcr_fn NUMBER := 2 ;
102 g_28_fn NUMBER := 2 ;
103 g_29_fn NUMBER := 2 ;
104 g_30_fn NUMBER := 2 ;
105 g_cal_fn NUMBER := 2 ;
106 g_invlv_fn NUMBER := 2 ;
107 g_res_batch_fn NUMBER := 2 ;
108 /*---------------------Enhancement for LA by :Satyagi---------*/
109 g_liability_fn NUMBER := 2 ;
110 /*----------------------Enhancement for LA by :Satyagi---------*/
111 g_new_res_plan_fn NUMBER := 2 ;
112 g_new_mat_plan_fn NUMBER := 2 ;
113 g_imm_fn NUMBER := 2 ;
114 g_orders_fn NUMBER := 2 ;
115 --fnd-function context
116 g_resp_app varchar2(20) := g_resp_app_name ;
117 g_resp_key varchar2(100) := g_resp_key_name ;
118 g_secgrp_key varchar2(100) := g_secgrp_key_name ;
119 g_func varchar2(100) := g_func_name ;
120
121 --aps context
122 g_org_id number;
123 g_inst_id number;
124 g_partner_type number;
125 g_supplier_id number;
126 g_supp_site_id number;
127
128 procedure invoke_mscfnscwb( p_resp_app in varchar2,
129 p_resp_key in varchar2,
130 p_secgrp_key in varchar2,
131 p_err_msg out nocopy varchar2,
132 p_url out nocopy varchar2);
133
134 procedure launch_supplier_pwb(p_unique_id in varchar2,
135 p_user_id in number,
136 p_supplier_id in number,
137 p_supplier_site_id in number,
138 p_err_msg out nocopy varchar2,
139 p_url out nocopy varchar2 );
140
141 procedure enable_fn_sec;
142
143 function get_fn_status(p_fn_name in varchar2) return NUMBER ;
144
145 --procedure enable_disable_fn_sec(p_enable boolean default false);
146
147 FUNCTION modelled_as_org return boolean ;
148 FUNCTION modelled_as_supplier return number;
149 FUNCTION check_supplier_plans (p_supplier_id number) return boolean ;
150
151 end msc_supplier_pwb ;