[Home] [Help]
PACKAGE: APPS.MSC_SUPPLIER_PWB
Source
1 package msc_supplier_pwb as
2 /* $Header: MSCFNSCS.pls 120.0 2005/05/25 18:45:41 appldev noship $ */
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 /*---------------------Enhancement for LA by :Satyagi---------*/
46 g_liability_grp boolean;
47 /*----------------------Enhancement for LA by :Satyagi---------*/
48 --Function Names
49
50 --1.Exceptions - Actions, Exception Details, Related Exceptions,Save Actions
51 --2.Resources - Resources, Resource Requirements, Resource Availability,
52 --3.Supplier - Supplier capacity, Supplier Flex fences, Supplier variability
53 --4.Operations - Routing Operations, Operation Networks
54 --5.Key Indicators 6.Pegging 7.HzPlan 8.Vert Plan 9.GC 10.SCBill 11.Items 12.Components
55 --13.Where Used 14.Sourcing 15.Destination 16.ProcEff 17.Coprod 18.SS 19.PSub
56 --20.Replan - Start ,Stop ,Online Replan,Status,Batch Replan,Launch,Copy,Purge Plan.
57 --21a.View Notifications 21b. Launch notifications
58 --22.Options - Plan Options
59 --23a.Release - Select All for Release, Release
60 --23b.collaboration - publish order forecast, supply commits
61 --24.Pref
62 --25.Undo 26.PCR
63 --27.PDR. not used
64 --28.supply/demand
65 /*---------------------Enhancement for LA by :Satyagi---------*/
66 --29.Liability
67 /*----------------------Enhancement for LA by :Satyagi---------*/
68 g_excp_fn NUMBER := 2 ;
69 g_res_fn NUMBER := 2 ;
70 g_supp_fn NUMBER := 2 ;
71 g_oper_fn NUMBER := 2 ;
72 g_kpi_fn NUMBER := 2 ;
73 g_peg_fn NUMBER := 2 ;
74 g_hz_fn NUMBER := 2 ;
75 g_vert_fn NUMBER := 2 ;
76 g_gc_fn NUMBER := 2 ;
77 g_bill_fn NUMBER := 2 ;
78 g_item_fn NUMBER := 2 ;
79 g_comp_fn NUMBER := 2 ;
80 g_used_fn NUMBER := 2 ;
81 g_sour_fn NUMBER := 2 ;
82 g_dest_fn NUMBER := 2 ;
83 g_peff_fn NUMBER := 2 ;
84 g_coprod_fn NUMBER := 2 ;
85 g_ss_fn NUMBER := 2 ;
86 g_psub_fn NUMBER := 2 ;
87 g_replan_fn NUMBER := 2 ;
88 g_21a_fn NUMBER := 2 ;
89 g_21b_fn NUMBER := 2 ;
90 g_option_fn NUMBER := 2 ;
91 g_23a_fn NUMBER := 2 ;
92 g_23b_fn NUMBER := 2 ;
93 g_pref_fn NUMBER := 2 ;
94 g_undo_fn NUMBER := 2 ;
95 --g_pdr_fn NUMBER := 2 ;
96 g_pcr_fn NUMBER := 2 ;
97 g_28_fn NUMBER := 2 ;
98 g_29_fn NUMBER := 2 ;
99 g_30_fn NUMBER := 2 ;
100 g_cal_fn NUMBER := 2 ;
101 g_invlv_fn NUMBER := 2 ;
102 g_res_batch_fn NUMBER := 2 ;
103 /*---------------------Enhancement for LA by :Satyagi---------*/
104 g_liability_fn NUMBER := 2 ;
105 /*----------------------Enhancement for LA by :Satyagi---------*/
106
107 --fnd-function context
108 g_resp_app varchar2(20) := g_resp_app_name ;
109 g_resp_key varchar2(100) := g_resp_key_name ;
110 g_secgrp_key varchar2(100) := g_secgrp_key_name ;
111 g_func varchar2(100) := g_func_name ;
112
113 --aps context
114 g_org_id number;
115 g_inst_id number;
116 g_partner_type number;
117 g_supplier_id number;
118 g_supp_site_id number;
119
120 procedure invoke_mscfnscwb( p_resp_app in varchar2,
121 p_resp_key in varchar2,
122 p_secgrp_key in varchar2,
123 p_err_msg out nocopy varchar2,
124 p_url out nocopy varchar2);
125
126 procedure launch_supplier_pwb(p_unique_id in varchar2,
127 p_user_id in number,
128 p_supplier_id in number,
129 p_supplier_site_id in number,
130 p_err_msg out nocopy varchar2,
131 p_url out nocopy varchar2 );
132
133 procedure enable_fn_sec;
134
135 function get_fn_status(p_fn_name in varchar2) return NUMBER ;
136
137 --procedure enable_disable_fn_sec(p_enable boolean default false);
138
139 FUNCTION modelled_as_org return boolean ;
140 FUNCTION modelled_as_supplier return number;
141 FUNCTION check_supplier_plans (p_supplier_id number) return boolean ;
142
143 end msc_supplier_pwb ;