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.

APPS.OE_ORDER_WF_UTIL dependencies on FND_GLOBAL

Line 683: WHERE user_id = fnd_global.user_id;

679:
680: SELECT user_name
681: INTO l_owner_role
682: FROM fnd_user
683: WHERE user_id = fnd_global.user_id;
684:
685: -- Create Header Work item
686: wf_engine.createprocess (oe_globals.g_wfi_hdr,
687: TO_CHAR (p_header_rec.header_id),

Line 706: l_avalue (1) := fnd_global.user_id;

702: END IF;
703:
704: -- Set various Header Attributes
705: l_aname (1) := 'USER_ID';
706: l_avalue (1) := fnd_global.user_id;
707: l_aname (2) := 'APPLICATION_ID';
708: l_avalue (2) := fnd_global.resp_appl_id;
709: l_aname (3) := 'RESPONSIBILITY_ID';
710: l_avalue (3) := fnd_global.resp_id;

Line 708: l_avalue (2) := fnd_global.resp_appl_id;

704: -- Set various Header Attributes
705: l_aname (1) := 'USER_ID';
706: l_avalue (1) := fnd_global.user_id;
707: l_aname (2) := 'APPLICATION_ID';
708: l_avalue (2) := fnd_global.resp_appl_id;
709: l_aname (3) := 'RESPONSIBILITY_ID';
710: l_avalue (3) := fnd_global.resp_id;
711: l_aname (4) := 'ORG_ID';
712: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);

Line 710: l_avalue (3) := fnd_global.resp_id;

706: l_avalue (1) := fnd_global.user_id;
707: l_aname (2) := 'APPLICATION_ID';
708: l_avalue (2) := fnd_global.resp_appl_id;
709: l_aname (3) := 'RESPONSIBILITY_ID';
710: l_avalue (3) := fnd_global.resp_id;
711: l_aname (4) := 'ORG_ID';
712: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);
713: l_aname (5) := 'ORDER_NUMBER';
714: l_avalue (5) := p_header_rec.order_number;

Line 726: WHERE user_id = fnd_global.user_id;

722: BEGIN
723: SELECT user_name
724: INTO l_user_name
725: FROM fnd_user
726: WHERE user_id = fnd_global.user_id;
727: EXCEPTION
728: WHEN OTHERS
729: THEN
730: l_user_name := NULL; -- do not set FROM_ROLE then

Line 934: WHERE user_id = fnd_global.user_id;

930:
931: SELECT user_name
932: INTO l_owner_role
933: FROM fnd_user
934: WHERE user_id = fnd_global.user_id;
935:
936: -- Create Line Work item
937: wf_engine.createprocess (oe_globals.g_wfi_lin,
938: TO_CHAR (p_line_rec.line_id),

Line 951: l_avalue (1) := fnd_global.user_id;

947: END IF;
948:
949: -- Set various Line Attributes
950: l_aname (1) := 'USER_ID';
951: l_avalue (1) := fnd_global.user_id;
952: l_aname (2) := 'APPLICATION_ID';
953: l_avalue (2) := fnd_global.resp_appl_id;
954: l_aname (3) := 'RESPONSIBILITY_ID';
955: l_avalue (3) := fnd_global.resp_id;

Line 953: l_avalue (2) := fnd_global.resp_appl_id;

949: -- Set various Line Attributes
950: l_aname (1) := 'USER_ID';
951: l_avalue (1) := fnd_global.user_id;
952: l_aname (2) := 'APPLICATION_ID';
953: l_avalue (2) := fnd_global.resp_appl_id;
954: l_aname (3) := 'RESPONSIBILITY_ID';
955: l_avalue (3) := fnd_global.resp_id;
956: l_aname (4) := 'ORG_ID';
957: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);

Line 955: l_avalue (3) := fnd_global.resp_id;

951: l_avalue (1) := fnd_global.user_id;
952: l_aname (2) := 'APPLICATION_ID';
953: l_avalue (2) := fnd_global.resp_appl_id;
954: l_aname (3) := 'RESPONSIBILITY_ID';
955: l_avalue (3) := fnd_global.resp_id;
956: l_aname (4) := 'ORG_ID';
957: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);
958: wf_engine.setitemattrnumberarray (oe_globals.g_wfi_lin,
959: p_line_rec.line_id,

Line 1844: last_updated_by = fnd_global.user_id,

1840: SET flow_status_code = p_flow_status_code
1841: --Bug 8435596
1842: ,
1843: last_update_date = SYSDATE,
1844: last_updated_by = fnd_global.user_id,
1845: last_update_login = fnd_global.login_id,
1846: lock_control = lock_control + 1
1847: WHERE header_id = p_header_id;
1848:

Line 1845: last_update_login = fnd_global.login_id,

1841: --Bug 8435596
1842: ,
1843: last_update_date = SYSDATE,
1844: last_updated_by = fnd_global.user_id,
1845: last_update_login = fnd_global.login_id,
1846: lock_control = lock_control + 1
1847: WHERE header_id = p_header_id;
1848:
1849: -- Also update all lines to have the same flow_status_code for quotes

Line 1866: last_updated_by = fnd_global.user_id,

1862: SET flow_status_code = p_flow_status_code
1863: --Bug 8435596
1864: ,
1865: last_update_date = SYSDATE,
1866: last_updated_by = fnd_global.user_id,
1867: last_update_login = fnd_global.login_id,
1868: lock_control = lock_control + 1
1869: WHERE header_id = p_header_id;
1870:

Line 1867: last_update_login = fnd_global.login_id,

1863: --Bug 8435596
1864: ,
1865: last_update_date = SYSDATE,
1866: last_updated_by = fnd_global.user_id,
1867: last_update_login = fnd_global.login_id,
1868: lock_control = lock_control + 1
1869: WHERE header_id = p_header_id;
1870:
1871: l_header_rec.flow_status_code := p_flow_status_code;

Line 2022: last_updated_by = fnd_global.user_id,

2018: SET flow_status_code = p_flow_status_code
2019: --Bug 8435596
2020: ,
2021: last_update_date = SYSDATE,
2022: last_updated_by = fnd_global.user_id,
2023: lock_control = lock_control + 1
2024: WHERE header_id = p_header_id;
2025: END IF; --check sales_document_type_code
2026: ELSIF p_item_type = oe_globals.g_wfi_bkt

Line 2062: last_updated_by = fnd_global.user_id,

2058: SET flow_status_code = p_flow_status_code
2059: --Bug 8435596
2060: ,
2061: last_update_date = SYSDATE,
2062: last_updated_by = fnd_global.user_id,
2063: last_update_login = fnd_global.login_id,
2064: lock_control = lock_control + 1
2065: WHERE header_id = p_header_id;
2066: END IF;

Line 2063: last_update_login = fnd_global.login_id,

2059: --Bug 8435596
2060: ,
2061: last_update_date = SYSDATE,
2062: last_updated_by = fnd_global.user_id,
2063: last_update_login = fnd_global.login_id,
2064: lock_control = lock_control + 1
2065: WHERE header_id = p_header_id;
2066: END IF;
2067: END IF; -- p_header_id is not null

Line 2197: --last_updated_by = FND_GLOBAL.USER_ID,

2193: THEN
2194: UPDATE oe_order_lines_all
2195: SET flow_status_code = p_flow_status_code,
2196: last_update_date = SYSDATE,
2197: --last_updated_by = FND_GLOBAL.USER_ID,
2198: last_updated_by =
2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),
2200: -- For bug 9386040
2201: last_update_login = fnd_global.login_id,

Line 2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),

2195: SET flow_status_code = p_flow_status_code,
2196: last_update_date = SYSDATE,
2197: --last_updated_by = FND_GLOBAL.USER_ID,
2198: last_updated_by =
2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),
2200: -- For bug 9386040
2201: last_update_login = fnd_global.login_id,
2202: lock_control = lock_control + 1
2203: WHERE line_id = p_line_id;

Line 2201: last_update_login = fnd_global.login_id,

2197: --last_updated_by = FND_GLOBAL.USER_ID,
2198: last_updated_by =
2199: NVL (oe_standard_wf.g_user_id, fnd_global.user_id),
2200: -- For bug 9386040
2201: last_update_login = fnd_global.login_id,
2202: lock_control = lock_control + 1
2203: WHERE line_id = p_line_id;
2204:
2205: IF (l_debug_level > 0)

Line 2481: last_updated_by = fnd_global.user_id,

2477: SET flow_status_code = p_flow_status_code
2478: --Bug 8435596
2479: ,
2480: last_update_date = SYSDATE,
2481: last_updated_by = fnd_global.user_id,
2482: last_update_login = fnd_global.login_id,
2483: lock_control = lock_control + 1
2484: WHERE header_id = p_header_id;
2485:

Line 2482: last_update_login = fnd_global.login_id,

2478: --Bug 8435596
2479: ,
2480: last_update_date = SYSDATE,
2481: last_updated_by = fnd_global.user_id,
2482: last_update_login = fnd_global.login_id,
2483: lock_control = lock_control + 1
2484: WHERE header_id = p_header_id;
2485:
2486: l_header_rec.flow_status_code := p_flow_status_code;

Line 3003: last_updated_by = fnd_global.user_id,

2999: SET flow_status_code = p_flow_status_code
3000: --Bug 8435596
3001: ,
3002: last_update_date = SYSDATE,
3003: last_updated_by = fnd_global.user_id,
3004: last_update_login = fnd_global.login_id
3005: WHERE header_id = l_header_id;
3006:
3007: -- Also update all lines to have the same flow_status_code

Line 3004: last_update_login = fnd_global.login_id

3000: --Bug 8435596
3001: ,
3002: last_update_date = SYSDATE,
3003: last_updated_by = fnd_global.user_id,
3004: last_update_login = fnd_global.login_id
3005: WHERE header_id = l_header_id;
3006:
3007: -- Also update all lines to have the same flow_status_code
3008: OPEN lines;

Line 3024: last_updated_by = fnd_global.user_id,

3020: SET flow_status_code = p_flow_status_code
3021: --Bug 8435596
3022: ,
3023: last_update_date = SYSDATE,
3024: last_updated_by = fnd_global.user_id,
3025: last_update_login = fnd_global.login_id,
3026: lock_control = lock_control + 1
3027: WHERE header_id = l_header_id;
3028:

Line 3025: last_update_login = fnd_global.login_id,

3021: --Bug 8435596
3022: ,
3023: last_update_date = SYSDATE,
3024: last_updated_by = fnd_global.user_id,
3025: last_update_login = fnd_global.login_id,
3026: lock_control = lock_control + 1
3027: WHERE header_id = l_header_id;
3028:
3029: l_updated_flag := 'Y';

Line 3039: last_updated_by = fnd_global.user_id,

3035: UPDATE oe_order_headers_all
3036: SET open_flag = p_open_flag,
3037: -- Bug 12849250
3038: last_update_date = SYSDATE,
3039: last_updated_by = fnd_global.user_id,
3040: last_update_login = fnd_global.login_id
3041: WHERE header_id = l_header_id;
3042:
3043: l_updated_flag := 'Y';

Line 3040: last_update_login = fnd_global.login_id

3036: SET open_flag = p_open_flag,
3037: -- Bug 12849250
3038: last_update_date = SYSDATE,
3039: last_updated_by = fnd_global.user_id,
3040: last_update_login = fnd_global.login_id
3041: WHERE header_id = l_header_id;
3042:
3043: l_updated_flag := 'Y';
3044: l_header_rec.open_flag := p_open_flag;

Line 3051: last_updated_by = fnd_global.user_id,

3047: UPDATE oe_order_lines_all
3048: SET open_flag = p_open_flag,
3049: -- Bug 12849250
3050: last_update_date = SYSDATE,
3051: last_updated_by = fnd_global.user_id,
3052: last_update_login = fnd_global.login_id
3053: WHERE header_id = l_header_id;
3054: -- XDING bug FP5172433
3055: END IF;

Line 3052: last_update_login = fnd_global.login_id

3048: SET open_flag = p_open_flag,
3049: -- Bug 12849250
3050: last_update_date = SYSDATE,
3051: last_updated_by = fnd_global.user_id,
3052: last_update_login = fnd_global.login_id
3053: WHERE header_id = l_header_id;
3054: -- XDING bug FP5172433
3055: END IF;
3056:

Line 3063: last_updated_by = fnd_global.user_id,

3059: UPDATE oe_order_headers_all
3060: SET draft_submitted_flag = p_draft_submitted_flag,
3061: -- Bug 12849250
3062: last_update_date = SYSDATE,
3063: last_updated_by = fnd_global.user_id,
3064: last_update_login = fnd_global.login_id
3065: WHERE header_id = l_header_id;
3066:
3067: l_updated_flag := 'Y';

Line 3064: last_update_login = fnd_global.login_id

3060: SET draft_submitted_flag = p_draft_submitted_flag,
3061: -- Bug 12849250
3062: last_update_date = SYSDATE,
3063: last_updated_by = fnd_global.user_id,
3064: last_update_login = fnd_global.login_id
3065: WHERE header_id = l_header_id;
3066:
3067: l_updated_flag := 'Y';
3068: l_header_rec.draft_submitted_flag := p_draft_submitted_flag;

Line 3241: last_updated_by = fnd_global.user_id,

3237: SET flow_status_code = p_flow_status_code
3238: --Bug 8435596
3239: ,
3240: last_update_date = SYSDATE,
3241: last_updated_by = fnd_global.user_id,
3242: last_update_login = fnd_global.login_id
3243: WHERE header_id = l_header_id;
3244:
3245: l_updated_flag := 'Y';

Line 3242: last_update_login = fnd_global.login_id

3238: --Bug 8435596
3239: ,
3240: last_update_date = SYSDATE,
3241: last_updated_by = fnd_global.user_id,
3242: last_update_login = fnd_global.login_id
3243: WHERE header_id = l_header_id;
3244:
3245: l_updated_flag := 'Y';
3246: END IF;

Line 3254: last_updated_by = fnd_global.user_id,

3250: UPDATE oe_blanket_headers_all
3251: SET open_flag = p_open_flag,
3252: -- Bug 12849250
3253: last_update_date = SYSDATE,
3254: last_updated_by = fnd_global.user_id,
3255: last_update_login = fnd_global.login_id
3256: WHERE header_id = l_header_id;
3257:
3258: -- ZB put the code here

Line 3255: last_update_login = fnd_global.login_id

3251: SET open_flag = p_open_flag,
3252: -- Bug 12849250
3253: last_update_date = SYSDATE,
3254: last_updated_by = fnd_global.user_id,
3255: last_update_login = fnd_global.login_id
3256: WHERE header_id = l_header_id;
3257:
3258: -- ZB put the code here
3259: oe_debug_pub.ADD ('Acquiring locks on blanket lines');

Line 3278: last_updated_by = fnd_global.user_id,

3274: UPDATE oe_blanket_lines_all
3275: SET open_flag = p_open_flag,
3276: -- Bug 12849250
3277: last_update_date = SYSDATE,
3278: last_updated_by = fnd_global.user_id,
3279: last_update_login = fnd_global.login_id
3280: WHERE header_id = l_header_id;
3281:
3282: -- End code

Line 3279: last_update_login = fnd_global.login_id

3275: SET open_flag = p_open_flag,
3276: -- Bug 12849250
3277: last_update_date = SYSDATE,
3278: last_updated_by = fnd_global.user_id,
3279: last_update_login = fnd_global.login_id
3280: WHERE header_id = l_header_id;
3281:
3282: -- End code
3283: l_updated_flag := 'Y';

Line 3292: last_updated_by = fnd_global.user_id,

3288: UPDATE oe_blanket_headers_all
3289: SET draft_submitted_flag = p_draft_submitted_flag,
3290: -- Bug 12849250
3291: last_update_date = SYSDATE,
3292: last_updated_by = fnd_global.user_id,
3293: last_update_login = fnd_global.login_id
3294: WHERE header_id = l_header_id;
3295:
3296: l_updated_flag := 'Y';

Line 3293: last_update_login = fnd_global.login_id

3289: SET draft_submitted_flag = p_draft_submitted_flag,
3290: -- Bug 12849250
3291: last_update_date = SYSDATE,
3292: last_updated_by = fnd_global.user_id,
3293: last_update_login = fnd_global.login_id
3294: WHERE header_id = l_header_id;
3295:
3296: l_updated_flag := 'Y';
3297: END IF;

Line 3640: WHERE user_id = fnd_global.user_id;

3636:
3637: SELECT user_name
3638: INTO l_owner_role
3639: FROM fnd_user
3640: WHERE user_id = fnd_global.user_id;
3641:
3642: -- Create Header Work item
3643: wf_engine.createprocess (p_item_type,
3644: TO_CHAR (p_header_id),

Line 3657: l_avalue (1) := fnd_global.user_id;

3653: END IF;
3654:
3655: -- Set various Header Attributes
3656: l_aname (1) := 'USER_ID';
3657: l_avalue (1) := fnd_global.user_id;
3658: l_aname (2) := 'APPLICATION_ID';
3659: l_avalue (2) := fnd_global.resp_appl_id;
3660: l_aname (3) := 'RESPONSIBILITY_ID';
3661: l_avalue (3) := fnd_global.resp_id;

Line 3659: l_avalue (2) := fnd_global.resp_appl_id;

3655: -- Set various Header Attributes
3656: l_aname (1) := 'USER_ID';
3657: l_avalue (1) := fnd_global.user_id;
3658: l_aname (2) := 'APPLICATION_ID';
3659: l_avalue (2) := fnd_global.resp_appl_id;
3660: l_aname (3) := 'RESPONSIBILITY_ID';
3661: l_avalue (3) := fnd_global.resp_id;
3662: l_aname (4) := 'ORG_ID';
3663: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);

Line 3661: l_avalue (3) := fnd_global.resp_id;

3657: l_avalue (1) := fnd_global.user_id;
3658: l_aname (2) := 'APPLICATION_ID';
3659: l_avalue (2) := fnd_global.resp_appl_id;
3660: l_aname (3) := 'RESPONSIBILITY_ID';
3661: l_avalue (3) := fnd_global.resp_id;
3662: l_aname (4) := 'ORG_ID';
3663: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);
3664: l_aname (5) := 'TRANSACTION_NUMBER';
3665: l_avalue (5) := p_transaction_number;

Line 3684: WHERE user_id = fnd_global.user_id;

3680: BEGIN
3681: SELECT user_name
3682: INTO l_user_name
3683: FROM fnd_user
3684: WHERE user_id = fnd_global.user_id;
3685: EXCEPTION
3686: WHEN OTHERS
3687: THEN
3688: l_user_name := NULL; -- do not set FROM_ROLE then

Line 3941: nlchar VARCHAR2 (2) := fnd_global.NEWLINE;

3937: l_line_msg VARCHAR2 (1000);
3938: nl VARCHAR2 (1) := '';
3939: i NUMBER := 0;
3940: -- New Line char.
3941: nlchar VARCHAR2 (2) := fnd_global.NEWLINE;
3942: -- fnd messages
3943: l_msg_bsa VARCHAR2 (240);
3944: l_msg_creation_date VARCHAR2 (240);
3945: l_msg_activation_date VARCHAR2 (240);

Line 4325: nlchar VARCHAR2 (2) := fnd_global.NEWLINE;

4321: nl VARCHAR2 (1) := '';
4322: i NUMBER := 0;
4323: l_url VARCHAR2 (1000);
4324: -- New Line char.
4325: nlchar VARCHAR2 (2) := fnd_global.NEWLINE;
4326: -- FND msg titles
4327: l_msg_creation_date VARCHAR2 (240);
4328: l_msg_salesperson VARCHAR2 (240);
4329: l_msg_customer VARCHAR2 (240);