DBA Data[Home] [Help]

APPS.GMS_PO_API_GRP dependencies on GMS_AWARDS_DIST_PKG

Line 140: SELECT gms_awards_dist_pkg.get_award_set_id ,

136: creation_date ,
137: last_update_login ,
138: billable_flag
139: )
140: SELECT gms_awards_dist_pkg.get_award_set_id ,
141: 1, --adl_line_num,
142: funding_pattern_id,
143: distribution_value ,
144: raw_cost,

Line 326: l_adls_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;

322: --
323:
324: IF NVL(l_adls_rec.po_distribution_id,0) <> p_distribution_id THEN
325: -- Award distribution line must be created here.
326: l_adls_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
327: l_adls_rec.adl_line_num := 1 ;
328: l_adls_rec.document_type := 'PO' ;
329: l_adls_rec.project_id := p_project_id ;
330: l_adls_rec.task_id := p_task_id ;

Line 349: gms_awards_dist_pkg.create_adls(l_adls_rec) ;

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
352: set award_id = l_adls_rec.award_set_id
353: where po_distribution_id = p_distribution_id ;

Line 1062: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

1058: FUNCTION get_new_award_set_id return number is
1059: l_award_set_id NUMBER ;
1060: BEGIN
1061: IF gms_install.enabled then
1062: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
1063: END IF ;
1064: return l_award_set_id ;
1065: END get_new_award_set_id ;
1066:

Line 1210: gms_awards_dist_pkg.create_adls(l_adl_rec);

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:
1210: gms_awards_dist_pkg.create_adls(l_adl_rec);
1211:
1212: x_msg_count := l_msg_count ;
1213: x_msg_data := l_msg_data ;
1214: x_return_status := l_return_status ;

Line 1357: gms_awards_dist_pkg.create_adls(l_adl_rec) ;

1353: l_adl_rec.line_type := 'R' ;
1354: l_adl_rec.capitalized_flag := 'N' ;
1355: l_adl_rec.capitalizable_flag:= NULL ;
1356: l_adl_rec.po_distribution_id:= p_po_distribution_id ;
1357: gms_awards_dist_pkg.create_adls(l_adl_rec) ;
1358:
1359: EXCEPTION
1360: WHEN FND_API.G_EXC_ERROR then
1361: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1605: gms_awards_dist_pkg.update_adls(l_adl_rec) ;

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 ;
1608: x_award_set_id_out := l_award_set_id_out ;
1609: