DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on GMS_AWARDS_DIST_PKG

Line 119: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

115: adl_rec.adl_status := 'A';
116: adl_rec.document_type := 'EXP';
117: adl_rec.billed_flag := 'N';
118: adl_rec.bill_hold_flag := x_flag ;
119: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
120: adl_rec.award_id := source_award_id ;
121: adl_rec.raw_cost := rev_rec.raw_cost;
122: adl_rec.last_update_date := rev_rec.last_update_date;
123: adl_rec.creation_date := rev_rec.creation_date;

Line 127: gms_awards_dist_pkg.create_adls(adl_rec);

123: adl_rec.creation_date := rev_rec.creation_date;
124: adl_rec.last_updated_by := rev_rec.last_updated_by;
125: adl_rec.created_by := rev_rec.created_by;
126: adl_rec.last_update_login := rev_rec.last_update_login;
127: gms_awards_dist_pkg.create_adls(adl_rec);
128: x_billable_flag := rev_rec.billable_flag; -- Bug 1756179
129: END LOOP;
130:
131: FOR new_rec IN new_item (x_expenditure_item_id) LOOP

Line 144: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

140: adl_rec.adl_status := 'A';
141: adl_rec.document_type := 'EXP';
142: adl_rec.billed_flag := 'N';
143: adl_rec.bill_hold_flag := x_flag ;
144: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
145: adl_rec.award_id := source_award_id;
146: adl_rec.raw_cost := new_rec.raw_cost;
147: adl_rec.last_update_date := new_rec.last_update_date;
148: adl_rec.creation_date := new_rec.creation_date;

Line 152: gms_awards_dist_pkg.create_adls(adl_rec);

148: adl_rec.creation_date := new_rec.creation_date;
149: adl_rec.last_updated_by := new_rec.last_updated_by;
150: adl_rec.created_by := new_rec.created_by;
151: adl_rec.last_update_login := new_rec.last_update_login;
152: gms_awards_dist_pkg.create_adls(adl_rec);
153: -- Start, Bug 1756179
154: update pa_expenditure_items_all
155: set billable_flag = x_billable_flag
156: where expenditure_item_id = new_rec.expenditure_item_id

Line 593: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

589: adl_rec.adl_status := 'A';
590: adl_rec.document_type := 'EXP';
591: adl_rec.billed_flag := 'N';
592: adl_rec.bill_hold_flag := x_flag ;
593: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
594: adl_rec.award_id := SOURCE_AWARD_ID;
595: adl_rec.raw_cost := rev_rec.raw_cost;
596: adl_rec.last_update_date := rev_rec.last_update_date;
597: adl_rec.creation_date := rev_rec.creation_date;

Line 601: gms_awards_dist_pkg.create_adls(adl_rec);

597: adl_rec.creation_date := rev_rec.creation_date;
598: adl_rec.last_updated_by := rev_rec.last_updated_by;
599: adl_rec.created_by := rev_rec.created_by;
600: adl_rec.last_update_login := rev_rec.last_update_login;
601: gms_awards_dist_pkg.create_adls(adl_rec);
602: END LOOP;
603: END IF;
604:
605:

Line 623: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

619: adl_rec.adl_status := 'A';
620: adl_rec.document_type := 'EXP';
621: adl_rec.billed_flag := 'N';
622: adl_rec.bill_hold_flag := x_flag ;
623: adl_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
624: adl_rec.award_id := DEST_AWARD_ID;
625: adl_rec.raw_cost := new_rec.raw_cost;
626: adl_rec.last_update_date := new_rec.last_update_date;
627: adl_rec.creation_date := new_rec.creation_date;

Line 631: gms_awards_dist_pkg.create_adls(adl_rec);

627: adl_rec.creation_date := new_rec.creation_date;
628: adl_rec.last_updated_by := new_rec.last_updated_by;
629: adl_rec.created_by := new_rec.created_by;
630: adl_rec.last_update_login := new_rec.last_update_login;
631: gms_awards_dist_pkg.create_adls(adl_rec);
632: END LOOP;
633: END IF;
634:
635: END LOOP;

Line 832: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

828: RAISE invalid_award ; -- Bug 2368907, Added
829: -- return ; -- Bug 2368907, Commented
830: END IF ;
831:
832: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
833: X_award_id := P_AWARD_ID ;
834: x_adl_rec.award_set_id := x_award_set_id ;
835: X_adl_rec.adl_line_num := 1 ;
836: X_adl_rec.project_id := X_project_id ;

Line 860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');

856: /* Commenting out NOCOPY the code below as it is not relevant here... bug 2596697
857: */ -- Commented out NOCOPY the code above as it is irrelevant. Bug 2596697
858:
859: IF L_DEBUG = 'Y' THEN
860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');
861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN

Line 862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

858:
859: IF L_DEBUG = 'Y' THEN
860: gms_error_pkg.gms_debug('GMS: Before call to gms_awards_dist_pkg.create_adl', 'C');
861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN
865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');
866: END IF;

Line 865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');

861: END IF;
862: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
863:
864: IF L_DEBUG = 'Y' THEN
865: gms_error_pkg.gms_debug('GMS: After call to gms_awards_dist_pkg.create_adl', 'C');
866: END IF;
867:
868: EXCEPTION
869: WHEN invalid_award THEN -- Bug 2368907, Added

Line 889: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

885: X_TXN_XFACE_ID NUMBER ;
886: X_award_id NUMBER ;
887: BEGIN
888: FOR LD_REC IN C_GOLD LOOP
889: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
890: x_txn_xface_id := LD_REC.TXN_INTERFACE_ID ;
891: X_award_id := get_award_id( LD_REC.AWARD_ID, LD_REC.AWARD_NUMBER);
892: --LD_REC.AWARD_ID ; -- Bug 3221039
893: x_adl_rec.award_set_id := x_award_set_id ;

Line 919: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

915:
916: /* Commenting the whole code below as it is not relevant for txns coming from LD distributions
917: **/ -- Commented all the above code as it is irrelevant bug 2596697
918:
919: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
920:
921: -- bug : 3684711 UNABLE TO ENTER A REVERSAL BATCH GMS_AWARD_REQD
922: -- Create award distribution line for the reversal item.
923: IF ld_rec.period_end_accrual_flag = 'Y' and

Line 932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;

928: from pa_expenditure_items_all ei
929: where ei.adjusted_expenditure_item_id = x_ei_id ;
930: IF SQL%FOUND THEN
931: x_adl_rec.raw_cost := X_raw_cost * -1 ;
932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
933: x_adl_rec.award_set_id := x_award_set_id ;
934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
935: END IF ;
936:

Line 934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;

930: IF SQL%FOUND THEN
931: x_adl_rec.raw_cost := X_raw_cost * -1 ;
932: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
933: x_adl_rec.award_set_id := x_award_set_id ;
934: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
935: END IF ;
936:
937: END IF ;
938: -- end of bug : 3684711 Fix.