DBA Data[Home] [Help]

APPS.INV_VALUE_TO_ID dependencies on FND_PROFILE

Line 18: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

14:
15: PROCEDURE Get_Attr_Tbl
16: IS
17: I NUMBER:=0;
18: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19: BEGIN
20:
21: FND_API.g_attr_tbl.DELETE;
22:

Line 84: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

80: RETURN NUMBER
81: IS
82: l_id NUMBER;
83: l_segment_array FND_FLEX_EXT.SegmentArray;
84: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
85: BEGIN
86:
87: l_segment_array := p_segment_array;
88:

Line 150: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

146: p_from_subinventory IN VARCHAR2
147: ) RETURN VARCHAR2
148: IS
149: l_code VARCHAR2(10);
150: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
151: BEGIN
152:
153: l_code := p_from_subinventory;
154: RETURN l_code;

Line 165: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

161: ( p_header IN VARCHAR2
162: ) RETURN NUMBER
163: IS
164: l_id NUMBER;
165: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
166: BEGIN
167:
168: IF p_header IS NULL
169: THEN

Line 216: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

212: ( p_organization IN VARCHAR2
213: ) RETURN NUMBER
214: IS
215: l_id NUMBER;
216: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
217: BEGIN
218:
219: IF p_organization IS NULL
220: OR p_organization = FND_API.G_MISS_CHAR

Line 266: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

262: ( p_to_organization IN VARCHAR2
263: ) RETURN NUMBER
264: IS
265: l_id NUMBER;
266: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
267: BEGIN
268:
269: IF p_to_organization IS NULL
270: OR p_to_organization = FND_API.G_MISS_CHAR

Line 386: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

382: p_to_subinventory IN VARCHAR2
383: ) RETURN VARCHAR2
384: IS
385: l_code VARCHAR2(10);
386: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
387: BEGIN
388:
389: l_code := p_to_subinventory;
390: RETURN l_code;

Line 401: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

397: ( p_transaction_type IN VARCHAR2
398: ) RETURN NUMBER
399: IS
400: l_id NUMBER;
401: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
402: BEGIN
403:
404: IF p_transaction_type IS NULL
405: THEN

Line 452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

448: ( p_move_order_type IN VARCHAR2
449: ) RETURN NUMBER
450: IS
451: l_id NUMBER;
452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
453: BEGIN
454:
455: IF p_move_order_type IS NULL
456: THEN

Line 504: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

500: p_from_locator IN VARCHAR2
501: ) RETURN NUMBER
502: IS
503: l_id NUMBER;
504: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
505: BEGIN
506:
507: IF p_from_locator IS NULL
508: OR p_from_locator = FND_API.G_MISS_CHAR

Line 558: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

554: p_inventory_item IN VARCHAR2
555: ) RETURN NUMBER
556: IS
557: l_id NUMBER;
558: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
559: BEGIN
560:
561: IF p_inventory_item IS NULL
562: OR p_inventory_item = FND_API.G_MISS_CHAR

Line 610: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

606: ( p_line IN VARCHAR2
607: ) RETURN NUMBER
608: IS
609: l_id NUMBER;
610: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
611: BEGIN
612:
613: IF p_line IS NULL
614: THEN

Line 661: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

657: ( p_project IN VARCHAR2
658: ) RETURN NUMBER
659: IS
660: l_id NUMBER;
661: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
662: BEGIN
663:
664: IF p_project IS NULL
665: THEN

Line 712: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

708: ( p_reason IN VARCHAR2
709: ) RETURN NUMBER
710: IS
711: l_id NUMBER;
712: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
713: BEGIN
714:
715: IF p_reason IS NULL
716: THEN

Line 763: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

759: ( p_reference IN VARCHAR2
760: ) RETURN NUMBER
761: IS
762: l_id NUMBER;
763: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
764: BEGIN
765:
766: IF p_reference IS NULL
767: THEN

Line 814: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

810: ( p_reference_type IN VARCHAR2
811: ) RETURN NUMBER
812: IS
813: l_id NUMBER;
814: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
815: BEGIN
816:
817: IF p_reference_type IS NULL
818: THEN

Line 865: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

861: ( p_task IN VARCHAR2
862: ) RETURN NUMBER
863: IS
864: l_id NUMBER;
865: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
866: BEGIN
867:
868: IF p_task IS NULL
869: THEN

Line 917: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

913: p_to_locator IN VARCHAR2
914: ) RETURN NUMBER
915: IS
916: l_id NUMBER;
917: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
918: BEGIN
919:
920: IF p_to_locator IS NULL
921: OR p_to_locator = FND_API.G_MISS_CHAR

Line 969: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

965: ( p_transaction_header IN VARCHAR2
966: ) RETURN NUMBER
967: IS
968: l_id NUMBER;
969: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
970: BEGIN
971:
972: IF p_transaction_header IS NULL
973: THEN

Line 1020: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1016: ( p_uom IN VARCHAR2
1017: ) RETURN VARCHAR2
1018: IS
1019: l_code VARCHAR2(3);
1020: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1021: BEGIN
1022:
1023: IF p_uom IS NULL
1024: THEN