eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on FND_GLOBAL

Line 590: WHERE USER_ID = FND_GLOBAL.USER_ID;

586:
587: SELECT user_name
588: INTO l_owner_role
589: FROM FND_USER
590: WHERE USER_ID = FND_GLOBAL.USER_ID;
591: -- Create Header Work item
592: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR,to_char(p_header_rec.header_id),
593: l_hdr_process_name,
594: sales_order,

Line 606: l_avalue(1) := FND_GLOBAL.USER_ID;

602: END IF;
603:
604: -- Set various Header Attributes
605: l_aname(1) := 'USER_ID';
606: l_avalue(1) := FND_GLOBAL.USER_ID;
607: l_aname(2) := 'APPLICATION_ID';
608: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
609: l_aname(3) := 'RESPONSIBILITY_ID';
610: l_avalue(3) := FND_GLOBAL.RESP_ID;

Line 608: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;

604: -- Set various Header Attributes
605: l_aname(1) := 'USER_ID';
606: l_avalue(1) := FND_GLOBAL.USER_ID;
607: l_aname(2) := 'APPLICATION_ID';
608: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
609: l_aname(3) := 'RESPONSIBILITY_ID';
610: l_avalue(3) := FND_GLOBAL.RESP_ID;
611: l_aname(4) := 'ORG_ID';
612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

Line 610: l_avalue(3) := FND_GLOBAL.RESP_ID;

606: l_avalue(1) := FND_GLOBAL.USER_ID;
607: l_aname(2) := 'APPLICATION_ID';
608: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
609: l_aname(3) := 'RESPONSIBILITY_ID';
610: l_avalue(3) := FND_GLOBAL.RESP_ID;
611: l_aname(4) := 'ORG_ID';
612: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
613: l_aname(5) := 'ORDER_NUMBER';
614: l_avalue(5) := p_header_rec.order_number;

Line 627: where user_id = FND_GLOBAL.USER_ID;

623: BEGIN
624: select user_name
625: into l_user_name
626: from fnd_user
627: where user_id = FND_GLOBAL.USER_ID;
628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: l_user_name := null; -- do not set FROM_ROLE then

Line 817: WHERE USER_ID = FND_GLOBAL.USER_ID;

813:
814: SELECT user_name
815: INTO l_owner_role
816: FROM FND_USER
817: WHERE USER_ID = FND_GLOBAL.USER_ID;
818:
819: -- Create Line Work item
820: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN,to_char(p_Line_rec.line_id),
821: l_line_process_name,

Line 833: l_avalue(1) := FND_GLOBAL.USER_ID;

829:
830:
831: -- Set various Line Attributes
832: l_aname(1) := 'USER_ID';
833: l_avalue(1) := FND_GLOBAL.USER_ID;
834: l_aname(2) := 'APPLICATION_ID';
835: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
836: l_aname(3) := 'RESPONSIBILITY_ID';
837: l_avalue(3) := FND_GLOBAL.RESP_ID;

Line 835: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;

831: -- Set various Line Attributes
832: l_aname(1) := 'USER_ID';
833: l_avalue(1) := FND_GLOBAL.USER_ID;
834: l_aname(2) := 'APPLICATION_ID';
835: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
836: l_aname(3) := 'RESPONSIBILITY_ID';
837: l_avalue(3) := FND_GLOBAL.RESP_ID;
838: l_aname(4) := 'ORG_ID';
839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

Line 837: l_avalue(3) := FND_GLOBAL.RESP_ID;

833: l_avalue(1) := FND_GLOBAL.USER_ID;
834: l_aname(2) := 'APPLICATION_ID';
835: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
836: l_aname(3) := 'RESPONSIBILITY_ID';
837: l_avalue(3) := FND_GLOBAL.RESP_ID;
838: l_aname(4) := 'ORG_ID';
839: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
840:
841: wf_engine.SetItemAttrNumberArray( OE_GLOBALS.G_WFI_LIN

Line 1863: last_updated_by = FND_GLOBAL.USER_ID,

1859:
1860: UPDATE OE_ORDER_LINES_ALL
1861: SET FLOW_STATUS_CODE = p_flow_status_code,
1862: last_update_date = SYSDATE,
1863: last_updated_by = FND_GLOBAL.USER_ID,
1864: last_update_login = FND_GLOBAL.LOGIN_ID,
1865: LOCK_CONTROL = LOCK_CONTROL + 1
1866: WHERE LINE_ID = p_line_id;
1867:

Line 1864: last_update_login = FND_GLOBAL.LOGIN_ID,

1860: UPDATE OE_ORDER_LINES_ALL
1861: SET FLOW_STATUS_CODE = p_flow_status_code,
1862: last_update_date = SYSDATE,
1863: last_updated_by = FND_GLOBAL.USER_ID,
1864: last_update_login = FND_GLOBAL.LOGIN_ID,
1865: LOCK_CONTROL = LOCK_CONTROL + 1
1866: WHERE LINE_ID = p_line_id;
1867:
1868: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

Line 2868: WHERE USER_ID = FND_GLOBAL.USER_ID;

2864:
2865: SELECT user_name
2866: INTO l_owner_role
2867: FROM FND_USER
2868: WHERE USER_ID = FND_GLOBAL.USER_ID;
2869:
2870: -- Create Header Work item
2871: WF_ENGINE.CreateProcess(p_item_type,
2872: to_char(p_header_id),

Line 2884: l_avalue(1) := FND_GLOBAL.USER_ID;

2880: END IF;
2881:
2882: -- Set various Header Attributes
2883: l_aname(1) := 'USER_ID';
2884: l_avalue(1) := FND_GLOBAL.USER_ID;
2885: l_aname(2) := 'APPLICATION_ID';
2886: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
2887: l_aname(3) := 'RESPONSIBILITY_ID';
2888: l_avalue(3) := FND_GLOBAL.RESP_ID;

Line 2886: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;

2882: -- Set various Header Attributes
2883: l_aname(1) := 'USER_ID';
2884: l_avalue(1) := FND_GLOBAL.USER_ID;
2885: l_aname(2) := 'APPLICATION_ID';
2886: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
2887: l_aname(3) := 'RESPONSIBILITY_ID';
2888: l_avalue(3) := FND_GLOBAL.RESP_ID;
2889: l_aname(4) := 'ORG_ID';
2890: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);

Line 2888: l_avalue(3) := FND_GLOBAL.RESP_ID;

2884: l_avalue(1) := FND_GLOBAL.USER_ID;
2885: l_aname(2) := 'APPLICATION_ID';
2886: l_avalue(2) := FND_GLOBAL.RESP_APPL_ID;
2887: l_aname(3) := 'RESPONSIBILITY_ID';
2888: l_avalue(3) := FND_GLOBAL.RESP_ID;
2889: l_aname(4) := 'ORG_ID';
2890: l_avalue(4) := to_number(OE_GLOBALS.G_ORG_ID);
2891: l_aname(5) := 'TRANSACTION_NUMBER';
2892: l_avalue(5) := p_transaction_number;

Line 2910: where user_id = FND_GLOBAL.USER_ID;

2906: BEGIN
2907: select user_name
2908: into l_user_name
2909: from fnd_user
2910: where user_id = FND_GLOBAL.USER_ID;
2911:
2912: EXCEPTION
2913: WHEN OTHERS THEN
2914: l_user_name := null; -- do not set FROM_ROLE then

Line 3143: NLCHAR VARCHAR2(2) := FND_GLOBAL.Newline;

3139: NL VARCHAR2(1) := '';
3140: i number := 0;
3141:
3142: -- New Line char.
3143: NLCHAR VARCHAR2(2) := FND_GLOBAL.Newline;
3144:
3145: -- fnd messages
3146: l_msg_BSA VARCHAR2(240);
3147: l_msg_creation_date VARCHAR2(240);

Line 3404: NLCHAR VARCHAR2(2) := FND_GLOBAL.Newline;

3400: i number := 0;
3401: l_url VARCHAR2(1000);
3402:
3403: -- New Line char.
3404: NLCHAR VARCHAR2(2) := FND_GLOBAL.Newline;
3405:
3406: -- FND msg titles
3407: l_msg_creation_date VARCHAR2(240);
3408: l_msg_salesperson VARCHAR2(240);