1 Package Wip_Flow_Derive AUTHID CURRENT_USER as
2 /* $Header: wipwodfs.pls 115.10 2004/07/28 10:42:01 panagara ship $ */
3
4 /* *********************************************************************
5 Public Functions
6 ***********************************************************************/
7
8 /* Defaulting the Flow related information for the form in one DB hit */
9 function Flow_Form_Defaulting(
10 p_txn_action_id IN NUMBER, -- CFM Scrap
11 p_txn_type_id in number,
12 p_item_id in number,
13 p_org_id in number,
14 p_start_date in date,
15 p_alt_rtg_des in varchar2,
16 p_bom_rev in out NOCOPY varchar2,
17 p_rev in out NOCOPY varchar2,
18 p_bom_rev_date in out NOCOPY date,
19 p_rout_rev in out NOCOPY varchar2,
20 p_rout_rev_date in out NOCOPY date,
21 p_comp_sub in out NOCOPY varchar2,
22 p_comp_loc in out NOCOPY number,
23 p_proj_id in number,
24 p_task_id in number) return number;
25
26
27 /* Default the Class Code */
28 function class_code( p_class_code in out NOCOPY varchar2,
29 p_err_mesg in out NOCOPY varchar2,
30 p_org_id in number,
31 p_item_id in number,
32 p_wip_entity_type in number,
33 p_project_id in number) return number;
34
35 /* Default the Bill Revision and date */
36 function bom_revision( p_bom_rev in out NOCOPY varchar2,
37 p_rev in out NOCOPY varchar2,
38 p_bom_rev_date in out NOCOPY date,
39 p_item_id in number,
40 p_start_date in date,
41 p_Org_id in number) return number;
42
43 /* Default the Routing Revision and date */
44 function routing_revision( p_rout_rev in out NOCOPY varchar2,
45 p_rout_rev_date in out NOCOPY date,
46 p_item_id in number,
47 p_start_date in date,
48 p_Org_id in number) return number ;
49
50
51 /* Defaulting Completion Subinventory */
52 function completion_sub(p_comp_sub in out NOCOPY varchar2,
53 p_item_id in number,
54 p_org_id in number,
55 p_alt_rtg_des in varchar2) return number ;
56
57
58 /* Defaulting Routing Completion Locator Id */
59 function routing_completion_sub_loc(
60 p_rout_comp_sub in out NOCOPY varchar2,
61 p_rout_comp_loc in out NOCOPY number,
62 p_item_id in number,
63 p_org_id in number,
64 p_alt_rtg_des in varchar2) return number;
65
66 /* Defaulting completion locator id. In completion_loc, we only default locator id from
67 the routing if p_proj_id is not null. I don't think we need that restriction. Also,
68 p_txn_int_id is unneccessary. INV validation should derive the locator id from the
69 segments provided. We only need to check the existence of locator id */
70 function completion_locator_id(p_comp_loc in out NOCOPY number,
71 p_item_id in number,
72 p_org_id in number,
73 p_alt_rtg_des in varchar2,
74 p_proj_id in number,
75 p_task_id in number,
76 p_comp_sub in varchar2) return number;
77
78 /* Defaulting Completion Locator Id */
79 function completion_loc(p_comp_loc in out NOCOPY number,
80 p_item_id in number,
81 p_org_id in number,
82 p_alt_rtg_des in varchar2,
83 p_proj_id in number,
84 p_task_id in number,
85 p_comp_sub in varchar2,
86 p_txn_int_id in number default null) return number;
87
88
89 /* Defaulting Schedule Group Id nedded for R11+, right now it is stubbed */
90 function schedule_group_id(p_sched_grp_id in out NOCOPY number) return number ;
91
92
93 /* Defaulting Build Sequence Valid -- nedded for R11+, right now it is stubbed */
94 function build_sequence(p_build_seq in out NOCOPY number) return number;
95
96 /* Defaulting Project Id valid -- this makes sure both the values are the same */
97 function src_project_id(p_src_proj_id in out NOCOPY number,
98 p_proj_id in out NOCOPY number) return number;
99
100
101 /* Defaulting the Task Id valid -- this makes sure both the values are the same */
102 function src_task_id(p_src_task_id in out NOCOPY number,
103 p_task_id in out NOCOPY number) return number ;
104
105 /* Defaulting the schedule number*/
106 function schedule_number(p_sched_num in out NOCOPY varchar2) return number ;
107
108
109 /*Defaulting the Last Updated Id */
110 function Last_Updated_ID( p_last_up_by_name in out NOCOPY varchar2,
111 p_last_up_id in out NOCOPY number) return number;
112
113 /*Defauting the Created By ID */
114 function Created_By_ID( p_created_by_name in out NOCOPY varchar2,
115 p_created_id in out NOCOPY number) return number;
116
117 /* Defaulting the Organization ID */
118 function Organization_Code(p_org_name in out NOCOPY varchar2,
119 p_org_id in out NOCOPY number) return number;
120
121 /* Defaulting the Transaction source name */
122 function Transaction_Source_Name(
123 p_txn_src_name in out NOCOPY varchar2,
124 p_txn_src_id in out NOCOPY number,
125 p_org_id in number) return number ;
126
127
128 /* Defaulting the information for a scheduled flow schedule */
129 function Scheduled_Flow_Derivation(
130 p_txn_action_id IN NUMBER,-- CFM Scrap
131 p_item_id in number,
132 p_org_id in number,
133 p_txn_src_id in number,
134 p_sched_num in out NOCOPY varchar2,
135 p_src_proj_id in out NOCOPY number,
136 p_proj_id in out NOCOPY number,
137 p_src_task_id in out NOCOPY number,
138 p_task_id in out NOCOPY number,
139 p_bom_rev in out NOCOPY varchar2,
140 p_rev in out NOCOPY varchar2,
141 p_bom_rev_date in out NOCOPY date,
142 p_rout_rev in out NOCOPY varchar2,
143 p_rout_rev_date in out NOCOPY date,
144 p_comp_sub in out NOCOPY varchar2,
145 p_class_code in out NOCOPY varchar2,
146 p_wip_entity_type in out NOCOPY number,
147 p_comp_loc in out NOCOPY number,
148 p_alt_rtg_des in out NOCOPY varchar2,
149 p_alt_bom_des in out NOCOPY varchar2) return number;
150
152 End Wip_Flow_Derive ;
151