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.

APPS.CSI_ORGANIZATION_UNIT_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 35: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,

31: /*----------------------------------------------------------*/
32:
33: PROCEDURE Initialize_ou_rec_no_dump
34: (
35: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
36: p_ou_id IN NUMBER,
37: x_first_no_dump IN OUT NOCOPY DATE
38: );
39:

Line 48: ( x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,

44: /* from the history */
45: /*----------------------------------------------------------*/
46:
47: PROCEDURE Initialize_ou_rec
48: ( x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
49: p_ou_h_id IN NUMBER,
50: x_nearest_full_dump IN OUT NOCOPY DATE
51: );
52:

Line 61: ( x_ou_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl,

57: /* from the history */
58: /*----------------------------------------------------------*/
59:
60: PROCEDURE Construct_ou_from_hist
61: ( x_ou_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl,
62: p_time_stamp IN DATE
63: );
64:
65:

Line 83: (p_org_units_header_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl);

79: /* id columns */
80: /*----------------------------------------------------------*/
81:
82: PROCEDURE Resolve_id_columns
83: (p_org_units_header_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl);
84:
85:
86: /*----------------------------------------------------------*/
87: /* Procedure name: Get_ou_Column_Values */

Line 94: x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec

90: /*----------------------------------------------------------*/
91:
92: PROCEDURE Get_ou_Column_Values
93: (p_get_ou_cursor_id IN NUMBER,
94: x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec
95: );
96:
97:
98:

Line 107: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec,

103: /* cluase for organization assignments */
104: /*----------------------------------------------------------*/
105:
106: PROCEDURE Bind_ou_variable
107: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec,
108: p_cur_get_ou IN NUMBER
109: );
110:
111:

Line 120: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec

116: /* clause for Organization units */
117: /*----------------------------------------------------------*/
118:
119: PROCEDURE Gen_ou_Where_Clause
120: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
121: ,x_where_clause OUT NOCOPY VARCHAR2
122: );
123:
124:

Line 138: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec

134: ( p_api_version IN NUMBER
135: ,p_commit IN VARCHAR2 := fnd_api.g_false
136: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
137: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec
139: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2

Line 139: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

135: ,p_commit IN VARCHAR2 := fnd_api.g_false
136: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
137: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec
139: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2
143: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

Line 163: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec

159: ( p_api_version IN NUMBER
160: ,p_commit IN VARCHAR2 := fnd_api.g_false
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
162: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
163: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
164: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2

Line 164: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

160: ,p_commit IN VARCHAR2 := fnd_api.g_false
161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
162: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
163: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
164: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2
168: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

Line 188: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec

184: ( p_api_version IN NUMBER
185: ,p_commit IN VARCHAR2 := fnd_api.g_false
186: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
187: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
189: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER
192: ,x_msg_data OUT NOCOPY VARCHAR2

Line 189: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

185: ,p_commit IN VARCHAR2 := fnd_api.g_false
186: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
187: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
189: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER
192: ,x_msg_data OUT NOCOPY VARCHAR2
193: );

Line 212: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl

208: ,p_commit IN VARCHAR2 := fnd_api.g_false
209: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
210: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
211: ,p_transaction_id IN NUMBER
212: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
213: ,x_return_status OUT NOCOPY VARCHAR2
214: ,x_msg_count OUT NOCOPY NUMBER
215: ,x_msg_data OUT NOCOPY VARCHAR2
216: );