DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on FND_GLOBAL

Line 1549: l_last_updated_by := FND_GLOBAL.USER_ID ;

1545: IF (p_update_disp_rec.curr_disposition IS NULL OR p_update_disp_rec.event_spec_disp_id IS NULL) THEN
1546: raise REQ_FIELDS_MISSING;
1547: END IF;
1548:
1549: l_last_updated_by := FND_GLOBAL.USER_ID ;
1550: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
1551: l_last_update_date := SYSDATE ;
1552:
1553:

Line 1550: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

1546: raise REQ_FIELDS_MISSING;
1547: END IF;
1548:
1549: l_last_updated_by := FND_GLOBAL.USER_ID ;
1550: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
1551: l_last_update_date := SYSDATE ;
1552:
1553:
1554: IF p_update_disp_rec.sample_id IS NOT NULL THEN

Line 2067: ,fnd_global.user_id

2063: ,p_update_change_disp_rec.TO_GRADE_CODE
2064: ,p_update_change_disp_rec.REASON_ID
2065: ,p_update_change_disp_rec.HOLD_DATE
2066: ,SYSDATE
2067: ,fnd_global.user_id
2068: ,fnd_global.user_id
2069: ,SYSDATE
2070: ,fnd_global.user_id
2071: );

Line 2068: ,fnd_global.user_id

2064: ,p_update_change_disp_rec.REASON_ID
2065: ,p_update_change_disp_rec.HOLD_DATE
2066: ,SYSDATE
2067: ,fnd_global.user_id
2068: ,fnd_global.user_id
2069: ,SYSDATE
2070: ,fnd_global.user_id
2071: );
2072:

Line 2070: ,fnd_global.user_id

2066: ,SYSDATE
2067: ,fnd_global.user_id
2068: ,fnd_global.user_id
2069: ,SYSDATE
2070: ,fnd_global.user_id
2071: );
2072:
2073:
2074: IF SQL%NOTFOUND THEN

Line 2103: ,fnd_global.user_id

2099: ,p_update_change_disp_rec.LOT_NUMBER
2100: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2101: ,p_update_change_disp_rec.FROM_GRADE_CODE
2102: ,SYSDATE
2103: ,fnd_global.user_id
2104: ,fnd_global.user_id
2105: ,SYSDATE
2106: ,fnd_global.user_id
2107: );

Line 2104: ,fnd_global.user_id

2100: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2101: ,p_update_change_disp_rec.FROM_GRADE_CODE
2102: ,SYSDATE
2103: ,fnd_global.user_id
2104: ,fnd_global.user_id
2105: ,SYSDATE
2106: ,fnd_global.user_id
2107: );
2108: ELSIF (p_update_change_disp_rec.PARENT_LOT_NUMBER IS NOT NULL) THEN

Line 2106: ,fnd_global.user_id

2102: ,SYSDATE
2103: ,fnd_global.user_id
2104: ,fnd_global.user_id
2105: ,SYSDATE
2106: ,fnd_global.user_id
2107: );
2108: ELSIF (p_update_change_disp_rec.PARENT_LOT_NUMBER IS NOT NULL) THEN
2109:
2110: OPEN cur_get_lot;

Line 2135: ,fnd_global.user_id

2131: ,L_LOT_NUMBER
2132: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2133: ,p_update_change_disp_rec.FROM_GRADE_CODE
2134: ,SYSDATE
2135: ,fnd_global.user_id
2136: ,fnd_global.user_id
2137: ,SYSDATE
2138: ,fnd_global.user_id
2139: );

Line 2136: ,fnd_global.user_id

2132: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2133: ,p_update_change_disp_rec.FROM_GRADE_CODE
2134: ,SYSDATE
2135: ,fnd_global.user_id
2136: ,fnd_global.user_id
2137: ,SYSDATE
2138: ,fnd_global.user_id
2139: );
2140:

Line 2138: ,fnd_global.user_id

2134: ,SYSDATE
2135: ,fnd_global.user_id
2136: ,fnd_global.user_id
2137: ,SYSDATE
2138: ,fnd_global.user_id
2139: );
2140:
2141:
2142: END LOOP;

Line 2456: --l_tempb := GMIGUTL.SETUP(FND_GLOBAL.USER_NAME);

2452: l_position := '015' ;
2453:
2454: -- set up constants needed for the inventory API.
2455: -- Bug 4165704- not needed after inventory convergence
2456: --l_tempb := GMIGUTL.SETUP(FND_GLOBAL.USER_NAME);
2457: --IF (NOT l_tempb) THEN
2458: -- x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2459: -- x_return_status := FND_API.G_RET_STS_ERROR ;
2460: -- return;

Line 2537: -- l_trans_rec_grade.user_name := FND_GLOBAL.USER_NAME ;

2533: -- l_trans_rec_grade.co_code := l_co_code ;
2534: -- l_trans_rec_grade.orgn_code := l_orgn_code ;
2535: -- l_trans_rec_grade.qc_grade := p_to_grade_code ;
2536: -- l_trans_rec_grade.reason_code := p_reason_code ;
2537: -- l_trans_rec_grade.user_name := FND_GLOBAL.USER_NAME ;
2538: -- l_trans_rec_grade.trans_date := SYSDATE ;
2539: -- l_trans_rec_grade.trans_qty := NULL;
2540:
2541: -- GMIPAPI.Inventory_Posting

Line 2696: -- l_trans_rec_lot_status.user_name := FND_GLOBAL.USER_NAME ;

2692: -- l_trans_rec_lot_status.from_location := get_curr_lot_status_rec.location;
2693: -- l_trans_rec_lot_status.orgn_code := l_orgn_code ;
2694: -- l_trans_rec_lot_status.lot_status := p_to_lot_status ;
2695: --- l_trans_rec_lot_status.reason_code := p_reason_code ;
2696: -- l_trans_rec_lot_status.user_name := FND_GLOBAL.USER_NAME ;
2697: -- l_trans_rec_lot_status.trans_date := SYSDATE ;
2698: -- l_trans_rec_lot_status.trans_qty := NULL;
2699: --GMIPAPI.Inventory_Posting
2700: --( p_api_version => 3.0

Line 2826: ,last_updated_by = FND_GLOBAL.USER_ID

2822:
2823: IF l_curr_qc_status = 3 THEN -- Results Required
2824: UPDATE GME_BATCH_STEPS
2825: SET quality_status = p_to_qc_status
2826: ,last_updated_by = FND_GLOBAL.USER_ID
2827: ,last_update_date = SYSDATE
2828: ,last_update_login = FND_GLOBAL.LOGIN_ID
2829: WHERE rowid = l_rowid ;
2830:

Line 2828: ,last_update_login = FND_GLOBAL.LOGIN_ID

2824: UPDATE GME_BATCH_STEPS
2825: SET quality_status = p_to_qc_status
2826: ,last_updated_by = FND_GLOBAL.USER_ID
2827: ,last_update_date = SYSDATE
2828: ,last_update_login = FND_GLOBAL.LOGIN_ID
2829: WHERE rowid = l_rowid ;
2830:
2831: --Bug# 5440347 start
2832: -- Dont call complete_step if the qc status is Action Required

Line 3712: --IF NOT GMIGUTL.setup(FND_GLOBAL.USER_NAME) THEN

3708: RAISE FND_API.G_EXC_ERROR;
3709: END IF;
3710: l_position := '020' ;
3711:
3712: --IF NOT GMIGUTL.setup(FND_GLOBAL.USER_NAME) THEN
3713: -- Error Message must have been logged.
3714: -- RAISE FND_API.G_EXC_ERROR;
3715: --END IF;
3716: --l_trans_rec.trans_type := 2; -- adjustment transaction