DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_FEED_PVT dependencies on OZF_SD_BATCH_LINE_DISPUTES

Line 739: DELETE ozf_sd_batch_line_disputes

735: RETURN;
736: END IF;
737:
738: BEGIN
739: DELETE ozf_sd_batch_line_disputes
740: WHERE batch_id = l_batch_id
741: AND batch_line_id IN (SELECT bl.batch_line_id
742: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
743: WHERE bl.batch_id = l_batch_id

Line 752: 'Exception Delete OZF_SD_BATCH_LINE_DISPUTES: '||sqlerrm);

748: );
749: EXCEPTION
750: WHEN others THEN
751: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
752: 'Exception Delete OZF_SD_BATCH_LINE_DISPUTES: '||sqlerrm);
753: END;
754:
755: FOR v_vendor_ref IN (SELECT batch_line_number, credit_reference_id
756: FROM ozf_sd_batch_lines_int_all

Line 1202: INSERT INTO ozf_sd_batch_line_disputes

1198: END IF;
1199:
1200: FOR i IN 0 .. l_dispute_index - 1 LOOP
1201:
1202: INSERT INTO ozf_sd_batch_line_disputes
1203: (batch_line_dispute_id,
1204: batch_id,
1205: batch_line_id,
1206: object_version_number,

Line 1221: (ozf_sd_batch_line_disputes_s.nextval,

1217: program_update_date,
1218: program_id,
1219: security_group_id)
1220: VALUES
1221: (ozf_sd_batch_line_disputes_s.nextval,
1222: v_dispute_code.batch_id,
1223: v_dispute_code.batch_line_id,
1224: 1,
1225: l_disputes(i),