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_PUB dependencies on CSI_ORGANIZATION_UNIT_PVT

Line 107: csi_organization_unit_pvt.Gen_ou_Where_Clause

103: END IF;
104:
105:
106: -- Generate the where clause
107: csi_organization_unit_pvt.Gen_ou_Where_Clause
108: (p_ou_query_rec => p_ou_query_rec,
109: x_where_clause => l_where_clause );
110:
111: -- Build the select statement

Line 124: csi_organization_unit_pvt.Bind_ou_variable

120: dbms_sql.parse(l_cur_get_ou, l_select_stmt , dbms_sql.native);
121:
122:
123: -- Bind the variables
124: csi_organization_unit_pvt.Bind_ou_variable
125: ( p_ou_query_rec,
126: l_cur_get_ou );
127:
128:

Line 130: csi_organization_unit_pvt.Define_ou_Columns(l_cur_get_ou);

126: l_cur_get_ou );
127:
128:
129: -- Define output variables
130: csi_organization_unit_pvt.Define_ou_Columns(l_cur_get_ou);
131:
132: -- execute the select statement
133: l_rows_processed := dbms_sql.execute(l_cur_get_ou);
134:

Line 138: csi_organization_unit_pvt.Get_ou_Column_Values(l_cur_get_ou, l_ou_rec);

134:
135:
136: LOOP
137: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ou) = 0;
138: csi_organization_unit_pvt.Get_ou_Column_Values(l_cur_get_ou, l_ou_rec);
139: l_count := l_count + 1;
140: x_org_unit_tbl(l_count) := l_ou_rec;
141: END LOOP;
142:

Line 148: csi_organization_unit_pvt.Construct_ou_From_Hist(x_org_unit_tbl, p_time_stamp);

144: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ou);
145:
146: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
147: IF p_time_stamp <= sysdate THEN
148: csi_organization_unit_pvt.Construct_ou_From_Hist(x_org_unit_tbl, p_time_stamp);
149: ELSE
150: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_ERROR;

Line 160: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);

156: -- Resolve the foreign key columns if p_resolve_id_columns is true
157: IF p_resolve_id_columns = fnd_api.g_true THEN
158: IF x_org_unit_tbl.count > 0 THEN
159: l_org_unit_tbl := x_org_unit_tbl;
160: csi_organization_unit_pvt.Resolve_id_columns(l_org_unit_tbl);
161:
162: x_org_unit_tbl := l_org_unit_tbl;
163: END IF;
164: END IF;

Line 260: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

256: l_txn_rec csi_datastructures_pub.transaction_rec;
257: l_msg_index NUMBER;
258: l_msg_count NUMBER;
259: l_trace_enable_flag VARCHAR2(1) :='N';
260: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
261: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
262: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
263:
264: BEGIN

Line 261: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

257: l_msg_index NUMBER;
258: l_msg_count NUMBER;
259: l_trace_enable_flag VARCHAR2(1) :='N';
260: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
261: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
262: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
263:
264: BEGIN
265:

Line 262: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

258: l_msg_count NUMBER;
259: l_trace_enable_flag VARCHAR2(1) :='N';
260: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
261: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
262: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
263:
264: BEGIN
265:
266: -- Standard Start of API savepoint

Line 328: csi_organization_unit_pvt.create_organization_unit

324: IF p_org_unit_tbl.COUNT > 0 THEN
325: FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST
326: LOOP
327: IF p_org_unit_tbl.EXISTS(tab_row) THEN
328: csi_organization_unit_pvt.create_organization_unit
329: ( p_api_version => p_api_version
330: ,p_commit => fnd_api.g_false
331: ,p_init_msg_list => p_init_msg_list
332: ,p_validation_level => p_validation_level

Line 454: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;

450: l_debug_level NUMBER;
451: l_msg_count NUMBER;
452: l_msg_index NUMBER;
453: l_trace_enable_flag VARCHAR2(1) :='N';
454: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
455: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
456: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
457:
458: BEGIN

Line 455: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;

451: l_msg_count NUMBER;
452: l_msg_index NUMBER;
453: l_trace_enable_flag VARCHAR2(1) :='N';
454: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
455: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
456: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
457:
458: BEGIN
459:

Line 456: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;

452: l_msg_index NUMBER;
453: l_trace_enable_flag VARCHAR2(1) :='N';
454: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
455: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
456: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
457:
458: BEGIN
459:
460: -- Standard Start of API savepoint

Line 520: csi_organization_unit_pvt.update_organization_unit

516: IF p_org_unit_tbl.COUNT > 0 THEN
517: FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST
518: LOOP
519: IF p_org_unit_tbl.EXISTS(tab_row) THEN
520: csi_organization_unit_pvt.update_organization_unit
521: ( p_api_version => p_api_version
522: ,p_commit => fnd_api.g_false
523: ,p_init_msg_list => p_init_msg_list
524: ,p_validation_level => p_validation_level

Line 703: csi_organization_unit_pvt.expire_organization_unit

699: IF p_org_unit_tbl.COUNT > 0 THEN
700: FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST
701: LOOP
702: IF p_org_unit_tbl.EXISTS(tab_row) THEN
703: csi_organization_unit_pvt.expire_organization_unit
704: ( p_api_version => p_api_version
705: ,p_commit => fnd_api.g_false
706: ,p_init_msg_list => p_init_msg_list
707: ,p_validation_level => p_validation_level