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 1077: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

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

1236: result out nocopy varchar2 ) is
1237:
1238: l_sub_role Varchar2(100);
1239:
1240: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1241: Begin
1242: if (funcmode = 'RUN') then
1243:
1244: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1279: result out nocopy varchar2 ) is
1280:
1281: l_sub_role Varchar2(100);
1282:
1283: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1284: Begin
1285: if (funcmode = 'RUN') then
1286:
1287: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

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

1320: itemkey in varchar2,
1321: actid in number,
1322: command in varchar2,
1323: result out nocopy varchar2 ) is
1324: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1325: Begin
1326: If ( command = 'RUN' ) then
1327: result := 'APPROVE_TRANSFER_ORDER';
1328: return;