DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on FND_GLOBAL

Line 8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4: --
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgtpub.pls';
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
10: G_MIN_QUANTITY NUMBER := 0;
11: G_MAX_QUANTITY NUMBER := 0;
12: G_SAFETY_FACTOR NUMBER := 0;

Line 9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgtpub.pls';
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
10: G_MIN_QUANTITY NUMBER := 0;
11: G_MAX_QUANTITY NUMBER := 0;
12: G_SAFETY_FACTOR NUMBER := 0;
13: G_SAFETY_STOCK NUMBER := 0;

Line 351: l_user_id := fnd_global.user_id;

347:
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: SELECT Sysdate INTO l_today FROM dual;
351: l_user_id := fnd_global.user_id;
352: l_login_id := fnd_global.login_id;
353:
354: -- If p_move_order_type = 2 or 3 (include replenishment move orders) then
355: -- create records in spares move order tables

Line 352: l_login_id := fnd_global.login_id;

348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: SELECT Sysdate INTO l_today FROM dual;
351: l_user_id := fnd_global.user_id;
352: l_login_id := fnd_global.login_id;
353:
354: -- If p_move_order_type = 2 or 3 (include replenishment move orders) then
355: -- create records in spares move order tables
356: IF (p_move_order_type = 2 OR p_move_order_type = 3) THEN

Line 579: x_msg_data := x_msg_data || fnd_global.local_chr(10);

575:
576: x_msg_data := x_msg_data || t_msg_data;
577:
578: IF mod(l_return_count, 2) = 0 THEN
579: x_msg_data := x_msg_data || fnd_global.local_chr(10);
580: END IF;
581: l_return_count := l_return_count + 1;
582: end loop;
583: l_return_status := fnd_api.g_ret_sts_success;

Line 593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;

589: -- update mtl_txn_request_lines with the detailed quantity
590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:

Line 594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:
598: /* update mtl_txn_request_lines

Line 1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;

1786:
1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );
1788: l_trolin_rec.quantity_detailed := pickline_rec.qty_det;
1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1792:
1793: INV_Trolin_Util.Update_Row(l_trolin_rec);
1794: commit;

Line 1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );
1788: l_trolin_rec.quantity_detailed := pickline_rec.qty_det;
1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1792:
1793: INV_Trolin_Util.Update_Row(l_trolin_rec);
1794: commit;
1795:

Line 2435: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE,

2431: WHERE lookup_type = 'SHIPMENT LINE STATUS'
2432: AND lookup_code = l_status
2433: AND LANGUAGE = USERENV('LANG')
2434: AND VIEW_APPLICATION_ID = 201
2435: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE,
2436: LV.VIEW_APPLICATION_ID);
2437:
2438: EXCEPTION
2439: WHEN NO_DATA_FOUND THEN

Line 2448: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2444: WHERE lookup_type = 'LINE_FLOW_STATUS'
2445: AND lookup_code = p_flow_status_code
2446: AND LANGUAGE = userenv('LANG')
2447: AND VIEW_APPLICATION_ID = 660
2448: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2449: lv.view_application_id);
2450: WHEN OTHERS THEN
2451: null;
2452: END;

Line 2463: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2459: WHERE lookup_type = 'LINE_FLOW_STATUS'
2460: AND lookup_code = p_flow_status_code
2461: AND LANGUAGE = userenv('LANG')
2462: AND VIEW_APPLICATION_ID = 660
2463: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2464: lv.view_application_id);
2465: /* status is AWAITING_SHIPPING or PRODUCTION_COMPLETE, get value from shipping table */
2466: ELSE
2467: l_status := p_flow_status_code;

Line 2484: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2480: WHERE lookup_type = 'LINE_FLOW_STATUS'
2481: AND lookup_code = 'PICKED'
2482: AND LANGUAGE = userenv('LANG')
2483: AND VIEW_APPLICATION_ID = 660
2484: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2485: lv.view_application_id);
2486: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
2487: l_status := 'PICKED_PARTIAL';
2488: SELECT meaning

Line 2495: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2491: WHERE lookup_type = 'LINE_FLOW_STATUS'
2492: AND lookup_code = 'PICKED_PARTIAL'
2493: AND LANGUAGE = userenv('LANG')
2494: AND VIEW_APPLICATION_ID = 660
2495: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2496: lv.view_application_id);
2497: ELSE
2498: SELECT meaning
2499: INTO G_STATUS_MEANING

Line 2505: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2501: WHERE lookup_type = 'LINE_FLOW_STATUS'
2502: AND lookup_code = l_status
2503: AND LANGUAGE = userenv('LANG')
2504: AND VIEW_APPLICATION_ID = 660
2505: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2506: lv.view_application_id);
2507: END IF;
2508: END IF;
2509: RETURN(l_status);