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_RESALE_COMMON_PVT dependencies on OZF_VOLUME_SUMMARY_INT

Line 6836: OZF_VOLUME_SUMMARY_INT

6832: CURSOR ozf_vol_int_exists_csr IS
6833: SELECT 'Y'
6834: FROM DUAL
6835: WHERE EXISTS (SELECT 'Y' FROM
6836: OZF_VOLUME_SUMMARY_INT
6837: WHERE BATCH_TYPE='TP_ACCRUAL');
6838:
6839:
6840: CURSOR ozf_vol_int_exists_wp_csr(p_batch_id IN NUMBER) IS

Line 6843: WHERE EXISTS (SELECT 'Y' FROM OZF_VOLUME_SUMMARY_INT

6839:
6840: CURSOR ozf_vol_int_exists_wp_csr(p_batch_id IN NUMBER) IS
6841: SELECT 'Y'
6842: FROM DUAL
6843: WHERE EXISTS (SELECT 'Y' FROM OZF_VOLUME_SUMMARY_INT
6844: WHERE BATCH_TYPE='TP_ACCRUAL'
6845: AND RESALE_BATCH_ID=p_batch_id );
6846:
6847:

Line 7175: FROM OZF_VOLUME_SUMMARY_INT

7171: USING (SELECT SUM (GROUP_VOLUME) GROUP_VOLUME,
7172: OFFER_ID,
7173: GROUP_NO,
7174: PBH_LINE_ID
7175: FROM OZF_VOLUME_SUMMARY_INT
7176: WHERE GROUP_NO IS NOT NULL
7177: GROUP BY OFFER_ID, GROUP_NO, PBH_LINE_ID) ovolgrpint
7178: ON (ovolsum.OFFER_ID= ovolgrpint.OFFER_ID
7179: AND ovolsum.GROUP_NO = ovolgrpint.GROUP_NO

Line 7221: FROM OZF_VOLUME_SUMMARY_INT

7217: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7218: OFFER_ID,
7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID
7221: FROM OZF_VOLUME_SUMMARY_INT
7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7224: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

Line 7268: FROM OZF_VOLUME_SUMMARY_INT

7264: OFFER_ID,
7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID
7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7271: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

Line 7343: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);

7339: l_vol_exists :='N';
7340: END IF;
7341: CLOSE ozf_vol_int_exists_csr;
7342: IF l_vol_exists = 'Y' THEN
7343: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7344: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE BATCH_TYPE = 'TP_ACCRUAL';
7345: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7346: END IF;
7347:

Line 7344: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE BATCH_TYPE = 'TP_ACCRUAL';

7340: END IF;
7341: CLOSE ozf_vol_int_exists_csr;
7342: IF l_vol_exists = 'Y' THEN
7343: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7344: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE BATCH_TYPE = 'TP_ACCRUAL';
7345: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7346: END IF;
7347:
7348: END IF;

Line 7345: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);

7341: CLOSE ozf_vol_int_exists_csr;
7342: IF l_vol_exists = 'Y' THEN
7343: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7344: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE BATCH_TYPE = 'TP_ACCRUAL';
7345: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for Batch Type '||p_batch_type);
7346: END IF;
7347:
7348: END IF;
7349:

Line 7676: FROM OZF_VOLUME_SUMMARY_INT

7672: OFFER_ID,
7673: GROUP_NO,
7674: PBH_LINE_ID ,
7675: RESALE_BATCH_ID
7676: FROM OZF_VOLUME_SUMMARY_INT
7677: WHERE RESALE_BATCH_ID=p_batch_id
7678: AND GROUP_NO IS NOT NULL
7679: GROUP BY RESALE_BATCH_ID, OFFER_ID, GROUP_NO, PBH_LINE_ID) ovolgrpint
7680: ON (ovolsum.OFFER_ID= ovolgrpint.OFFER_ID

Line 7725: FROM OZF_VOLUME_SUMMARY_INT

7721: OFFER_ID,
7722: INDIVIDUAL_TYPE,
7723: PBH_LINE_ID ,
7724: RESALE_BATCH_ID
7725: FROM OZF_VOLUME_SUMMARY_INT
7726: WHERE RESALE_BATCH_ID=p_batch_id
7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7729: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID

Line 7775: FROM OZF_VOLUME_SUMMARY_INT

7771: INDIVIDUAL_TYPE,
7772: INDIVIDUAL_ID,
7773: PBH_LINE_ID ,
7774: RESALE_BATCH_ID
7775: FROM OZF_VOLUME_SUMMARY_INT
7776: WHERE RESALE_BATCH_ID=p_batch_id
7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7779: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID

Line 7847: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );

7843: l_vol_exists :='N';
7844: END IF;
7845: CLOSE ozf_vol_int_exists_wp_csr;
7846: IF l_vol_exists = 'Y' THEN
7847: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7848: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = 'TP_ACCRUAL' ;
7849: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7850: END IF;
7851: END IF;

Line 7848: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = 'TP_ACCRUAL' ;

7844: END IF;
7845: CLOSE ozf_vol_int_exists_wp_csr;
7846: IF l_vol_exists = 'Y' THEN
7847: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7848: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = 'TP_ACCRUAL' ;
7849: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7850: END IF;
7851: END IF;
7852:

Line 7849: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );

7845: CLOSE ozf_vol_int_exists_wp_csr;
7846: IF l_vol_exists = 'Y' THEN
7847: ozf_utility_pvt.write_conc_log('deleting records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7848: DELETE FROM OZF_VOLUME_SUMMARY_INT WHERE RESALE_BATCH_ID = p_batch_id AND BATCH_TYPE = 'TP_ACCRUAL' ;
7849: ozf_utility_pvt.write_conc_log('deleted records from staging table OZF_VOLUME_SUMMARY_INT for p_batch_type='||p_batch_type ||' and for batch id '|| p_batch_id );
7850: END IF;
7851: END IF;
7852:
7853: