DBA Data[Home] [Help]

APPS.GMS_AP_API dependencies on GMS_AWARDS_DIST_PKG

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

78: X_adl_rec.Raw_cost := NULL ;
79: X_adl_rec.FC_STATUS := 'N' ;
80: X_adl_rec.adl_status := 'A' ;
81: X_adl_rec.adl_line_num := 1 ;
82: X_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
83:
84:
85:
86: IF c_er_rec.award_set_id is Not NULL OR

Line 102: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

98: and invoice_distribution_id = c_er_rec.invoice_distribution_id;
99:
100: END IF ;
101:
102: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
103:
104: update ap_invoice_distributions_all
105: set award_id = X_adl_rec.award_set_id
106: where invoice_id = X_invoice_id

Line 242: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

238: Return lb_return;
239: END IF ;
240: /* Create ADL for Account generator . */
241:
242: l_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
243: l_adl_rec.award_set_id := l_award_set_id ;
244: l_adl_rec.adl_line_num := 1 ;
245: l_adl_rec.document_type := 'OPI' ;
246: l_adl_rec.distribution_value := 100 ;

Line 254: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

250: l_adl_rec.request_id := FND_GLOBAL.CONC_REQUEST_ID ;
251: l_adl_rec.adl_status := 'A' ;
252: l_adl_rec.line_type := 'R' ;
253: l_adl_rec.invoice_distribution_id := p_invoice_line_id ;
254: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
255: p_award_id := l_award_set_id ;
256: END IF ;
257:
258: ELSIF P_EVENT = 'AWARD_SET_ID_REMOVE' THEN

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

323: return ;
324: END IF ;
325: IF p_mode = 'AP' THEN
326: FOR LOOP_AP_REC IN C_AP_REC LOOP
327: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
328: l_adl_rec.invoice_id := p_invoice_id ;
329: l_adl_rec.distribution_line_number := p_distribution_line_number ;
330: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
331: l_adl_rec.document_type := 'AP' ;

Line 344: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

340: l_adl_rec.creation_date := loop_ap_rec.creation_date ;
341: l_adl_rec.last_updated_by := loop_ap_rec.last_updated_by ;
342: l_adl_rec.created_by := loop_ap_rec.created_by ;
343: l_adl_rec.last_update_login := loop_ap_rec.last_update_login ;
344: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
345: update ap_invoice_distributions_all
346: set award_id = l_adl_rec.award_set_id
347: where invoice_id = loop_ap_rec.invoice_id
348: and distribution_line_number = loop_ap_rec.distribution_line_number

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

352: ELSIF p_mode = 'APD' THEN
353: OPEN C_ADL_REC ;
354: FETCH C_ADL_REC INTO l_ADL_REC ;
355: IF C_ADL_REC%FOUND THEN
356: l_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
357: l_adl_rec.invoice_id := p_invoice_id ;
358: l_adl_rec.distribution_line_number := p_distribution_line_number ;
359: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
360: l_adl_rec.document_type := 'AP' ;

Line 362: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;

358: l_adl_rec.distribution_line_number := p_distribution_line_number ;
359: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
360: l_adl_rec.document_type := 'AP' ;
361: l_adl_rec.line_type := 'R' ;
362: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
363: update ap_invoice_distributions_all
364: set award_id = l_adl_rec.award_set_id
365: where invoice_id = p_invoice_id
366: and distribution_line_number = p_distribution_line_number

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

542: FETCH c_new_dist_line into x_ap_rec ;
543: CLOSE c_new_dist_line ;
544: x_amount := x_ap_rec.amount ;
545: x_inv_dist_id := x_ap_rec.invoice_distribution_id ;
546: x_adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id ;
547:
548: x_adl_rec.invoice_id := p_invoice_id;
549: x_adl_rec.invoice_distribution_id := x_inv_dist_id ;
550: x_adl_rec.distribution_line_number := p_next_dist_line_num ;

Line 560: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;

556: -- Verify in testing ....
557: -- =====================================================
558: x_adl_rec.fc_status := 'N' ;
559: x_adl_rec.burdenable_raw_cost := 0 ;
560: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;
561: UPDATE GMS_AWARD_DISTRIBUTIONS
562: SET BUD_TASK_ID = x_adl_rec.BUD_TASK_ID
563: WHERE AWARD_SET_ID = x_adl_rec.award_set_id
564: AND ADL_STATUS = 'A' ;

Line 825: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID

821: A.creation_date CREATION_DATE,
822: A.last_updated_by LAST_UPDATED_BY,
823: A.created_by CREATED_BY,
824: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
825: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
826: BULK COLLECT INTO l_invoice_id,
827: l_distribution_line_number,
828: l_invoice_distribution_id,
829: l_project_id ,

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

968: l_creation_date(l_count) := ap_rec.creation_date;
969: l_last_updated_by(l_count) := ap_rec.last_updated_by;
970: l_created_by(l_count) := NVL(ap_rec.created_by,0);
971: l_last_update_login(l_count) := ap_rec.last_update_login;
972: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
973:
974: END IF ;
975:
976: END LOOP ;