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.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_VOLUME_SUMMARY

Line 170: FROM ozf_volume_summary

166: AND indirect_flag = p_indirect_flag;
167:
168: CURSOR c_group_volume_exists(p_offer_id NUMBER, p_group_no NUMBER, p_pbh_lind_id NUMBER) IS
169: SELECT 'Y'
170: FROM ozf_volume_summary
171: WHERE offer_id = p_offer_id
172: AND group_no = p_group_no
173: AND pbh_line_id = p_pbh_lind_id;
174:

Line 177: FROM ozf_volume_summary

173: AND pbh_line_id = p_pbh_lind_id;
174:
175: CURSOR c_individual_volume_exists(p_offer_id NUMBER, p_individual_type VARCHAR2, p_individual_id NUMBER, p_pbh_line_id NUMBER) IS
176: SELECT 'Y'
177: FROM ozf_volume_summary
178: WHERE offer_id = p_offer_id
179: AND individual_type = p_individual_type
180: AND individual_id = p_individual_id
181: AND pbh_line_id = p_pbh_line_id;

Line 444: UPDATE ozf_volume_summary

440: CLOSE c_group_volume_exists;
441: ozf_utility_pvt.write_conc_log('group ' || l_volume_exists);
442: IF l_volume_exists = 'Y' THEN -- update group's volume
443: IF l_combine_schedule_yn = 'Y' THEN -- update all pbh lines
444: UPDATE ozf_volume_summary
445: SET group_volume = group_volume + l_current_volume,
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id

Line 452: UPDATE ozf_volume_summary

448: last_update_login = FND_GLOBAL.conc_login_id
449: WHERE offer_id = p_offer_id
450: AND group_no = l_group_no;
451: ELSE -- update one pbh line only
452: UPDATE ozf_volume_summary
453: SET group_volume = group_volume + l_current_volume,
454: last_update_date = SYSDATE,
455: last_updated_by = FND_GLOBAL.user_id,
456: last_update_login = FND_GLOBAL.conc_login_id

Line 464: INSERT INTO ozf_volume_summary

460: END IF;
461: ELSE -- insert group's volume
462: IF l_combine_schedule_yn = 'Y' THEN -- insert all pbh lines
463: FOR l_pbh_line IN c_pbh_lines(p_offer_id) LOOP
464: INSERT INTO ozf_volume_summary
465: (
466: volume_summary_id
467: ,creation_date
468: ,created_by

Line 480: ozf_volume_summary_s.NEXTVAL

476: ,pbh_line_id
477: )
478: VALUES
479: (
480: ozf_volume_summary_s.NEXTVAL
481: ,SYSDATE
482: ,FND_GLOBAL.user_id
483: ,SYSDATE
484: ,FND_GLOBAL.user_id

Line 494: INSERT INTO ozf_volume_summary

490: ,l_pbh_line.offer_discount_line_id
491: );
492: END LOOP;
493: ELSE -- insert one pbh line
494: INSERT INTO ozf_volume_summary
495: (
496: volume_summary_id
497: ,creation_date
498: ,created_by

Line 510: ozf_volume_summary_s.NEXTVAL

506: ,pbh_line_id
507: )
508: VALUES
509: (
510: ozf_volume_summary_s.NEXTVAL
511: ,SYSDATE
512: ,FND_GLOBAL.user_id
513: ,SYSDATE
514: ,FND_GLOBAL.user_id

Line 535: UPDATE ozf_volume_summary

531: FETCH c_individual_volume_exists INTO l_volume_exists;
532: CLOSE c_individual_volume_exists;
533: ozf_utility_pvt.write_conc_log('distributor ' || l_volume_exists);
534: IF l_volume_exists = 'Y' THEN -- update distributor's volume
535: UPDATE ozf_volume_summary
536: SET individual_volume = individual_volume + l_current_volume,
537: last_update_date = SYSDATE,
538: last_updated_by = FND_GLOBAL.user_id,
539: last_update_login = FND_GLOBAL.conc_login_id

Line 545: INSERT INTO ozf_volume_summary

541: AND individual_type = 'DISTRIBUTOR'
542: AND individual_id = p_volume_detail_rec.sold_from_cust_account_id
543: AND pbh_line_id = l_pbh_line_id;
544: ELSE -- insert distributor's volume
545: INSERT INTO ozf_volume_summary
546: (
547: volume_summary_id
548: ,creation_date
549: ,created_by

Line 562: ozf_volume_summary_s.NEXTVAL

558: ,pbh_line_id
559: )
560: VALUES
561: (
562: ozf_volume_summary_s.NEXTVAL
563: ,SYSDATE
564: ,FND_GLOBAL.user_id
565: ,SYSDATE
566: ,FND_GLOBAL.user_id

Line 585: UPDATE ozf_volume_summary

581: FETCH c_individual_volume_exists INTO l_volume_exists;
582: CLOSE c_individual_volume_exists;
583: ozf_utility_pvt.write_conc_log('account ' || l_volume_exists);
584: IF l_volume_exists = 'Y' THEN -- update customer's volume
585: UPDATE ozf_volume_summary
586: SET individual_volume = individual_volume + l_current_volume,
587: last_update_date = SYSDATE,
588: last_updated_by = FND_GLOBAL.user_id,
589: last_update_login = FND_GLOBAL.conc_login_id

Line 595: INSERT INTO ozf_volume_summary

591: AND individual_type = 'ACCOUNT'
592: AND individual_id = p_volume_detail_rec.sold_to_cust_account_id
593: AND pbh_line_id = l_pbh_line_id;
594: ELSE -- insert customer's volume
595: INSERT INTO ozf_volume_summary
596: (
597: volume_summary_id
598: ,creation_date
599: ,created_by

Line 612: ozf_volume_summary_s.NEXTVAL

608: ,pbh_line_id
609: )
610: VALUES
611: (
612: ozf_volume_summary_s.NEXTVAL
613: ,SYSDATE
614: ,FND_GLOBAL.user_id
615: ,SYSDATE
616: ,FND_GLOBAL.user_id

Line 634: UPDATE ozf_volume_summary

630: FETCH c_individual_volume_exists INTO l_volume_exists;
631: CLOSE c_individual_volume_exists;
632: ozf_utility_pvt.write_conc_log('bill_to ' || l_volume_exists);
633: IF l_volume_exists = 'Y' THEN -- update bill_to's volume
634: UPDATE ozf_volume_summary
635: SET individual_volume = individual_volume + l_current_volume,
636: last_update_date = SYSDATE,
637: last_updated_by = FND_GLOBAL.user_id,
638: last_update_login = FND_GLOBAL.conc_login_id

Line 644: INSERT INTO ozf_volume_summary

640: AND individual_type = 'BILL_TO'
641: AND individual_id = p_volume_detail_rec.bill_to_site_use_id
642: AND pbh_line_id = l_pbh_line_id;
643: ELSE -- insert bill_to's volume
644: INSERT INTO ozf_volume_summary
645: (
646: volume_summary_id
647: ,creation_date
648: ,created_by

Line 661: ozf_volume_summary_s.NEXTVAL

657: ,pbh_line_id
658: )
659: VALUES
660: (
661: ozf_volume_summary_s.NEXTVAL
662: ,SYSDATE
663: ,FND_GLOBAL.user_id
664: ,SYSDATE
665: ,FND_GLOBAL.user_id

Line 683: UPDATE ozf_volume_summary

679: FETCH c_individual_volume_exists INTO l_volume_exists;
680: CLOSE c_individual_volume_exists;
681: ozf_utility_pvt.write_conc_log('ship to ' || l_volume_exists);
682: IF l_volume_exists = 'Y' THEN -- update ship_to's volume
683: UPDATE ozf_volume_summary
684: SET individual_volume = individual_volume + l_current_volume,
685: last_update_date = SYSDATE,
686: last_updated_by = FND_GLOBAL.user_id,
687: last_update_login = FND_GLOBAL.conc_login_id

Line 693: INSERT INTO ozf_volume_summary

689: AND individual_type = 'SHIP_TO'
690: AND individual_id = p_volume_detail_rec.ship_to_site_use_id
691: AND pbh_line_id = l_pbh_line_id;
692: ELSE -- insert ship_to's volume
693: INSERT INTO ozf_volume_summary
694: (
695: volume_summary_id
696: ,creation_date
697: ,created_by

Line 710: ozf_volume_summary_s.NEXTVAL

706: ,pbh_line_id
707: )
708: VALUES
709: (
710: ozf_volume_summary_s.NEXTVAL
711: ,SYSDATE
712: ,FND_GLOBAL.user_id
713: ,SYSDATE
714: ,FND_GLOBAL.user_id

Line 1289: FROM ozf_volume_summary

1285: )
1286: IS
1287: CURSOR c_group_volume IS
1288: SELECT group_volume
1289: FROM ozf_volume_summary
1290: WHERE offer_id = p_offer_id
1291: AND group_no = p_group_no
1292: AND pbh_line_id = p_pbh_line_id;
1293:

Line 1296: FROM ozf_volume_summary

1292: AND pbh_line_id = p_pbh_line_id;
1293:
1294: CURSOR c_individual_volume(p_volume_track_type VARCHAR2, p_volume_track_id NUMBER) IS
1295: SELECT individual_volume
1296: FROM ozf_volume_summary
1297: WHERE offer_id = p_offer_id
1298: AND individual_type = p_vol_track_type
1299: AND individual_id = p_volume_track_id
1300: AND pbh_line_id = p_pbh_line_id;

Line 1304: FROM ozf_volume_summary

1300: AND pbh_line_id = p_pbh_line_id;
1301:
1302: CURSOR c_combine_individual_volume(p_volume_track_type VARCHAR2, p_volume_track_id NUMBER) IS
1303: SELECT SUM(individual_volume)
1304: FROM ozf_volume_summary
1305: WHERE offer_id = p_offer_id
1306: AND individual_type = p_vol_track_type
1307: AND individual_id = p_volume_track_id;
1308:

Line 1976: select nvl(group_volume,0) into l_group_volume from ozf_volume_summary

1972: IS
1973: l_group_volume NUMBER;
1974: BEGIN
1975:
1976: select nvl(group_volume,0) into l_group_volume from ozf_volume_summary
1977: where offer_id = p_offer_id
1978: and group_no = p_group_number
1979: and pbh_line_id = p_pbh_line_id;
1980: