APPS.OZF_SD_BATCH_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 970: FROM ozf_sd_batch_lines_all

966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Lines created.');
967:
968: SELECT sum(batch_curr_claim_amount)
969: INTO l_batch_sum
970: FROM ozf_sd_batch_lines_all
971: WHERE batch_id = l_batch_id;
972:
973: -- Check for Batch Amount Threshold
974:

Line 1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');

1396:
1397: FND_DSQL.init;
1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');

Line 1883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');

1879: to_char(l_inv_org_id));
1880: END IF;
1881:
1882: IF OZF_DEBUG_LOW_ON THEN
1883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');
1884: END IF;
1885:
1886: INSERT INTO OZF_SD_BATCH_LINES_ALL
1887: (batch_line_id,

Line 1886: INSERT INTO OZF_SD_BATCH_LINES_ALL

1882: IF OZF_DEBUG_LOW_ON THEN
1883: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting INTO ozf_sd_batch_lines_all');
1884: END IF;
1885:
1886: INSERT INTO OZF_SD_BATCH_LINES_ALL
1887: (batch_line_id,
1888: object_version_number,
1889: batch_id,
1890: batch_line_number,

Line 1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');

1993: l_inv_org_id,
1994: 'Y');
1995:
1996: IF OZF_DEBUG_LOW_ON THEN
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserted INTO ozf_sd_batch_lines_all');
1998: END IF;
1999:
2000: l_batch_line_number := l_batch_line_number + 1;
2001: END IF;

Line 2053: FROM ozf_sd_batch_lines_all

2049: last_updated_by = FND_GLOBAL.USER_ID,
2050: object_version_number = object_version_number + 1
2051: WHERE utilization_id in
2052: (SELECT utilization_id
2053: FROM ozf_sd_batch_lines_all
2054: WHERE batch_id = l_batch_id);
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: IF OZF_DEBUG_HIGH_ON THEN

Line 2111: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '

2107: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start INVOKE_BATCH_AUTO_CLAIM ---');
2108: END IF;
2109:
2110: l_sql := 'SELECT HDR.BATCH_ID, HDR.vendor_site_id, HDR.BATCH_SUBMISSION_DATE '
2111: || ' FROM ozf_sd_batch_headers_all HDR, ozf_sd_batch_lines_all BLN '
2112: || ' WHERE HDR.batch_id = BLN.batch_id'
2113: || ' AND HDR.status_code = ''SUBMITTED'' ';
2114:
2115: