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 16: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,

12: /*----------------------------------------------------------*/
13:
14: PROCEDURE Initialize_ou_rec_no_dump
15: (
16: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
17: p_ou_id IN NUMBER,
18: x_first_no_dump IN OUT NOCOPY DATE
19: ) IS
20:

Line 89: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,

85: /*----------------------------------------------------------*/
86:
87: PROCEDURE Initialize_ou_rec
88: (
89: x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
90: p_ou_h_id IN NUMBER,
91: x_nearest_full_dump IN OUT NOCOPY DATE
92: ) IS
93:

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

153: /* from the history */
154: /*----------------------------------------------------------*/
155:
156: PROCEDURE Construct_ou_from_hist
157: ( x_ou_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl,
158: p_time_stamp IN DATE
159: ) IS
160:
161: l_nearest_full_dump DATE := p_time_stamp;

Line 163: l_ou_tbl csi_datastructures_pub.org_units_header_tbl;

159: ) IS
160:
161: l_nearest_full_dump DATE := p_time_stamp;
162: l_ou_hist_id NUMBER;
163: l_ou_tbl csi_datastructures_pub.org_units_header_tbl;
164: l_ou_count NUMBER := 0;
165: --
166: Process_next EXCEPTION;
167:

Line 415: (p_org_units_header_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl)

411: /* id columns */
412: /*----------------------------------------------------------*/
413:
414: PROCEDURE Resolve_id_columns
415: (p_org_units_header_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl)
416:
417: IS
418:
419: l_rltn_lookup_type VARCHAR2(30) := 'CSI_IO_RELATIONSHIP_TYPE_CODE';

Line 460: l_ou_rec csi_datastructures_pub.org_units_header_rec;

456:
457: PROCEDURE Define_ou_Columns
458: ( p_get_ou_cursor_id IN NUMBER
459: ) IS
460: l_ou_rec csi_datastructures_pub.org_units_header_rec;
461: BEGIN
462: dbms_sql.define_column(p_get_ou_cursor_id, 1, l_ou_rec.instance_ou_id);
463: dbms_sql.define_column(p_get_ou_cursor_id, 2, l_ou_rec.instance_id);
464: dbms_sql.define_column(p_get_ou_cursor_id, 3, l_ou_rec.operating_unit_id);

Line 496: x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec

492: /*----------------------------------------------------------*/
493:
494: PROCEDURE Get_ou_Column_Values
495: ( p_get_ou_cursor_id IN NUMBER,
496: x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec
497: ) IS
498:
499: BEGIN
500: dbms_sql.column_value(p_get_ou_cursor_id, 1, x_ou_rec.instance_ou_id);

Line 528: (p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec,

524: END Get_ou_Column_Values;
525:
526:
527: PROCEDURE Bind_ou_variable
528: (p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec,
529: p_cur_get_ou IN NUMBER
530: )
531: IS
532: BEGIN

Line 565: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec

561: /* clause for Organization units */
562: /*----------------------------------------------------------*/
563:
564: PROCEDURE Gen_ou_Where_Clause
565: ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
566: ,x_where_clause OUT NOCOPY VARCHAR2
567: ) IS
568:
569: BEGIN

Line 646: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec

642: p_api_version IN NUMBER
643: ,p_commit IN VARCHAR2
644: ,p_init_msg_list IN VARCHAR2
645: ,p_validation_level IN NUMBER
646: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec
647: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2

Line 647: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

643: ,p_commit IN VARCHAR2
644: ,p_init_msg_list IN VARCHAR2
645: ,p_validation_level IN NUMBER
646: ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec
647: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

Line 1129: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec

1125: p_api_version IN NUMBER
1126: ,p_commit IN VARCHAR2
1127: ,p_init_msg_list IN VARCHAR2
1128: ,p_validation_level IN NUMBER
1129: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
1130: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1130: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1126: ,p_commit IN VARCHAR2
1127: ,p_init_msg_list IN VARCHAR2
1128: ,p_validation_level IN NUMBER
1129: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
1130: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl

Line 1148: l_org_unit_rec csi_datastructures_pub.organization_units_rec;

1144: l_instance_ou_id NUMBER := p_org_unit_rec.instance_ou_id;
1145: l_start_date DATE;
1146: l_dump_frequency NUMBER;
1147: l_csi_i_org_assign_h_id NUMBER;
1148: l_org_unit_rec csi_datastructures_pub.organization_units_rec;
1149: l_temp_org_unit_rec csi_datastructures_pub.organization_units_rec;
1150: l_dump_frequency_flag VARCHAR2(30);
1151: l_msg_index NUMBER;
1152: l_msg_count NUMBER;

Line 1149: l_temp_org_unit_rec csi_datastructures_pub.organization_units_rec;

1145: l_start_date DATE;
1146: l_dump_frequency NUMBER;
1147: l_csi_i_org_assign_h_id NUMBER;
1148: l_org_unit_rec csi_datastructures_pub.organization_units_rec;
1149: l_temp_org_unit_rec csi_datastructures_pub.organization_units_rec;
1150: l_dump_frequency_flag VARCHAR2(30);
1151: l_msg_index NUMBER;
1152: l_msg_count NUMBER;
1153: l_exists_flag VARCHAR2(1);

Line 1155: l_org_units_hist_rec csi_datastructures_pub.org_units_history_rec;

1151: l_msg_index NUMBER;
1152: l_msg_count NUMBER;
1153: l_exists_flag VARCHAR2(1);
1154: l_valid_flag VARCHAR2(1);
1155: l_org_units_hist_rec csi_datastructures_pub.org_units_history_rec;
1156: l_operating_unit_id NUMBER;
1157: l_rel_type_code VARCHAR2(30);
1158:
1159: CURSOR org_hist_csr (p_org_hist_id NUMBER) IS

Line 2432: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec

2428: p_api_version IN NUMBER
2429: ,p_commit IN VARCHAR2
2430: ,p_init_msg_list IN VARCHAR2
2431: ,p_validation_level IN NUMBER
2432: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
2433: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2434: ,x_return_status OUT NOCOPY VARCHAR2
2435: ,x_msg_count OUT NOCOPY NUMBER
2436: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2433: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2429: ,p_commit IN VARCHAR2
2430: ,p_init_msg_list IN VARCHAR2
2431: ,p_validation_level IN NUMBER
2432: ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
2433: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2434: ,x_return_status OUT NOCOPY VARCHAR2
2435: ,x_msg_count OUT NOCOPY NUMBER
2436: ,x_msg_data OUT NOCOPY VARCHAR2
2437: )

Line 2443: l_org_unit_rec csi_datastructures_pub.organization_units_rec;

2439: IS
2440: l_api_name CONSTANT VARCHAR2(30) := 'expire_organization_unit';
2441: l_api_version CONSTANT NUMBER := 1.0;
2442: l_debug_level NUMBER;
2443: l_org_unit_rec csi_datastructures_pub.organization_units_rec;
2444: l_object_version_number NUMBER;
2445: l_msg_count NUMBER;
2446: l_msg_index NUMBER;
2447: l_exists_flag VARCHAR2(1);

Line 2637: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl

2633: ,p_commit IN VARCHAR2
2634: ,p_init_msg_list IN VARCHAR2
2635: ,p_validation_level IN NUMBER
2636: ,p_transaction_id IN NUMBER
2637: ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
2638: ,x_return_status OUT NOCOPY VARCHAR2
2639: ,x_msg_count OUT NOCOPY NUMBER
2640: ,x_msg_data OUT NOCOPY VARCHAR2
2641: ) IS

Line 2647: l_org_unit_tbl csi_datastructures_pub.org_units_header_tbl;

2643: l_api_version CONSTANT NUMBER := 1.0 ;
2644: l_csi_debug_level NUMBER ;
2645: l_count NUMBER := 0 ;
2646: l_flag VARCHAR2(1) :='N' ;
2647: l_org_unit_tbl csi_datastructures_pub.org_units_header_tbl;
2648: i NUMBER :=1;
2649:
2650: CURSOR get_org_unit_hist(i_transaction_id NUMBER)
2651: IS