DBA Data[Home] [Help]

APPS.GMS_AP_API dependencies on GMS_AWARDS_DIST_PKG

Line 104: X_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;

100: X_adl_rec.Raw_cost := NULL ;
101: X_adl_rec.FC_STATUS := 'N' ;
102: X_adl_rec.adl_status := 'A' ;
103: X_adl_rec.adl_line_num := 1 ;
104: X_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
105:
106:
107:
108: IF c_er_rec.award_set_id is Not NULL OR

Line 124: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

120: and invoice_distribution_id = c_er_rec.invoice_distribution_id;
121:
122: END IF ;
123:
124: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
125:
126: update ap_invoice_distributions_all
127: set award_id = X_adl_rec.award_set_id
128: where invoice_id = X_invoice_id

Line 270: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

266: Return lb_return;
267: END IF ;
268: /* Create ADL for Account generator . */
269:
270: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
271: l_adl_rec.award_set_id := l_award_set_id ;
272: l_adl_rec.adl_line_num := 1 ;
273: l_adl_rec.document_type := 'OPI' ;
274: l_adl_rec.distribution_value := 100 ;

Line 282: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

278: l_adl_rec.request_id := FND_GLOBAL.CONC_REQUEST_ID ;
279: l_adl_rec.adl_status := 'A' ;
280: l_adl_rec.line_type := 'R' ;
281: l_adl_rec.invoice_distribution_id := p_invoice_line_id ;
282: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
283: p_award_id := l_award_set_id ;
284: END IF ;
285:
286: ELSIF P_EVENT = 'AWARD_SET_ID_REMOVE' THEN

Line 376: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;

372: return ;
373: END IF ;
374: IF p_mode = 'AP' THEN
375: FOR LOOP_AP_REC IN C_AP_REC LOOP
376: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
377: l_adl_rec.invoice_id := p_invoice_id ;
378: l_adl_rec.distribution_line_number := p_distribution_line_number ;
379: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
380: l_adl_rec.document_type := 'AP' ;

Line 393: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

389: l_adl_rec.creation_date := loop_ap_rec.creation_date ;
390: l_adl_rec.last_updated_by := loop_ap_rec.last_updated_by ;
391: l_adl_rec.created_by := loop_ap_rec.created_by ;
392: l_adl_rec.last_update_login := loop_ap_rec.last_update_login ;
393: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
394: update ap_invoice_distributions_all
395: set award_id = l_adl_rec.award_set_id
396: where invoice_id = loop_ap_rec.invoice_id
397: and distribution_line_number = loop_ap_rec.distribution_line_number

Line 412: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;

408: ELSIF p_mode = 'APD' THEN
409: OPEN C_ADL_REC ;
410: FETCH C_ADL_REC INTO l_ADL_REC ;
411: IF C_ADL_REC%FOUND THEN
412: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
413: l_adl_rec.invoice_id := p_invoice_id ;
414: l_adl_rec.distribution_line_number := p_distribution_line_number ;
415: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
416: l_adl_rec.document_type := 'AP' ;

Line 418: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

414: l_adl_rec.distribution_line_number := p_distribution_line_number ;
415: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
416: l_adl_rec.document_type := 'AP' ;
417: l_adl_rec.line_type := 'R' ;
418: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
419: update ap_invoice_distributions_all
420: set award_id = l_adl_rec.award_set_id
421: where invoice_id = p_invoice_id
422: and distribution_line_number = p_distribution_line_number

Line 613: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;

609: FETCH c_new_dist_line into x_ap_rec ;
610: CLOSE c_new_dist_line ;
611: x_amount := x_ap_rec.amount ;
612: x_inv_dist_id := x_ap_rec.invoice_distribution_id ;
613: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
614:
615: x_adl_rec.invoice_id := p_invoice_id;
616: x_adl_rec.invoice_distribution_id := x_inv_dist_id ;
617: x_adl_rec.distribution_line_number := p_next_dist_line_num ;

Line 627: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;

623: -- Verify in testing ....
624: -- =====================================================
625: x_adl_rec.fc_status := 'N' ;
626: x_adl_rec.burdenable_raw_cost := 0 ;
627: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;
628: UPDATE GMS_AWARD_DISTRIBUTIONS
629: SET BUD_TASK_ID = x_adl_rec.BUD_TASK_ID
630: WHERE AWARD_SET_ID = x_adl_rec.award_set_id
631: AND ADL_STATUS = 'A' ;

Line 896: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID

892: A.creation_date CREATION_DATE,
893: A.last_updated_by LAST_UPDATED_BY,
894: A.created_by CREATED_BY,
895: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
896: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
897: BULK COLLECT INTO l_invoice_id,
898: l_distribution_line_number,
899: l_invoice_distribution_id,
900: l_project_id ,

Line 1043: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;

1039: l_creation_date(l_count) := ap_rec.creation_date;
1040: l_last_updated_by(l_count) := ap_rec.last_updated_by;
1041: l_created_by(l_count) := NVL(ap_rec.created_by,0);
1042: l_last_update_login(l_count) := ap_rec.last_update_login;
1043: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
1044:
1045: END IF ;
1046:
1047: END LOOP ;