eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.INV_TRANSACTION_LOVS

Source


1 PACKAGE INV_TRANSACTION_LOVS AUTHID CURRENT_USER AS
2 /* $Header: INVMWALS.pls 120.1 2005/06/17 09:58:20 appldev  $ */
3 
4 	TYPE t_genref IS REF CURSOR;
5 
6 	PROCEDURE GET_TXN_REASONS(x_txnreasonLOV OUT NOCOPY /* file.sql.39 change */ t_genref);
7 
8 	PROCEDURE GET_TXN_TYPES(x_txntypeLOV OUT NOCOPY /* file.sql.39 change */ t_genref,
9 				p_Transaction_Action_Id IN NUMBER,
10 				p_Transaction_Source_Type_Id IN NUMBER,
11 				p_Transaction_Type_Name IN VARCHAR2);
12 
13 	PROCEDURE GET_TXN_TYPES(x_motxntypeLOV OUT NOCOPY /* file.sql.39 change */ t_genref,
14 				p_Transaction_Source_Type_Id IN NUMBER);
15 
16 	PROCEDURE GET_CARRIER(x_getcarrierLOV OUT NOCOPY /* file.sql.39 change */ t_genref,
17 			      p_FromOrganization_Id IN NUMBER,
18 			      p_ToOrganization_Id IN NUMBER,
19 			      p_carrier IN VARCHAR2);
20 
21 	PROCEDURE GET_ACCOUNT_ALIAS(x_Accounts_Info OUT NOCOPY /* file.sql.39 change */ t_genref,
22 			       p_Organization_Id IN NUMBER,
23 			       p_Description     IN VARCHAR2);
24 
25 	PROCEDURE GET_ACCOUNTS(x_Accounts OUT NOCOPY /* file.sql.39 change */ t_genref,
26 			       p_Organization_Id IN NUMBER,
27 			       p_Concatenated_Segments IN VARCHAR2);
28 
29 	PROCEDURE GET_ITEMS(x_items OUT NOCOPY /* file.sql.39 change */ t_genref,
30 			    p_organization_id IN NUMBER,
31 			    p_concatenated_segments IN VARCHAR2);
32 	PROCEDURE GET_TRANSACTABLE_ITEMS(x_Items OUT NOCOPY /* file.sql.39 change */ t_genref,
33 					 p_Organization_Id IN NUMBER,
34 					 p_Concatenated_Segments IN VARCHAR2,
35 					 p_Transaction_Action_Id IN NUMBER,
36 					 p_To_Organization_Id IN NUMBER DEFAULT NULL);
37 
38 	PROCEDURE GET_VALID_LOCATORS(x_Locators OUT NOCOPY /* file.sql.39 change */ t_genref,
39 				     p_Organization_Id IN NUMBER,
40 				     p_Subinventory_Code IN VARCHAR2,
41 				     p_Restrict_Locators_Code IN NUMBER,
42 				     p_Inventory_Item_Id IN NUMBER,
43 				     p_Concatenated_Segments IN VARCHAR2);
44 
45 
46 	PROCEDURE GET_VALID_TO_LOCS(x_Locators OUT NOCOPY /* file.sql.39 change */ t_genref,
47 				     p_Transaction_Action_Id IN NUMBER,
48 		           	     p_To_Organization_Id IN NUMBER,
49 				     p_Organization_Id IN NUMBER,
50 				     p_Subinventory_Code IN VARCHAR2,
51 				     p_Restrict_Locators_Code IN NUMBER,
52 				     p_Inventory_Item_Id IN NUMBER,
53 				     p_Concatenated_Segments IN VARCHAR2);
54 
55 	PROCEDURE GET_VALID_SUBS(x_Zones OUT NOCOPY /* file.sql.39 change */ t_genref,
56 				 p_organization_id IN NUMBER,
57 				 p_subinventory_code IN VARCHAR2);
58 
59 	PROCEDURE GET_FROM_SUBS(x_Zones OUT NOCOPY /* file.sql.39 change */ t_genref,
60 				p_organization_id IN NUMBER);
61 
62 	PROCEDURE GET_FROM_SUBS(x_Zones OUT NOCOPY /* file.sql.39 change */ t_genref,
63 				 p_Organization_Id IN NUMBER,
64 				 p_Inventory_Item_Id IN NUMBER,
65 				 p_Restrict_Subinventories_Code IN NUMBER,
66 				 p_Secondary_Inventory_Name IN VARCHAR2,
67 				 p_Transaction_Action_Id IN NUMBER);
68 
69 	PROCEDURE GET_TO_SUB(x_to_sub OUT NOCOPY /* file.sql.39 change */ t_genref,
70 			     p_Organization_Id IN NUMBER,
71 			     p_Inventory_Item_Id IN NUMBER,
72 			     p_from_Secondary_Name IN VARCHAR2,
73 			     p_Restrict_Subinventories_Code IN NUMBER,
74 			     p_Secondary_Inventory_Name IN VARCHAR2,
75 			     p_From_Sub_Asset_Inventory IN VARCHAR2,
76 			     p_Transaction_Action_Id IN NUMBER,
77 			     p_To_Organization_Id IN NUMBER,
78 			     p_Serial_Number_Control_Code IN NUMBER);
79 			     --p_Serial IN VARCHAR2);
80 
81 	PROCEDURE GET_TO_SUB(x_Zones OUT NOCOPY /* file.sql.39 change */ t_genref,
82 				p_organization_id IN NUMBER,
83 				p_secondary_inventory_name in VARCHAR2);
84 
85 	procedure GET_ORG(x_org OUT NOCOPY /* file.sql.39 change */ t_genref,
86 			  p_responsibility_id IN NUMBER,
87 			  p_resp_application_id IN NUMBER);
88 
89 	PROCEDURE GET_TO_ORG(x_Organizations OUT NOCOPY /* file.sql.39 change */ t_genref,
90 			     p_From_Organization_Id IN NUMBER);
91 
92 
93 
94 	PROCEDURE GET_VALID_UOMS(x_UOMS OUT NOCOPY /* file.sql.39 change */ t_genref,
95 				 p_Organization_Id IN NUMBER,
96 				 p_Inventory_Item_Id IN NUMBER,
97 				 p_UOM_Code IN VARCHAR2);
98 
99 	PROCEDURE GET_VALID_LOTS(x_Lots OUT NOCOPY /* file.sql.39 change */ t_genref,
100 				 p_Organization_Id IN NUMBER,
101 				 p_Inventory_Item_Id IN NUMBER,
102 				 p_Lot IN VARCHAR2);
103 
104 	PROCEDURE GET_VALID_LOTS(x_Lots OUT NOCOPY /* file.sql.39 change */ t_genref,
105 				 p_Organization_Id IN NUMBER,
106 				 p_Inventory_Item_Id IN NUMBER,
107 				 p_subcode IN VARCHAR2,
108 				 p_revision IN VARCHAR2,
109 				 p_locatorid IN NUMBER,
110 				 p_Lot IN VARCHAR2);
111 
112 	PROCEDURE GET_VALID_REVS(x_Revs OUT NOCOPY /* file.sql.39 change */ t_genref,
113 				 p_Organization_Id IN NUMBER,
114 				 p_Inventory_Item_Id IN NUMBER,
115 				 p_Revision IN VARCHAR2);
116 
117 
118 	PROCEDURE GET_VALID_SERIAL_REC_2(x_RSerials IN OUT NOCOPY /* file.sql.39 change */ t_genref,
119 				 p_Current_Organization_Id IN NUMBER,
120 				 p_Inventory_Item_Id IN NUMBER,
121 				 p_Serial_Number IN VARCHAR2);
122 
123 	PROCEDURE GET_VALID_SERIAL_REC_5(x_RSerials IN OUT NOCOPY /* file.sql.39 change */ t_genref,
124 				 p_Current_Organization_Id IN NUMBER,
125 				 p_Inventory_Item_Id IN NUMBER,
126 				 p_Current_Subinventory_Code IN VARCHAR2,
127 				 p_Current_Locator_Id IN NUMBER,
128 				 p_Lot_Number IN VARCHAR2,
129 				 p_Serial_Number IN VARCHAR2);
130 
131 	PROCEDURE GET_VALID_SERIAL_ISSUE(x_RSerials OUT NOCOPY /* file.sql.39 change */ t_genref,
132 				 p_Current_Organization_Id IN NUMBER,
133 				 p_Current_Subinventory_Code IN VARCHAR2,
134 				 p_Current_Locator_Id IN NUMBER,
135 				 p_Current_Lot_Number IN VARCHAR2,
136 				 p_Inventory_Item_Id IN NUMBER,
137 				 p_Serial_Number IN VARCHAR2);
138 
139 
140 
141 	PROCEDURE GET_VALID_SERIALS(x_RSerials OUT NOCOPY /* file.sql.39 change */ t_genref,
142 					p_Serial_Number_Control_Code IN NUMBER,
143 					p_Inventory_Item_Id IN NUMBER,
144 					p_Current_Organization_Id IN NUMBER,
145 				p_Current_Subinventory_Code IN VARCHAR2,
146 					p_Current_Locator_Id  IN NUMBER,
147 					p_Lot_Number IN VARCHAR2,
148 					p_Transaction_Action_Id IN NUMBER,
149 					p_Serial_Number IN VARCHAR2);
150 
151 END INV_TRANSACTION_LOVS;