DBA Data[Home] [Help]

APPS.INV_3PL_SEEDED_SOURCES dependencies on INV_3PL_BILLING_PUB

Line 67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

63:
64: BEGIN
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

Line 68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';

64: BEGIN
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
72:

Line 69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

65:
66: x_return_status := fnd_api.g_ret_sts_success;
67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
72:
73: if l_last_computation_date is null then -- For 1st run of fresh LSP install

Line 70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

66: x_return_status := fnd_api.g_ret_sts_success;
67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
72:
73: if l_last_computation_date is null then -- For 1st run of fresh LSP install
74: l_last_computation_Date := l_service_line_start_date;

Line 71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
71: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
72:
73: if l_last_computation_date is null then -- For 1st run of fresh LSP install
74: l_last_computation_Date := l_service_line_start_date;
75: end if;

Line 153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

149:
150: BEGIN
151:
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

Line 154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';

150: BEGIN
151:
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
158:

Line 155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

151:
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
158:
159: if l_last_computation_date is null then -- For 1st run of fresh LSP install

Line 156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
158:
159: if l_last_computation_date is null then -- For 1st run of fresh LSP install
160: l_last_computation_Date := l_service_line_start_date;

Line 157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
157: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
158:
159: if l_last_computation_date is null then -- For 1st run of fresh LSP install
160: l_last_computation_Date := l_service_line_start_date;
161: end if;

Line 239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

235:
236: BEGIN
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

Line 240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';

236: BEGIN
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
244:

Line 241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
244:
245: if l_last_computation_date is null then -- For 1st run of fresh LSP install

Line 242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
244:
245: if l_last_computation_date is null then -- For 1st run of fresh LSP install
246: l_last_computation_Date := l_service_line_start_date;

Line 243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
243: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
244:
245: if l_last_computation_date is null then -- For 1st run of fresh LSP install
246: l_last_computation_Date := l_service_line_start_date;
247: end if;

Line 353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;

349:
350: debug('Starting of INV 3PL qty received ');
351:
352: x_return_status := fnd_api.g_ret_sts_success;
353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

Line 354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

350: debug('Starting of INV 3PL qty received ');
351:
352: x_return_status := fnd_api.g_ret_sts_success;
353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

Line 355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

351:
352: x_return_status := fnd_api.g_ret_sts_success;
353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

Line 356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;

352: x_return_status := fnd_api.g_ret_sts_success;
353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
360:

Line 357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
360:
361:

Line 358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
360:
361:
362: if l_last_computation_date is null then -- For 1st run of fresh LSP install

Line 359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;
357: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
358: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
359: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
360:
361:
362: if l_last_computation_date is null then -- For 1st run of fresh LSP install
363: l_last_computation_Date := l_service_line_start_date;

Line 465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

461:
462: BEGIN
463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

Line 466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';

462: BEGIN
463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
470:

Line 467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
470:
471: if l_last_computation_date is null then -- For 1st run of fresh LSP install

Line 468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
470:
471: if l_last_computation_date is null then -- For 1st run of fresh LSP install
472: l_last_computation_Date := l_service_line_start_date;

Line 469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;

465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --
469: l_service_line_start_date := INV_3PL_BILLING_PUB.g_billing_source_rec.service_line_start_date;
470:
471: if l_last_computation_date is null then -- For 1st run of fresh LSP install
472: l_last_computation_Date := l_service_line_start_date;
473: end if;

Line 565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

561:
562: BEGIN
563:
564: x_return_status := fnd_api.g_ret_sts_success;
565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

Line 566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

562: BEGIN
563:
564: x_return_status := fnd_api.g_ret_sts_success;
565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
570:

Line 567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

563:
564: x_return_status := fnd_api.g_ret_sts_success;
565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
570:
571: debug('Entered INV_3PL_SEEDED_SOURCES.capacity_number_of_days ');

Line 568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

564: x_return_status := fnd_api.g_ret_sts_success;
565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
570:
571: debug('Entered INV_3PL_SEEDED_SOURCES.capacity_number_of_days ');
572: debug('Got the values client_code => '|| l_client_code);

Line 569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
569: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
570:
571: debug('Entered INV_3PL_SEEDED_SOURCES.capacity_number_of_days ');
572: debug('Got the values client_code => '|| l_client_code);
573: debug('Got the values l_source_to_date => '|| l_source_to_date);

Line 716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

712:
713: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized initial');
714:
715: x_return_status := fnd_api.g_ret_sts_success;
716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

Line 717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

713: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized initial');
714:
715: x_return_status := fnd_api.g_ret_sts_success;
716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

Line 718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

714:
715: x_return_status := fnd_api.g_ret_sts_success;
716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
722:

Line 719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

715: x_return_status := fnd_api.g_ret_sts_success;
716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
722:
723: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized ');

Line 720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
722:
723: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized ');
724: debug('Got the values client_code => '|| l_client_code);

Line 721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
720: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
721: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
722:
723: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized ');
724: debug('Got the values client_code => '|| l_client_code);
725: debug('Got the values l_source_to_date => '|| l_source_to_date);

Line 907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';

903:
904: debug('Entered INV_3PL_SEEDED_SOURCES.area_utlized initial');
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

Line 908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

904: debug('Entered INV_3PL_SEEDED_SOURCES.area_utlized initial');
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

Line 909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;

905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
913:

Line 910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

906: x_return_status := fnd_api.g_ret_sts_success;
907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
913:
914: debug('Entered INV_3PL_SEEDED_SOURCES.area_utilized ');

Line 911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;

907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
913:
914: debug('Entered INV_3PL_SEEDED_SOURCES.area_utilized ');
915: debug('Got the values client_code => '|| l_client_code);

Line 912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;

908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
911: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit;
912: l_billing_uom := INV_3PL_BILLING_PUB.g_billing_source_rec.billing_uom;
913:
914: debug('Entered INV_3PL_SEEDED_SOURCES.area_utilized ');
915: debug('Got the values client_code => '|| l_client_code);
916: debug('Got the values l_source_to_date => '|| l_source_to_date);