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.

[Home] [Help]

APPS.CSI_COUNTER_READINGS_PUB dependencies on CSI_COUNTER_READINGS

Line 1: PACKAGE BODY CSI_COUNTER_READINGS_PUB as

1: PACKAGE BODY CSI_COUNTER_READINGS_PUB as
2: /* $Header: csipcrdb.pls 120.6 2011/12/20 05:42:31 aabmishr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csipcrdb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PUB';

1: PACKAGE BODY CSI_COUNTER_READINGS_PUB as
2: /* $Header: csipcrdb.pls 120.6 2011/12/20 05:42:31 aabmishr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csipcrdb.pls';
6: --
7: /*----------------------------------------------------*/
8: /* procedure name: Capture_Counter_Reading */

Line 62: from CSI_COUNTER_READINGS

58: --
59: CURSOR LATER_READINGS_CUR(p_counter_id IN NUMBER,p_value_timestamp IN DATE) IS
60: select counter_value_id,counter_reading,net_reading,value_timestamp,adjustment_reading
61: ,reset_mode,adjustment_type,include_target_resets
62: from CSI_COUNTER_READINGS
63: where counter_id = p_counter_id
64: and nvl(disabled_flag,'N') = 'N'
65: and value_timestamp > p_value_timestamp
66: ORDER BY value_timestamp asc, counter_value_id asc;

Line 87: from CSI_COUNTER_READINGS crg,

83: and ccv.counter_id = ccr.object_counter_id;
84: --
85: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
86: SELECT crg.counter_id
87: from CSI_COUNTER_READINGS crg,
88: CSI_COUNTER_RELATIONSHIPS ccr,
89: CSI_COUNTERS_B ccv
90: where crg.source_counter_value_id = p_ctr_value_id
91: and ccr.object_counter_id = crg.counter_id

Line 98: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

94: and ccv.counter_id = crg.counter_id;
95: --
96: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
97: SELECT ctr.counter_id
98: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
99: WHERE cv.counter_value_id = p_ctr_value_id
100: AND ctr.derive_counter_id = cv.counter_id
101: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
102: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line 146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction

142: IF p_txn_tbl.EXISTS(j) THEN
143: csi_ctr_gen_utility_pvt.put_line('Dumping Transaction Record # '||to_char(j));
144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));
145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false
149: ,p_init_msg_list => fnd_api.g_true
150: ,p_validation_level => fnd_api.g_valid_level_full

Line 179: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_PRE

175: END LOOP; -- End of Txn Tbl Loop
176: --
177: -- Calling Customer Pre-processing Hook
178: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' ) ) then
179: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_PRE
180: (
181: p_api_version => p_api_version
182: ,p_commit => p_commit
183: ,p_init_msg_list => p_init_msg_list

Line 193: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Pre API ');

189: ,x_msg_count => x_msg_count
190: ,x_msg_data => x_msg_data
191: );
192: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
193: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Pre API ');
194: l_msg_index := 1;
195: l_msg_count := x_msg_count;
196: WHILE l_msg_count > 0 LOOP
197: x_msg_data := FND_MSG_PUB.GET

Line 211: CSI_COUNTER_READINGS_VUHK.CAPTURE_COUNTER_READING_PRE

207: END IF;
208: --
209: -- Calling Vertical Pre-processing Hook
210: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) then
211: CSI_COUNTER_READINGS_VUHK.CAPTURE_COUNTER_READING_PRE
212: (
213: p_api_version => p_api_version
214: ,p_commit => p_commit
215: ,p_init_msg_list => p_init_msg_list

Line 225: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Pre API ');

221: ,x_msg_count => x_msg_count
222: ,x_msg_data => x_msg_data
223: );
224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
225: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Pre API ');
226: l_msg_index := 1;
227: l_msg_count := x_msg_count;
228: WHILE l_msg_count > 0 LOOP
229: x_msg_data := FND_MSG_PUB.GET

Line 302: -- below Csi_Counter_Readings_Pvt.Capture_Counter_Reading

298: END IF;
299: END IF; -- EAM Logging Check
300: --
301: --For bug 12536426 - Moved the code to call Update_Last_Service_Reading_Wo to
302: -- below Csi_Counter_Readings_Pvt.Capture_Counter_Reading
303: --
304: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Counter_Reading_pvt...');
305: Csi_Counter_Readings_Pvt.Capture_Counter_Reading
306: (

Line 305: Csi_Counter_Readings_Pvt.Capture_Counter_Reading

301: --For bug 12536426 - Moved the code to call Update_Last_Service_Reading_Wo to
302: -- below Csi_Counter_Readings_Pvt.Capture_Counter_Reading
303: --
304: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Counter_Reading_pvt...');
305: Csi_Counter_Readings_Pvt.Capture_Counter_Reading
306: (
307: p_api_version => 1.0
308: ,p_commit => p_commit
309: ,p_init_msg_list => p_init_msg_list

Line 398: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading

394: p_ctr_prop_rdg_tbl(k).value_timestamp := p_ctr_rdg_tbl(j).value_timestamp;
395: -- Call Property reading PVT;
396: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(p_ctr_prop_rdg_tbl(k));
397: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading...');
398: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
399: (
400: p_api_version => 1.0
401: ,p_commit => p_commit
402: ,p_init_msg_list => p_init_msg_list

Line 441: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading

437: l_dflt_ctr_prop_rec.counter_value_id := p_ctr_rdg_tbl(j).counter_value_id;
438: --
439: csi_ctr_gen_utility_pvt.dump_ctr_property_readings_rec(l_dflt_ctr_prop_rec);
440: csi_ctr_gen_utility_pvt.put_line('Calling Capture_Ctr_Property_Reading for Dflt Property');
441: Csi_Counter_Readings_Pvt.Capture_Ctr_Property_Reading
442: (
443: p_api_version => 1.0
444: ,p_commit => p_commit
445: ,p_init_msg_list => p_init_msg_list

Line 482: Csi_Counter_Readings_Pvt.Compute_Derive_Counters

478: l_derive_ctr_rec.source_line_id := p_ctr_rdg_tbl(j).source_line_id;
479: --
480: -- Call Compute Derive Counters
481: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters...');
482: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
483: (
484: p_api_version => 1.0
485: ,p_commit => p_commit
486: ,p_init_msg_list => p_init_msg_list

Line 524: Csi_Counter_Readings_Pvt.Compute_Derive_Counters

520: l_derive_ctr_rec.counter_id := p_ctr_rdg_tbl(j).counter_id;
521: l_derive_ctr_rec.value_timestamp := later_rdg.value_timestamp;
522: --
523: csi_ctr_gen_utility_pvt.put_line('Calling Compute_Derive_Counters for Update...');
524: Csi_Counter_Readings_Pvt.Compute_Derive_Counters
525: (
526: p_api_version => 1.0
527: ,p_commit => p_commit
528: ,p_init_msg_list => p_init_msg_list

Line 556: Csi_Counter_Readings_Pvt.Compute_Formula_Counters

552: END IF; -- End of Derive counter call check
553: END LOOP;
554: END IF; -- l_reset_only check
555: -- Call Compute Formula
556: Csi_Counter_Readings_Pvt.Compute_Formula_Counters
557: (
558: p_api_version => 1.0
559: ,p_commit => p_commit
560: ,p_init_msg_list => p_init_msg_list

Line 591: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_POST

587: --
588: csi_ctr_gen_utility_pvt.put_line('End of Private API Calls...');
589: -- Calling Customer Post-processing Hook
590: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'C' ) ) then
591: CSI_COUNTER_READINGS_CUHK.CAPTURE_COUNTER_READING_POST
592: (
593: p_api_version => p_api_version
594: ,p_commit => p_commit
595: ,p_init_msg_list => p_init_msg_list

Line 605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');

601: ,x_msg_count => x_msg_count
602: ,x_msg_data => x_msg_data
603: );
604: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');
606: l_msg_index := 1;
607: l_msg_count := x_msg_count;
608: WHILE l_msg_count > 0 LOOP
609: x_msg_data := FND_MSG_PUB.GET

Line 623: CSI_COUNTER_READINGS_VUHK.CAPTURE_COUNTER_READING_POST

619: END IF;
620: --
621: -- Calling Vertical Post-processing Hook
622: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) then
623: CSI_COUNTER_READINGS_VUHK.CAPTURE_COUNTER_READING_POST
624: (
625: p_api_version => p_api_version
626: ,p_commit => p_commit
627: ,p_init_msg_list => p_init_msg_list

Line 637: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Post API ');

633: ,x_msg_count => x_msg_count
634: ,x_msg_data => x_msg_data
635: );
636: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
637: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Post API ');
638: l_msg_index := 1;
639: l_msg_count := x_msg_count;
640: WHILE l_msg_count > 0 LOOP
641: x_msg_data := FND_MSG_PUB.GET

Line 832: from CSI_COUNTER_READINGS crg,

828: and ccv.counter_id = ccr.object_counter_id;
829: --
830: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
831: SELECT crg.counter_id
832: from CSI_COUNTER_READINGS crg,
833: CSI_COUNTER_RELATIONSHIPS ccr,
834: CSI_COUNTERS_B ccv
835: where crg.source_counter_value_id = p_ctr_value_id
836: and ccr.object_counter_id = crg.counter_id

Line 843: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

839: and ccv.counter_id = crg.counter_id;
840: --
841: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
842: SELECT ctr.counter_id
843: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
844: WHERE cv.counter_value_id = p_ctr_value_id
845: AND ctr.derive_counter_id = cv.counter_id
846: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
847: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line 886: CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_PRE

882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
883: END IF;
884: -- Calling Customer Pre-processing Hook
885: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' ) ) then
886: CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_PRE
887: (
888: p_api_version => p_api_version
889: ,p_commit => p_commit
890: ,p_init_msg_list => p_init_msg_list

Line 898: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');

894: ,x_msg_count => x_msg_count
895: ,x_msg_data => x_msg_data
896: );
897: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');
899: l_msg_index := 1;
900: l_msg_count := x_msg_count;
901: WHILE l_msg_count > 0 LOOP
902: x_msg_data := FND_MSG_PUB.GET

Line 916: CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_PRE

912: END IF;
913: --
914: -- Calling Vertical Pre-processing Hook
915: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) then
916: CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_PRE
917: (
918: p_api_version => p_api_version
919: ,p_commit => p_commit
920: ,p_init_msg_list => p_init_msg_list

Line 928: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');

924: ,x_msg_count => x_msg_count
925: ,x_msg_data => x_msg_data
926: );
927: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
928: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');
929: l_msg_index := 1;
930: l_msg_count := x_msg_count;
931: WHILE l_msg_count > 0 LOOP
932: x_msg_data := FND_MSG_PUB.GET

Line 950: Csi_Counter_Readings_Pvt.Update_Counter_Reading

946: IF p_ctr_rdg_tbl.EXISTS(j) THEN
947: -- Call Update Counter reading PVT;
948: csi_ctr_gen_utility_pvt.dump_counter_readings_rec(p_ctr_rdg_tbl(j));
949: csi_ctr_gen_utility_pvt.put_line('Calling Update_Counter_Reading_pvt...');
950: Csi_Counter_Readings_Pvt.Update_Counter_Reading
951: (
952: p_api_version => 1.0
953: ,p_commit => p_commit
954: ,p_init_msg_list => p_init_msg_list

Line 982: CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_POST

978: END IF;
979: --
980: -- Calling Customer Post-processing Hook
981: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'C' ) ) then
982: CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_POST
983: (
984: p_api_version => p_api_version
985: ,p_commit => p_commit
986: ,p_init_msg_list => p_init_msg_list

Line 994: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');

990: ,x_msg_count => x_msg_count
991: ,x_msg_data => x_msg_data
992: );
993: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
994: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');
995: l_msg_index := 1;
996: l_msg_count := x_msg_count;
997: WHILE l_msg_count > 0 LOOP
998: x_msg_data := FND_MSG_PUB.GET

Line 1012: CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_POST

1008: END IF;
1009: --
1010: -- Calling Vertical Post-processing Hook
1011: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) then
1012: CSI_COUNTER_READINGS_VUHK.UPDATE_COUNTER_READING_POST
1013: (
1014: p_api_version => p_api_version
1015: ,p_commit => p_commit
1016: ,p_init_msg_list => p_init_msg_list

Line 1024: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');

1020: ,x_msg_count => x_msg_count
1021: ,x_msg_data => x_msg_data
1022: );
1023: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1024: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');
1025: l_msg_index := 1;
1026: l_msg_count := x_msg_count;
1027: WHILE l_msg_count > 0 LOOP
1028: x_msg_data := FND_MSG_PUB.GET

Line 1167: END CSI_COUNTER_READINGS_PUB;

1163: p_data => x_msg_data
1164: );
1165: END Update_Counter_Reading;
1166:
1167: END CSI_COUNTER_READINGS_PUB;