DBA Data[Home] [Help]

APPS.INV_3PL_SEEDED_SOURCES dependencies on INV_3PL_SEEDED_SOURCES

Line 1: PACKAGE BODY INV_3PL_SEEDED_SOURCES AS

1: PACKAGE BODY INV_3PL_SEEDED_SOURCES AS
2: /* $Header: INVSSRCB.pls 120.1 2010/05/26 09:11:20 damahaja noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_SEEDED_SOURCES';
5: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_SEEDED_SOURCES';

1: PACKAGE BODY INV_3PL_SEEDED_SOURCES AS
2: /* $Header: INVSSRCB.pls 120.1 2010/05/26 09:11:20 damahaja noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_SEEDED_SOURCES';
5: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6:
7:
8: PROCEDURE debug(

Line 77: debug('Entered INV_3PL_SEEDED_SOURCES.number_receive_transactions ');

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;
76:
77: debug('Entered INV_3PL_SEEDED_SOURCES.number_receive_transactions ');
78: debug('Got the values client_code => '|| l_client_code);
79: debug('Got the values l_source_to_date => '|| l_source_to_date);
80: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
81: debug('For client => '||l_client_code);

Line 163: debug('Entered INV_3PL_SEEDED_SOURCES.number_shipment_lines ');

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;
162:
163: debug('Entered INV_3PL_SEEDED_SOURCES.number_shipment_lines ');
164: debug('Got the values client_code => '|| l_client_code);
165: debug('Got the values l_source_to_date => '|| l_source_to_date);
166: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
167: debug('For client => '||l_client_code);

Line 249: debug('Entered INV_3PL_SEEDED_SOURCES.number_picking_transactions1 ');

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;
248:
249: debug('Entered INV_3PL_SEEDED_SOURCES.number_picking_transactions1 ');
250: debug('Got the values client_code => '|| l_client_code);
251: debug('Got the values l_source_to_date => '|| l_source_to_date);
252: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
253: debug('For client => '||l_client_code);

Line 366: debug('Entered INV_3PL_SEEDED_SOURCES.qty_receiving_transactions ');

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;
364: end if;
365:
366: debug('Entered INV_3PL_SEEDED_SOURCES.qty_receiving_transactions ');
367: debug('Got the values client_code => '|| l_client_code);
368: debug('Got the values l_source_to_date => '|| l_source_to_date);
369: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
370: debug(' l_billing_uom => '|| l_billing_uom);

Line 475: debug('Entered INV_3PL_SEEDED_SOURCES.number_putaway_transactions ');

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;
474:
475: debug('Entered INV_3PL_SEEDED_SOURCES.number_putaway_transactions ');
476: debug('Got the values client_code => '|| l_client_code);
477: debug('Got the values l_source_to_date => '|| l_source_to_date);
478: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
479:

Line 571: debug('Entered INV_3PL_SEEDED_SOURCES.capacity_number_of_days ');

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);
574: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
575:

Line 713: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized initial');

709: l_applid NUMBER;
710:
711: BEGIN
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;

Line 723: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized ');

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);
726: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
727:

Line 904: debug('Entered INV_3PL_SEEDED_SOURCES.area_utlized initial');

900: l_applid NUMBER;
901:
902: BEGIN
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;

Line 914: debug('Entered INV_3PL_SEEDED_SOURCES.area_utilized ');

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);
917: debug('Got the values l_last_computation_date => '|| l_last_computation_date);
918:

Line 1134: END INV_3PL_SEEDED_SOURCES;

1130: rollback to process_locator;
1131:
1132: END get_area_for_locator;
1133:
1134: END INV_3PL_SEEDED_SOURCES;