APPS.CSE_ASSET_UTIL_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 44: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

40: inv_subinventory_name VARCHAR2(10)
41: );
42:
43: FUNCTION asset_description(
44: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
45: x_error_msg OUT NOCOPY VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
47:
48: FUNCTION asset_category(

Line 49: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

45: x_error_msg OUT NOCOPY VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
47:
48: FUNCTION asset_category(
49: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
50: x_error_msg OUT NOCOPY VARCHAR2,
51: x_return_status OUT NOCOPY VARCHAR2
52: ) RETURN NUMBER;
53:

Line 55: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

51: x_return_status OUT NOCOPY VARCHAR2
52: ) RETURN NUMBER;
53:
54: FUNCTION book_type(
55: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
56: x_error_msg OUT NOCOPY VARCHAR2,
57: x_return_status OUT NOCOPY VARCHAR2
58: ) RETURN VARCHAR2;
59:

Line 61: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

57: x_return_status OUT NOCOPY VARCHAR2
58: ) RETURN VARCHAR2;
59:
60: FUNCTION date_place_in_service(
61: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
62: x_error_msg OUT NOCOPY VARCHAR2,
63: x_return_status OUT NOCOPY VARCHAR2
64: ) RETURN DATE;
65:

Line 67: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

63: x_return_status OUT NOCOPY VARCHAR2
64: ) RETURN DATE;
65:
66: FUNCTION asset_key(
67: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
68: x_error_msg OUT NOCOPY VARCHAR2,
69: x_return_status OUT NOCOPY VARCHAR2
70: ) RETURN NUMBER;
71:

Line 81: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

77: x_return_status OUT NOCOPY VARCHAR2
78: ) RETURN NUMBER ;*/
79:
80: FUNCTION deprn_expense_ccid(
81: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
82: x_error_msg OUT NOCOPY VARCHAR2,
83: x_return_status OUT NOCOPY VARCHAR2
84: ) RETURN NUMBER;
85:

Line 87: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

83: x_return_status OUT NOCOPY VARCHAR2
84: ) RETURN NUMBER;
85:
86: FUNCTION search_method(
87: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
88: x_error_msg OUT NOCOPY VARCHAR2,
89: x_return_status OUT NOCOPY VARCHAR2
90: ) RETURN VARCHAR2;
91:

Line 93: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

89: x_return_status OUT NOCOPY VARCHAR2
90: ) RETURN VARCHAR2;
91:
92: FUNCTION payables_ccid(
93: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
94: x_error_msg OUT NOCOPY VARCHAR2,
95: x_return_status OUT NOCOPY VARCHAR2
96: ) RETURN NUMBER;
97:

Line 99: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

95: x_return_status OUT NOCOPY VARCHAR2
96: ) RETURN NUMBER;
97:
98: FUNCTION tag_number(
99: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
100: x_error_msg OUT NOCOPY VARCHAR2,
101: x_return_status OUT NOCOPY VARCHAR2
102: ) RETURN VARCHAR2;
103:

Line 105: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

101: x_return_status OUT NOCOPY VARCHAR2
102: ) RETURN VARCHAR2;
103:
104: FUNCTION model_number(
105: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
106: x_error_msg OUT NOCOPY VARCHAR2,
107: x_return_status OUT NOCOPY VARCHAR2
108: ) RETURN VARCHAR2;
109:

Line 111: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

107: x_return_status OUT NOCOPY VARCHAR2
108: ) RETURN VARCHAR2;
109:
110: FUNCTION manufacturer(
111: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
112: x_error_msg OUT NOCOPY VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2
114: ) RETURN VARCHAR2;
115:

Line 117: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

113: x_return_status OUT NOCOPY VARCHAR2
114: ) RETURN VARCHAR2;
115:
116: FUNCTION employee(
117: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
118: x_error_msg OUT NOCOPY VARCHAR2,
119: x_return_status OUT NOCOPY VARCHAR2
120: ) RETURN NUMBER;
121:

Line 123: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

119: x_return_status OUT NOCOPY VARCHAR2
120: ) RETURN NUMBER;
121:
122: PROCEDURE is_valid_to_process(
123: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
124: x_valid_to_process OUT NOCOPY VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_error_msg OUT NOCOPY VARCHAR2);
127:

Line 130: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

126: x_error_msg OUT NOCOPY VARCHAR2);
127:
128:
129: FUNCTION retire_non_mtl(
130: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
131: p_asset_id IN NUMBER,
132: x_error_msg OUT NOCOPY VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2
134: ) RETURN VARCHAR2 ;

Line 140: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec

136: ---This function signature is different from others as there is
137: ---no inventory_item_id attribute on csi_i_asset_txn_temp table
138: ---as this was a desgin change.
139: FUNCTION inventory_item(
140: p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
141: ) RETURN NUMBER;
142:
143: PRAGMA RESTRICT_REFERENCES(inventory_item, WNDS);
144:

Line 146: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

142:
143: PRAGMA RESTRICT_REFERENCES(inventory_item, WNDS);
144:
145: PROCEDURE get_pending_retirements (
146: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
147: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_error_msg OUT NOCOPY VARCHAR2);
150:

Line 147: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,

143: PRAGMA RESTRICT_REFERENCES(inventory_item, WNDS);
144:
145: PROCEDURE get_pending_retirements (
146: p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
147: p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_error_msg OUT NOCOPY VARCHAR2);
150:
151: PROCEDURE get_pending_adjustments

Line 152: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,

148: x_return_status OUT NOCOPY VARCHAR2,
149: x_error_msg OUT NOCOPY VARCHAR2);
150:
151: PROCEDURE get_pending_adjustments
152: (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_error_msg OUT NOCOPY VARCHAR2);
155:
156: PROCEDURE insert_mass_add(

Line 195: PROCEDURE get_txn_class (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,

191: ,x_valid_to_retire_flag OUT NOCOPY VARCHAR2
192: ,x_error_msg OUT NOCOPY VARCHAR2
193: ,x_return_status OUT NOCOPY VARCHAR2);
194:
195: PROCEDURE get_txn_class (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
196: x_transaction_class OUT NOCOPY VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_error_msg OUT NOCOPY VARCHAR2) ;
199: