[Home] [Help]
PACKAGE: APPS.PO_SUBINVENTORIES_S3
Source
1 PACKAGE PO_SUBINVENTORIES_S3 as
2 /* $Header: POXCOS3S.pls 120.0.12010000.1 2008/09/18 12:20:56 appldev noship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: PO_SUBINVENTORIES_S3
6
7 DESCRIPTION: This package contains validation for Inventory
8 transfers to determine whether an item/sub
9 combination is valid based on their source
10 and destination asset attributes.
11
12 OWNER: Liza Broadbent (should be transferred to Inventory)
13
14 FUNCTION/PROCEDURE: val_expense_asset()
15 val_expense_asset()
16
17 ===========================================================================*/
18 /*=========================================================================
19
20 FUNCTION: val_expense_asset()
21
22 RETURN: boolean
23
24 PARAMETERS: x_item_id in number
25 x_src_org_id in number
26 x_src_subinventory in varchar2
27 x_dest_org_id in number
28 x_dest_subinventory in varchar2
29
30 -- Use this version when you do not know the
31 -- attributes required in the second version.
32 -- This version will find these attributes,
33 -- and call the second version.
34 OR...
35
36 x_item_id in number
37 x_src_sub_asset_flag in number
38 x_src_item_asset_flag in varchar2
39 x_dest_sub_asset_flag in number
40 x_dest_item_asset_flag in varchar2
41 x_fob_point in number
42 x_intransit_type in number
43
44 Description: This function looks for invalid expense/asset
45 source and destination subinventory and item
46 combinations. It returns FALSE if the combination
47 is invalid, and TRUE if it is.
48
49 Algorithm: The following matrix highlights identifies
50 valid and invalid combinations (published by
51 Inventory on February 8, 1996):
52 Transfer Type: Direct
53
54 From Item To Item From Sub To Sub Valid?
55 -------------------------------------------------------------
56 Asset Asset Asset Asset Yes
57 Asset Asset Asset Expense Yes
58 Asset Asset Expense Expense Yes
59 Asset Asset Expense Asset No **
60 Asset Expense Asset Asset Yes
61 Asset Expense Asset Expense Yes
62 Asset Expense Expense Asset Yes
63 Asset Expense Expense Expense Yes
64 Expense Asset Asset Expense Yes
65 Expense Asset Asset Asset No **
66 Expense Asset Expense Expense Yes
67 Expense Asset Expense Asset No **
68 Expense Expense Asset Asset Yes
69 Expense Expense Asset Expense Yes
70 Expense Expense Expense Asset Yes
71 Expense Expense Expense Expense Yes
72
73 Transfer Type: Intransit, FOB = Receipt
74
75 From Item To Item From Sub To Sub Valid?
76 -------------------------------------------------------------
77 Asset Asset Asset Asset Yes
78 Asset Asset Asset Expense Yes
79 Asset Asset Expense Asset No **
80 Asset Asset Expense Expense No **
81 Asset Expense Asset Asset Yes
82 Asset Expense Asset Expense Yes
83 Asset Expense Expense Asset No **
84 Asset Expense Expense Expense No **
85 Expense Asset Asset Asset No **
86 Expense Asset Asset Expense Yes
87 Expense Asset Expense Asset No **
88 Expense Asset Expense Expense Yes
89 Expense Expense Asset Asset Yes
90 Expense Expense Asset Expense Yes
91 Expense Expense Expense Asset Yes
92 Expense Expense Expense Expense Yes
93
94 Transfer Type: Intransit, FOB = Shipment
95
96 From Item To Item From Sub To Sub Valid?
97 -------------------------------------------------------------
98 Asset Asset Asset Asset Yes
99 Asset Asset Asset Expense Yes
100 Asset Asset Expense Asset No **
101 Asset Asset Epense Expense No **
102 Asset Expense Asset Asset Yes
103 Asset Expense Asset Expense Yes
104 Asset Expense Expense Asset Yes
105 Asset Expense Expense Expense Yes
106 Expense Asset Asset Asset No **
107 Expense Asset Asset Expense No **
108 Expense Asset Expense Asset No **
109 Expense Asset Expense Expense No **
110 Expense Expense Asset Asset Yes
111 Expense Expense Asset Expense Yes
112 Expense Expense Expense Asset Yes
113 Expense Expense Expense Expense Yes
114
115 HISTORY: Created 31-MAR-96 Liza Broadbent
116
117 =============================================================================*/
118 function val_expense_asset(x_item_id in number,
119 x_src_org_id in number,
120 x_src_subinventory in varchar2,
121 x_dest_org_id in number,
122 x_dest_subinventory in varchar2) return boolean;
123
124 function val_expense_asset(x_item_id in number,
125 x_src_sub_asset_flag in number,
126 x_src_item_asset_flag in varchar2,
127 x_dest_sub_asset_flag in number,
128 x_dest_item_asset_flag in varchar2,
129 x_fob_point in number,
130 x_intransit_type in number) return boolean;
131
132 END PO_SUBINVENTORIES_S3;