1 PACKAGE pjm_task_auto_assign AS
2 /* $Header: PJMTKASS.pls 120.0.12010000.1 2008/07/30 04:24:40 appldev ship $ */
3
4 --
5 -- Name : Inv_Task_WNPS
6 --
7 -- Function : This function returns a task based on predefined
8 -- rules and is specially designed for using in
9 -- views.
10 --
11 -- Parameters :
12 -- IN : X_org_id NUMBER
13 -- : X_project_id NUMBER
14 -- : X_item_id NUMBER
15 -- : X_po_header_id NUMBER
16 -- : X_category_id NUMBER
17 -- : X_subinv_code VARCHAR2
18 --
19 FUNCTION Inv_Task_WNPS ( X_org_id IN NUMBER
20 , X_project_id IN NUMBER
21 , X_item_id IN NUMBER
22 , X_po_header_id IN NUMBER
23 , X_category_id IN NUMBER
24 , X_subinv_code IN VARCHAR2 )
25 RETURN NUMBER;
26 PRAGMA RESTRICT_REFERENCES (Inv_Task_WNPS, WNDS, WNPS);
27
28 --
29 -- Name : Wip_Task_WNPS
30 --
31 -- Function : This function returns a task based on predefined
32 -- rules and is specially designed for using in
33 -- views.
34 --
35 -- Parameters :
36 -- IN : X_org_id NUMBER
37 -- : X_project_id NUMBER
38 -- : X_operation_id NUMBER
39 -- : X_wip_entity_id NUMBER
40 -- : X_assy_item_id NUMBER
41 -- : X_dept_id NUMBER
42 --
43 FUNCTION Wip_Task_WNPS ( X_org_id IN NUMBER
44 , X_project_id IN NUMBER
45 , X_operation_id IN NUMBER
46 , X_wip_entity_id IN NUMBER
47 , X_assy_item_id IN NUMBER
48 , X_dept_id IN NUMBER )
49 RETURN NUMBER;
50 PRAGMA RESTRICT_REFERENCES (Wip_Task_WNPS, WNDS, WNPS);
51
52 -- Name : WipMat_Task_WNPS
53 --
54 -- Function : This function returns a task based on predefined
55 -- rules and is specially designed for using in
56 -- views.
57 --
58 -- Parameters :
59 -- IN : X_org_id NUMBER
60 -- : X_project_id NUMBER
61 -- : X_item_id NUMBER
62 -- : X_category_id NUMBER
63 -- : X_subinv_code VARCHAR2
64 -- : X_wip_entity_id NUMBER
65 -- : X_assy_item_id NUMBER
66 -- : X_operation_id NUMBER
67 -- : X_dept_id NUMBER
68 --
69
70 FUNCTION WipMat_Task_WNPS ( X_org_id IN NUMBER
71 , X_project_id IN NUMBER
72 , X_item_id IN NUMBER
73 , X_category_id IN NUMBER
74 , X_subinv_code IN VARCHAR2
75 , X_wip_matl_txn_type IN VARCHAR2
76 , X_wip_entity_id IN NUMBER
77 , X_assy_item_id IN NUMBER
78 , X_operation_id IN NUMBER
79 , X_dept_id IN NUMBER )
80 RETURN NUMBER;
81 -- PRAGMA RESTRICT_REFERENCES (WipMat_Task_WNPS, WNDS, WNPS);
82
83 -- Name : SCP_Task_WNPS
84 --
85 -- Function : This function returns a task based on predefined
86 -- rules and is specially designed for using in
87 -- views.
88 --
89 -- Parameters :
90 -- IN : X_org_id NUMBER
91 -- : X_project_id NUMBER
92 -- : X_item_id NUMBER
93 -- : X_category_id NUMBER
94 -- : X_to_org_id NUMBER
95 --
96
97 FUNCTION SCP_Task_WNPS ( X_org_id IN NUMBER
98 , X_project_id IN NUMBER
99 , X_item_id IN NUMBER
100 , X_category_id IN NUMBER
101 , X_to_org_id IN NUMBER )
102 RETURN NUMBER;
103 PRAGMA RESTRICT_REFERENCES (SCP_Task_WNPS, WNDS, WNPS);
104
105 --
106 -- Name : Assign_Task_Inv
107 --
108 -- Function : This procedure assigns a task based on predefined
109 -- rules if a material transaction has project
110 -- references but no task references. If assignment
111 -- rule cannot be found, the transaction will be
112 -- flagged as error and Cost Collection will not be
113 -- performed
114 --
115 -- Parameters :
116 -- IN : X_transaction_id NUMBER
117 -- : X_transfer_flag VARCHAR2
118 --
119 -- IN OUT : X_error_num NUMBER
120 -- : X_error_msg VARCHAR2
121 --
122 PROCEDURE assign_task_inv
123 ( X_transaction_id IN NUMBER
124 , X_error_num IN OUT NOCOPY NUMBER
125 , X_error_msg IN OUT NOCOPY VARCHAR2);
126
127 --
128 -- Name : Assign_Task_WIPL
129 --
130 -- Function : This procedure assigns a task based on predefined
131 -- rules if a WIP resource/overhead transaction has
132 -- project references but no task references. If
133 -- assignment rule cannot be found, the transaction
134 -- will beflagged as error and Cost Collection will
135 -- not be performed
136 --
137 -- Parameters :
138 -- IN : X_transaction_id NUMBER
139 --
140 -- IN OUT : X_error_num NUMBER
141 -- : X_error_msg VARCHAR2
142 --
143 PROCEDURE assign_task_wipl
144 ( X_transaction_id IN NUMBER
145 , X_error_num IN OUT NOCOPY NUMBER
146 , X_error_msg IN OUT NOCOPY VARCHAR2);
147
148 END pjm_task_auto_assign;