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

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 7170: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7166: END LOOP; -- batch_id_csr
7167:
7168:
7169: IF p_batch_type='TP_ACCRUAL' THEN
7170: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7171: USING (SELECT SUM (GROUP_VOLUME) GROUP_VOLUME,
7172: OFFER_ID,
7173: GROUP_NO,
7174: PBH_LINE_ID

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 7203: ozf_volume_summary_s.NEXTVAL

7199: ,ovolsum.pbh_line_id
7200: )
7201: VALUES
7202: (
7203: ozf_volume_summary_s.NEXTVAL
7204: ,SYSDATE
7205: ,FND_GLOBAL.user_id
7206: ,SYSDATE
7207: ,FND_GLOBAL.user_id

Line 7216: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7212: ,ovolgrpint.PBH_LINE_ID
7213: );
7214:
7215:
7216: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7217: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7218: OFFER_ID,
7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID

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 7250: ozf_volume_summary_s.NEXTVAL

7246: ,ovolsum.pbh_line_id
7247: )
7248: VALUES
7249: (
7250: ozf_volume_summary_s.NEXTVAL
7251: ,SYSDATE
7252: ,FND_GLOBAL.user_id
7253: ,SYSDATE
7254: ,FND_GLOBAL.user_id

Line 7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7258: ,ovolindint.INDIVIDUAL_VOLUME
7259: ,ovolindint.PBH_LINE_ID
7260: );
7261:
7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7263: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7264: OFFER_ID,
7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,

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 7298: ozf_volume_summary_s.NEXTVAL

7294: ,ovolsum.pbh_line_id
7295: )
7296: VALUES
7297: (
7298: ozf_volume_summary_s.NEXTVAL
7299: ,SYSDATE
7300: ,FND_GLOBAL.user_id
7301: ,SYSDATE
7302: ,FND_GLOBAL.user_id

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 7670: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7666:
7667:
7668:
7669: IF p_batch_type='TP_ACCRUAL' THEN
7670: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7671: USING (SELECT SUM (GROUP_VOLUME) GROUP_VOLUME,
7672: OFFER_ID,
7673: GROUP_NO,
7674: PBH_LINE_ID ,

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 7705: ozf_volume_summary_s.NEXTVAL

7701: ,ovolsum.pbh_line_id
7702: )
7703: VALUES
7704: (
7705: ozf_volume_summary_s.NEXTVAL
7706: ,SYSDATE
7707: ,FND_GLOBAL.user_id
7708: ,SYSDATE
7709: ,FND_GLOBAL.user_id

Line 7719: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7715: );
7716:
7717:
7718:
7719: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7720: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7721: OFFER_ID,
7722: INDIVIDUAL_TYPE,
7723: PBH_LINE_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 7755: ozf_volume_summary_s.NEXTVAL

7751: ,ovolsum.pbh_line_id
7752: )
7753: VALUES
7754: (
7755: ozf_volume_summary_s.NEXTVAL
7756: ,SYSDATE
7757: ,FND_GLOBAL.user_id
7758: ,SYSDATE
7759: ,FND_GLOBAL.user_id

Line 7768: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

7764: ,ovolindint.PBH_LINE_ID
7765: );
7766:
7767:
7768: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7769: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7770: OFFER_ID,
7771: INDIVIDUAL_TYPE,
7772: INDIVIDUAL_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 7806: ozf_volume_summary_s.NEXTVAL

7802: ,ovolsum.pbh_line_id
7803: )
7804: VALUES
7805: (
7806: ozf_volume_summary_s.NEXTVAL
7807: ,SYSDATE
7808: ,FND_GLOBAL.user_id
7809: ,SYSDATE
7810: ,FND_GLOBAL.user_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: