APPS.OZF_SD_BATCH_FEED_PVT dependencies on OZF_SD_BATCH_LINE_DISPUTES

Line 1069: DELETE ozf_sd_batch_line_disputes

1065: AND bh.batch_number = p_batch_number;
1066:
1067:
1068: BEGIN
1069: DELETE ozf_sd_batch_line_disputes
1070: WHERE batch_id = l_batch_id
1071: AND batch_line_id IN (SELECT bl.batch_line_id
1072: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
1073: WHERE bl.batch_id = l_batch_id

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

1078: );
1079: EXCEPTION
1080: WHEN others THEN
1081: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1082: 'Exception Delete OZF_SD_BATCH_LINE_DISPUTES: '||sqlerrm);
1083: END;
1084:
1085: INSERT INTO ozf_sd_batch_line_disputes
1086: (batch_line_dispute_id,

Line 1085: INSERT INTO ozf_sd_batch_line_disputes

1081: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1082: 'Exception Delete OZF_SD_BATCH_LINE_DISPUTES: '||sqlerrm);
1083: END;
1084:
1085: INSERT INTO ozf_sd_batch_line_disputes
1086: (batch_line_dispute_id,
1087: batch_id,
1088: batch_line_id,
1089: object_version_number,

Line 1104: SELECT ozf_sd_batch_line_disputes_s.nextval,

1100: program_update_date,
1101: program_id,
1102: security_group_id)
1103:
1104: SELECT ozf_sd_batch_line_disputes_s.nextval,
1105: a.batch_id,
1106: a.batch_line_id,
1107: 1,
1108: a.dispute_code,

Line 3529: INSERT INTO ozf_sd_batch_line_disputes

3525: END IF;
3526:
3527: FOR i IN 0 .. l_dispute_index - 1 LOOP
3528:
3529: INSERT INTO ozf_sd_batch_line_disputes
3530: (batch_line_dispute_id,
3531: batch_id,
3532: batch_line_id,
3533: object_version_number,

Line 3548: (ozf_sd_batch_line_disputes_s.nextval,

3544: program_update_date,
3545: program_id,
3546: security_group_id)
3547: VALUES
3548: (ozf_sd_batch_line_disputes_s.nextval,
3549: v_dispute_code.batch_id,
3550: v_dispute_code.batch_line_id,
3551: 1,
3552: l_disputes(i),