DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on FND_GLOBAL

Line 1659: l_last_updated_by := FND_GLOBAL.USER_ID ;

1655: IF (p_update_disp_rec.curr_disposition IS NULL OR p_update_disp_rec.event_spec_disp_id IS NULL) THEN
1656: raise REQ_FIELDS_MISSING;
1657: END IF;
1658:
1659: l_last_updated_by := FND_GLOBAL.USER_ID ;
1660: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
1661: l_last_update_date := SYSDATE ;
1662:
1663:

Line 1660: l_last_update_login := FND_GLOBAL.LOGIN_ID ;

1656: raise REQ_FIELDS_MISSING;
1657: END IF;
1658:
1659: l_last_updated_by := FND_GLOBAL.USER_ID ;
1660: l_last_update_login := FND_GLOBAL.LOGIN_ID ;
1661: l_last_update_date := SYSDATE ;
1662:
1663:
1664: IF p_update_disp_rec.sample_id IS NOT NULL THEN

Line 2249: ,fnd_global.user_id

2245: ,p_update_change_disp_rec.TO_GRADE_CODE
2246: ,p_update_change_disp_rec.REASON_ID
2247: ,p_update_change_disp_rec.HOLD_DATE
2248: ,SYSDATE
2249: ,fnd_global.user_id
2250: ,fnd_global.user_id
2251: ,SYSDATE
2252: ,fnd_global.user_id
2253: );

Line 2250: ,fnd_global.user_id

2246: ,p_update_change_disp_rec.REASON_ID
2247: ,p_update_change_disp_rec.HOLD_DATE
2248: ,SYSDATE
2249: ,fnd_global.user_id
2250: ,fnd_global.user_id
2251: ,SYSDATE
2252: ,fnd_global.user_id
2253: );
2254:

Line 2252: ,fnd_global.user_id

2248: ,SYSDATE
2249: ,fnd_global.user_id
2250: ,fnd_global.user_id
2251: ,SYSDATE
2252: ,fnd_global.user_id
2253: );
2254:
2255:
2256: IF SQL%NOTFOUND THEN

Line 2285: ,fnd_global.user_id

2281: ,p_update_change_disp_rec.LOT_NUMBER
2282: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2283: ,p_update_change_disp_rec.FROM_GRADE_CODE
2284: ,SYSDATE
2285: ,fnd_global.user_id
2286: ,fnd_global.user_id
2287: ,SYSDATE
2288: ,fnd_global.user_id
2289: );

Line 2286: ,fnd_global.user_id

2282: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2283: ,p_update_change_disp_rec.FROM_GRADE_CODE
2284: ,SYSDATE
2285: ,fnd_global.user_id
2286: ,fnd_global.user_id
2287: ,SYSDATE
2288: ,fnd_global.user_id
2289: );
2290: ELSIF (p_update_change_disp_rec.PARENT_LOT_NUMBER IS NOT NULL) THEN

Line 2288: ,fnd_global.user_id

2284: ,SYSDATE
2285: ,fnd_global.user_id
2286: ,fnd_global.user_id
2287: ,SYSDATE
2288: ,fnd_global.user_id
2289: );
2290: ELSIF (p_update_change_disp_rec.PARENT_LOT_NUMBER IS NOT NULL) THEN
2291:
2292: OPEN cur_get_lot;

Line 2317: ,fnd_global.user_id

2313: ,L_LOT_NUMBER
2314: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2315: ,p_update_change_disp_rec.FROM_GRADE_CODE
2316: ,SYSDATE
2317: ,fnd_global.user_id
2318: ,fnd_global.user_id
2319: ,SYSDATE
2320: ,fnd_global.user_id
2321: );

Line 2318: ,fnd_global.user_id

2314: ,p_update_change_disp_rec.FROM_LOT_STATUS_ID
2315: ,p_update_change_disp_rec.FROM_GRADE_CODE
2316: ,SYSDATE
2317: ,fnd_global.user_id
2318: ,fnd_global.user_id
2319: ,SYSDATE
2320: ,fnd_global.user_id
2321: );
2322:

Line 2320: ,fnd_global.user_id

2316: ,SYSDATE
2317: ,fnd_global.user_id
2318: ,fnd_global.user_id
2319: ,SYSDATE
2320: ,fnd_global.user_id
2321: );
2322:
2323:
2324: END LOOP;

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

2710: l_position := '015' ;
2711:
2712: -- set up constants needed for the inventory API.
2713: -- Bug 4165704- not needed after inventory convergence
2714: --l_tempb := GMIGUTL.SETUP(FND_GLOBAL.USER_NAME);
2715: --IF (NOT l_tempb) THEN
2716: -- x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2717: -- x_return_status := FND_API.G_RET_STS_ERROR ;
2718: -- return;

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

2791: -- l_trans_rec_grade.co_code := l_co_code ;
2792: -- l_trans_rec_grade.orgn_code := l_orgn_code ;
2793: -- l_trans_rec_grade.qc_grade := p_to_grade_code ;
2794: -- l_trans_rec_grade.reason_code := p_reason_code ;
2795: -- l_trans_rec_grade.user_name := FND_GLOBAL.USER_NAME ;
2796: -- l_trans_rec_grade.trans_date := SYSDATE ;
2797: -- l_trans_rec_grade.trans_qty := NULL;
2798:
2799: -- GMIPAPI.Inventory_Posting

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

2974: -- l_trans_rec_lot_status.from_location := get_curr_lot_status_rec.location;
2975: -- l_trans_rec_lot_status.orgn_code := l_orgn_code ;
2976: -- l_trans_rec_lot_status.lot_status := p_to_lot_status ;
2977: --- l_trans_rec_lot_status.reason_code := p_reason_code ;
2978: -- l_trans_rec_lot_status.user_name := FND_GLOBAL.USER_NAME ;
2979: -- l_trans_rec_lot_status.trans_date := SYSDATE ;
2980: -- l_trans_rec_lot_status.trans_qty := NULL;
2981: --GMIPAPI.Inventory_Posting
2982: --( p_api_version => 3.0

Line 3005: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;

3001: l_inv_status_upd_rec_type.LPN_ID := NULL;
3002: l_inv_status_upd_rec_type.initial_status_flag := 'N';
3003: l_inv_status_upd_rec_type.FROM_MOBILE_APPS_FLAG := 'N';
3004: l_inv_status_upd_rec_type.update_method := 2;
3005: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;
3006: l_inv_status_upd_rec_type.last_update_date := SYSDATE;
3007: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;
3008:
3009: -- fix for 12829066 -- pal

Line 3007: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;

3003: l_inv_status_upd_rec_type.FROM_MOBILE_APPS_FLAG := 'N';
3004: l_inv_status_upd_rec_type.update_method := 2;
3005: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;
3006: l_inv_status_upd_rec_type.last_update_date := SYSDATE;
3007: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;
3008:
3009: -- fix for 12829066 -- pal
3010:
3011:

Line 3157: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;

3153: l_inv_status_upd_rec_type.LPN_ID := NULL; -- Bug 12829066 - GETTING ERROR WHEN TRYING TO CHANGE DISPOSITION AND LOT STATUS IN OPM QUALITY IT
3154: l_inv_status_upd_rec_type.initial_status_flag := 'N';
3155: l_inv_status_upd_rec_type.FROM_MOBILE_APPS_FLAG := 'N';
3156: l_inv_status_upd_rec_type.update_method := 2;
3157: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;
3158: l_inv_status_upd_rec_type.last_update_date := SYSDATE;
3159: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;
3160:
3161: if( l_lot_update_profile = '0') THEN

Line 3159: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;

3155: l_inv_status_upd_rec_type.FROM_MOBILE_APPS_FLAG := 'N';
3156: l_inv_status_upd_rec_type.update_method := 2;
3157: l_inv_status_upd_rec_type.last_updated_by := FND_GLOBAL.USER_ID;
3158: l_inv_status_upd_rec_type.last_update_date := SYSDATE;
3159: l_inv_status_upd_rec_type.last_update_login := FND_GLOBAL.LOGIN_ID;
3160:
3161: if( l_lot_update_profile = '0') THEN
3162: l_inv_status_upd_rec_type.LOCATOR_ID := l_locator_id;
3163: ELSE

Line 3415: ,last_updated_by = FND_GLOBAL.USER_ID

3411:
3412: IF l_curr_qc_status = 3 THEN -- Results Required
3413: UPDATE GME_BATCH_STEPS
3414: SET quality_status = p_to_qc_status -- NO ACTION BUT could be here too 8252179
3415: ,last_updated_by = FND_GLOBAL.USER_ID
3416: ,last_update_date = SYSDATE
3417: ,last_update_login = FND_GLOBAL.LOGIN_ID
3418: WHERE rowid = l_rowid ;
3419:

Line 3417: ,last_update_login = FND_GLOBAL.LOGIN_ID

3413: UPDATE GME_BATCH_STEPS
3414: SET quality_status = p_to_qc_status -- NO ACTION BUT could be here too 8252179
3415: ,last_updated_by = FND_GLOBAL.USER_ID
3416: ,last_update_date = SYSDATE
3417: ,last_update_login = FND_GLOBAL.LOGIN_ID
3418: WHERE rowid = l_rowid ;
3419:
3420: --Bug# 5440347 start
3421: -- Dont call complete_step if the qc status is Action Required

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

4345: RAISE FND_API.G_EXC_ERROR;
4346: END IF;
4347: l_position := '020' ;
4348:
4349: --IF NOT GMIGUTL.setup(FND_GLOBAL.USER_NAME) THEN
4350: -- Error Message must have been logged.
4351: -- RAISE FND_API.G_EXC_ERROR;
4352: --END IF;
4353: --l_trans_rec.trans_type := 2; -- adjustment transaction