DBA Data[Home] [Help]

APPS.OKC_AST_PVT dependencies on FND_GLOBAL

Line 20: if fnd_global.user_id = 1 then

16: OKC_ASSENTS_V
17: where
18: id >= 11000 AND id < 50000;
19: BEGIN
20: if fnd_global.user_id = 1 then
21: open seed_c;
22: fetch seed_c into l_id;
23: close seed_c;
24: return(l_id);

Line 1137: l_astv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1133: ) RETURN astv_rec_type IS
1134: l_astv_rec astv_rec_type := p_astv_rec;
1135: BEGIN
1136: l_astv_rec.CREATION_DATE := SYSDATE;
1137: l_astv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1138: l_astv_rec.LAST_UPDATE_DATE := l_astv_rec.CREATION_DATE;
1139: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1141: RETURN(l_astv_rec);

Line 1139: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1135: BEGIN
1136: l_astv_rec.CREATION_DATE := SYSDATE;
1137: l_astv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1138: l_astv_rec.LAST_UPDATE_DATE := l_astv_rec.CREATION_DATE;
1139: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1141: RETURN(l_astv_rec);
1142: END fill_who_columns;
1143: --------------------------------------

Line 1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1136: l_astv_rec.CREATION_DATE := SYSDATE;
1137: l_astv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1138: l_astv_rec.LAST_UPDATE_DATE := l_astv_rec.CREATION_DATE;
1139: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1141: RETURN(l_astv_rec);
1142: END fill_who_columns;
1143: --------------------------------------
1144: -- Set_Attributes for:OKC_ASSENTS_V --

Line 1855: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1851: ) RETURN astv_rec_type IS
1852: l_astv_rec astv_rec_type := p_astv_rec;
1853: BEGIN
1854: l_astv_rec.LAST_UPDATE_DATE := SYSDATE;
1855: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1856: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1857: RETURN(l_astv_rec);
1858: END fill_who_columns;
1859: ----------------------------------

Line 1856: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1852: l_astv_rec astv_rec_type := p_astv_rec;
1853: BEGIN
1854: l_astv_rec.LAST_UPDATE_DATE := SYSDATE;
1855: l_astv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1856: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1857: RETURN(l_astv_rec);
1858: END fill_who_columns;
1859: ----------------------------------
1860: -- FUNCTION populate_new_record --

Line 2397: l_cur_user okc_change_requests_b.user_id%TYPE := FND_GLOBAL.USER_ID;

2393: l_sts_code okc_k_headers_b.sts_code%TYPE; */
2394: l_scs_code okc_k_headers_all_b.scs_code%TYPE;
2395: l_sts_code okc_k_headers_all_b.sts_code%TYPE;
2396: --END NPALEPU
2397: l_cur_user okc_change_requests_b.user_id%TYPE := FND_GLOBAL.USER_ID;
2398:
2399: l_date_approved DATE;
2400: l_date_signed DATE;
2401: --