[Home] [Help]
PACKAGE: APPS.INV_TROHDR_UTIL
Source
1 PACKAGE inv_trohdr_util AS
2 /* $Header: INVUTRHS.pls 120.0 2005/05/25 04:34:00 appldev noship $ */
3
4 -- Attributes global constants
5
6 g_attribute1 CONSTANT NUMBER := 1;
7 g_attribute10 CONSTANT NUMBER := 2;
8 g_attribute11 CONSTANT NUMBER := 3;
9 g_attribute12 CONSTANT NUMBER := 4;
10 g_attribute13 CONSTANT NUMBER := 5;
11 g_attribute14 CONSTANT NUMBER := 6;
12 g_attribute15 CONSTANT NUMBER := 7;
13 g_attribute2 CONSTANT NUMBER := 8;
14 g_attribute3 CONSTANT NUMBER := 9;
15 g_attribute4 CONSTANT NUMBER := 10;
16 g_attribute5 CONSTANT NUMBER := 11;
17 g_attribute6 CONSTANT NUMBER := 12;
18 g_attribute7 CONSTANT NUMBER := 13;
19 g_attribute8 CONSTANT NUMBER := 14;
20 g_attribute9 CONSTANT NUMBER := 15;
21 g_attribute_category CONSTANT NUMBER := 16;
22 g_created_by CONSTANT NUMBER := 17;
23 g_creation_date CONSTANT NUMBER := 18;
24 g_date_required CONSTANT NUMBER := 19;
25 g_description CONSTANT NUMBER := 20;
26 g_from_subinventory CONSTANT NUMBER := 21;
27 g_header CONSTANT NUMBER := 22;
28 g_header_status CONSTANT NUMBER := 23;
29 g_last_updated_by CONSTANT NUMBER := 24;
30 g_last_update_date CONSTANT NUMBER := 25;
31 g_last_update_login CONSTANT NUMBER := 26;
32 g_organization CONSTANT NUMBER := 27;
33 g_program_application CONSTANT NUMBER := 28;
34 g_program CONSTANT NUMBER := 29;
35 g_program_update_date CONSTANT NUMBER := 30;
36 g_request CONSTANT NUMBER := 31;
37 g_request_number CONSTANT NUMBER := 32;
38 g_status_date CONSTANT NUMBER := 33;
39 g_to_account CONSTANT NUMBER := 34;
40 g_to_subinventory CONSTANT NUMBER := 35;
41 g_move_order_type CONSTANT NUMBER := 36;
42 g_transaction_type CONSTANT NUMBER := 37;
43 g_max_attr_id CONSTANT NUMBER := 38;
44 g_ship_to_location_id CONSTANT NUMBER := 39;
45
46 -- Procedure Clear_Dependent_Attr
47
48 PROCEDURE clear_dependent_attr(
49 p_attr_id IN NUMBER := fnd_api.g_miss_num
50 , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
51 , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
52 , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
53 );
54
55 -- Procedure Apply_Attribute_Changes
56
57 PROCEDURE apply_attribute_changes(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
58
59 -- Function Complete_Record
60
61 FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
62 RETURN inv_move_order_pub.trohdr_rec_type;
63
64 -- Function Convert_Miss_To_Null for TROHDR_REC_TYPE
65
66 FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
67 RETURN inv_move_order_pub.trohdr_rec_type;
68
69 -- Bug#2536932: Function Convert_Miss_To_Null for TROHDR_VAL_REC_TYPE
70 -- This converts all the Miss Char or Number or Date to NULL Values.
71
72 FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
73 RETURN inv_move_order_pub.trohdr_val_rec_type;
74
75 -- Procedure Update_Row
76
77 PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type);
78
79 -- Procedure Update_Row_Status
80
81 PROCEDURE update_row_status(p_header_id IN NUMBER, p_status IN NUMBER);
82
83 -- Procedure Insert_Row
84
85 PROCEDURE insert_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type);
86
87 -- Procedure Delete_Row
88
89 PROCEDURE delete_row(p_header_id IN NUMBER);
90
91 -- Function Query_Row
92
93 FUNCTION query_row(p_header_id IN NUMBER)
94 RETURN inv_move_order_pub.trohdr_rec_type;
95
96 -- Procedure lock_Row
97 --
98
99 PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
100
101 -- Function Get_Values
102
103 FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
104 RETURN inv_move_order_pub.trohdr_val_rec_type;
105
106 -- Function Get_Ids
107
108 FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
109 RETURN inv_move_order_pub.trohdr_rec_type;
110 END inv_trohdr_util;