DBA Data[Home] [Help]

APPS.GMS_PO_API_GRP dependencies on FND_GLOBAL

Line 179: fnd_global.user_id , --last_updated_by ,

175: NULL, --distribution_line_number ,
176: NULL, --burdenable_raw_cost ,
177: cost_distributed_flag ,
178: SYSDATE, --last_update_date ,
179: fnd_global.user_id , --last_updated_by ,
180: fnd_global.user_id , --created_by ,
181: SYSDATE, --creation_date ,
182: last_update_login ,
183: billable_flag

Line 180: fnd_global.user_id , --created_by ,

176: NULL, --burdenable_raw_cost ,
177: cost_distributed_flag ,
178: SYSDATE, --last_update_date ,
179: fnd_global.user_id , --last_updated_by ,
180: fnd_global.user_id , --created_by ,
181: SYSDATE, --creation_date ,
182: last_update_login ,
183: billable_flag
184: from gms_award_distributions

Line 346: l_adls_rec.last_updated_by := fnd_global.user_id ;

342: l_adls_rec.burdenable_raw_cost := NULL ;
343:
344: l_adls_rec.creation_date := SYSDATE ;
345: l_adls_rec.last_update_date := SYSDATE ;
346: l_adls_rec.last_updated_by := fnd_global.user_id ;
347: l_adls_rec.created_by := fnd_global.user_id ;
348:
349: gms_awards_dist_pkg.create_adls(l_adls_rec) ;
350:

Line 347: l_adls_rec.created_by := fnd_global.user_id ;

343:
344: l_adls_rec.creation_date := SYSDATE ;
345: l_adls_rec.last_update_date := SYSDATE ;
346: l_adls_rec.last_updated_by := fnd_global.user_id ;
347: l_adls_rec.created_by := fnd_global.user_id ;
348:
349: gms_awards_dist_pkg.create_adls(l_adls_rec) ;
350:
351: update po_distributions_all

Line 1204: l_adl_rec.last_updated_by := fnd_global.user_id;

1200: l_adl_rec.award_id := p_award_id;
1201: l_adl_rec.raw_cost := 0;
1202: l_adl_rec.last_update_date := SYSDATE;
1203: l_adl_rec.creation_date := SYSDATE;
1204: l_adl_rec.last_updated_by := fnd_global.user_id;
1205: l_adl_rec.created_by := fnd_global.user_id;
1206: l_adl_rec.last_update_login := 0;
1207: l_adl_rec.po_distribution_id := p_distribution_id ;
1208: l_adl_rec.request_id := p_distribution_num ;

Line 1205: l_adl_rec.created_by := fnd_global.user_id;

1201: l_adl_rec.raw_cost := 0;
1202: l_adl_rec.last_update_date := SYSDATE;
1203: l_adl_rec.creation_date := SYSDATE;
1204: l_adl_rec.last_updated_by := fnd_global.user_id;
1205: l_adl_rec.created_by := fnd_global.user_id;
1206: l_adl_rec.last_update_login := 0;
1207: l_adl_rec.po_distribution_id := p_distribution_id ;
1208: l_adl_rec.request_id := p_distribution_num ;
1209:

Line 1339: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;

1335: from gms_awards_all
1336: where award_number = p_award_number ;
1337:
1338: l_adl_rec.last_update_date := sysdate ;
1339: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
1340: l_adl_rec.created_by := nvl(fnd_global.user_id,0) ;
1341: l_adl_rec.creation_date := SYSDATE;
1342: l_adl_rec.last_update_login := 0;
1343: l_adl_rec.award_set_id := get_new_award_set_id;

Line 1340: l_adl_rec.created_by := nvl(fnd_global.user_id,0) ;

1336: where award_number = p_award_number ;
1337:
1338: l_adl_rec.last_update_date := sysdate ;
1339: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
1340: l_adl_rec.created_by := nvl(fnd_global.user_id,0) ;
1341: l_adl_rec.creation_date := SYSDATE;
1342: l_adl_rec.last_update_login := 0;
1343: l_adl_rec.award_set_id := get_new_award_set_id;
1344: x_award_set_id_out := l_adl_rec.award_set_id;

Line 1603: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;

1599: where award_number = p_award_number ;
1600:
1601: l_adl_rec.award_id := l_award_id ;
1602: l_adl_rec.last_update_date := sysdate ;
1603: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
1604:
1605: gms_awards_dist_pkg.update_adls(l_adl_rec) ;
1606:
1607: END IF ;