DBA Data[Home] [Help]

APPS.INVTROAP dependencies on FND_PROFILE

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

16: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
17: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
18: l_timeout_period number;
19: l_timeout_action number;
20: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
21: Begin
22:
23: /* To Defer the process from the start */
24:

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

201: result out nocopy varchar2 ) is
202: p_header_id Number;
203: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
204:
205: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
206: Begin
207: if (funcmode = 'RUN') then
208:
209: p_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

272: From_locator_value varchar2(200);
273: to_locator_value varchar2(200);
274:
275:
276: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
277: Begin
278: if (funcmode = 'RUN') then
279:
280: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

500: l_lines_approved Number := 0;
501: l_lines_rejected Number := 0;
502: l_total_lines Number := 0;
503:
504: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
505: Begin
506:
507: if ( funcmode = 'RUN') then
508:

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

558: actid in number,
559: funcmode in varchar2,
560: result out nocopy varchar2 ) is
561: l_header_id Number;
562: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
563: Begin
564: if (funcmode = 'RUN') then
565: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
566: itemkey => itemkey,

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

593: actid in number,
594: funcmode in varchar2,
595: result out nocopy varchar2 ) is
596: l_header_id Number;
597: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
598: Begin
599: if (funcmode = 'RUN') then
600: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
601: itemkey => itemkey,

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

630: actid in number,
631: funcmode in varchar2,
632: result out nocopy varchar2 ) is
633: l_header_id Number;
634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
635: Begin
636: if (funcmode = 'RUN') then
637:
638: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

676: --l_item_name Varchar2(40);
677: l_item_name Varchar2(4000); --changed the size to 4000 for holding Concatenetaed Segments for Bug# 6936609
678: l_item_description MTL_SYSTEM_ITEMS_B.DESCRIPTION%TYPE; -- Added for Bug# 4148672
679:
680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
681: Begin
682: if (funcmode = 'RUN') then
683:
684: l_item_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

769: l_planner_id Number;
770: x_planner_username varchar2(30);
771: x_planner_disp_name varchar2(80);
772:
773: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
774: Begin
775: if (funcmode = 'RUN') then
776:
777: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

859: result out nocopy varchar2 ) is
860: l_org_id Number;
861: l_timeout_action Number;
862:
863: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
864: Begin
865: if (funcmode = 'RUN') then
866: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
867: itemkey => itemkey,

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

903: actid in number,
904: funcmode in varchar2,
905: result out nocopy varchar2 ) is
906: l_Line_id Number;
907: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
908: l_line_status NUMBER;
909:
910: Begin
911: if (funcmode = 'RUN') then

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

952: actid in number,
953: funcmode in varchar2,
954: result out nocopy varchar2 ) is
955: l_Line_id Number ;
956: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
957: l_line_status NUMBER;
958: Begin
959: if (funcmode = 'RUN') then
960:

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

1002: l_org_id Number;
1003: l_timeout_period Number;
1004: l_mfg_cal_date Date;
1005:
1006: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1007: Begin
1008: if (funcmode = 'RUN') then
1009:
1010: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

1074: From_locator_value Varchar2(200);
1075: To_locator_value Varchar2(200);
1076: l_planner_code Varchar2(10); --bug9315598
1077:
1078: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1079: Begin
1080: if (funcmode = 'RUN') then
1081:
1082: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

1262: result out nocopy varchar2 ) is
1263:
1264: l_sub_role Varchar2(100);
1265:
1266: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1267: Begin
1268: if (funcmode = 'RUN') then
1269:
1270: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1305: result out nocopy varchar2 ) is
1306:
1307: l_sub_role Varchar2(100);
1308:
1309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1310: Begin
1311: if (funcmode = 'RUN') then
1312:
1313: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1346: itemkey in varchar2,
1347: actid in number,
1348: command in varchar2,
1349: result out nocopy varchar2 ) is
1350: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1351: Begin
1352: If ( command = 'RUN' ) then
1353: result := 'APPROVE_TRANSFER_ORDER';
1354: return;