1 PACKAGE wip_osp_shp_i_wf AS
2 /*$Header: wiposhis.pls 120.0.12000000.1 2007/01/18 22:19:27 appldev ship $ */
3
4 PROCEDURE SetStartupWFAttributes
5 ( p_itemtype in varchar2 default null
6 , p_itemkey in varchar2
7 , p_wip_entity_id in number
8 , p_rep_sched_id in number
9 , p_organization_id in number
10 , p_primary_qty in number
11 , p_primary_uom in varchar2
12 , p_op_seq_num in number
13 , p_user_id in number
14 , p_resp_id in number
15 , p_resp_appl_id in number
16 , p_security_group_id in number);
17
18 PROCEDURE startWFProcess ( p_itemtype in varchar2
19 , p_itemkey in out nocopy varchar2
20 , p_workflow_process in varchar2
21 , p_wip_entity_id in number
22 , p_rep_sched_id in number
23 , p_organization_id in number
24 , p_primary_qty in number
25 , p_primary_uom in varchar2
26 , p_op_seq_num in number);
27
28 PROCEDURE GetStartupWFAttributes
29 ( p_itemtype in varchar2 default null
30 , p_itemkey in varchar2
31 , p_wip_entity_id out nocopy number
32 , p_rep_sched_id out nocopy number
33 , p_organization_id out nocopy number
34 , p_primary_qty out nocopy number
35 , p_primary_uom out nocopy varchar2
36 , p_osp_operation out nocopy number
37 , p_user_id out nocopy number
38 , p_resp_id out nocopy number
39 , p_resp_appl_id out nocopy number
40 , p_security_group_id out nocopy number);
41
42 PROCEDURE GetReqImport
43 ( itemtype in varchar2
44 , itemkey in varchar2
45 , actid in number
46 , funcmode in varchar2
47 , resultout out nocopy varchar2);
48
49 PROCEDURE GetPOData
50 ( p_itemtype in varchar2
51 , p_itemkey in varchar2
52 , p_rec_num in number
53 , p_buyer out nocopy varchar2
54 , p_po_number out nocopy varchar2
55 , p_po_header_id out nocopy number
56 , p_po_distribution_id out nocopy number
57 , p_org_id out nocopy number
58 , p_po_line_qty out nocopy number
59 , p_po_line_uom out nocopy varchar2
60 , p_subcontractor out nocopy varchar2
61 , p_subcontractor_site out nocopy varchar2);
62
63 PROCEDURE SetPOData
64 ( p_itemtype in varchar2
65 , p_itemkey in varchar2
66 , p_rec_num in number
67 , p_buyer in varchar2
68 , p_po_number in varchar2
69 , p_po_header_id in number
70 , p_po_distribution_id in number
71 , p_org_id in number
72 , p_po_line_qty in number
73 , p_po_line_uom in varchar2
74 , p_subcontractor in varchar2
75 , p_subcontractor_site in varchar2
76 , p_required_assy_qty in number default null
77 , p_create_new_attr in boolean default true);
78
79 PROCEDURE MultiplePO ( itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 resultout out nocopy varchar2);
84
85 PROCEDURE Validate ( itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout out nocopy varchar2);
90
91 PROCEDURE StartDetailProcesses ( itemtype in varchar2,
92 itemkey in varchar2,
93 actid in number,
94 funcmode in varchar2,
95 resultout out nocopy varchar2);
96
97 PROCEDURE SelectShippingManager( itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 resultout out nocopy varchar2);
102
103 PROCEDURE GetShipToAddress ( itemtype in varchar2,
104 itemkey in varchar2,
105 actid in number,
106 funcmode in varchar2,
107 resultout out nocopy varchar2);
108
109 PROCEDURE StartWFProcToAnotherSupplier
110 ( p_po_distribution_id in NUMBER,
111 p_shipped_qty in NUMBER,
112 p_shipped_uom in VARCHAR2,
113 p_shipped_date in DATE default null,
114 p_expected_receipt_date in DATE default null,
115 p_packing_slip in VARCHAR2 default null,
116 p_airbill_waybill in VARCHAR2 default null,
117 p_bill_of_lading in VARCHAR2 default null,
118 p_packaging_code in VARCHAR2 default null,
119 p_num_of_container in NUMBER default null,
120 p_gross_weight in NUMBER default null,
121 p_gross_weight_uom in VARCHAR2 default null,
122 p_net_weight in NUMBER default null,
123 p_net_weight_uom in VARCHAR2 default null,
124 p_tar_weight in NUMBER default null,
125 p_tar_weight_uom in VARCHAR2 default null,
126 p_hazard_class in VARCHAR2 default null,
127 p_hazard_code in VARCHAR2 default null,
128 p_hazard_desc in VARCHAR2 default null,
129 p_special_handling_code in VARCHAR2 default null,
130 p_freight_carrier in VARCHAR2 default null,
131 p_freight_carrier_terms in VARCHAR2 default null,
132 p_carrier_equip in VARCHAR2 default null,
133 p_carrier_method in VARCHAR2 default null,
134 p_freight_bill_num in VARCHAR2 default null,
135 p_receipt_num in VARCHAR2 default null,
136 p_ussgl_txn_code in VARCHAR2 default null
137 );
138
139 PROCEDURE GetApprovedPO ( itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funcmode in varchar2,
143 resultout out nocopy varchar2);
144
145 PROCEDURE CopyPOAttr ( itemtype in varchar2,
146 itemkey in varchar2,
147 actid in number,
148 funcmode in varchar2,
149 resultout out nocopy varchar2);
150
151
152 END wip_osp_shp_i_wf;