APPS.GMS_COST_PLUS_EXTN dependencies on GMS_AWARD_EXP_TYPE_ACT_COST

Line 33: from gms_award_exp_type_act_cost

29: -- This cursor and variable will be used to lock the summary table ...
30: -- Used in update_bc_pkt_burden_raw_cost and Maximize_burden
31: Cursor c_lock_burden_summary(p_award_id in number,p_exp_type in varchar2) is
32: select 1
33: from gms_award_exp_type_act_cost
34: where award_id = p_award_id
35: and expenditure_type = p_exp_type
36: for update;
37:

Line 87: FROM gms_award_exp_type_act_cost act

83: nvl(act.po_burdenable_cost,0) po_burdenable_cost,
84: nvl(act.enc_burdenable_cost,0) enc_burdenable_cost,
85: nvl(act.ap_burdenable_cost,0) ap_burdenable_cost,
86: nvl(act.exp_burdenable_cost,0) exp_burdenable_cost
87: FROM gms_award_exp_type_act_cost act
88: WHERE act.award_id = P_award_id
89: AND act.expenditure_type = P_EXP_TYPE
90: FOR UPDATE OF REQ_RAW_COST NOWAIT;
91:

Line 637: -- The gms_award_exp_type_act_cost is updated in

633:
634: close c_award_exp_total;
635: -- ---------------------------------------------------
636: -- Find out NOCOPY the unposted balances from GMS_BC_PACKETS
637: -- The gms_award_exp_type_act_cost is updated in
638: -- gms_gl_return_code process and burden_posted_flag
639: -- is updated to 'Y'. It is possible that there exists
640: -- some records for which funds_check has approved and
641: -- amounts are not posted.

Line 733: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST

729: END IF;
730: -- We couldn't acquire the locks at this time so
731: -- We need to abort the processing and have the
732: -- stataus Failed .
733: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST
734: -- ------------------------------------------------------------
735: IF get_burden_cost_limit%ISOPEN THEN
736: CLOSE get_burden_cost_limit ;
737: END IF ;

Line 3963: -- gms_award_exp_type_act_cost table.

3959:
3960: -- ------------------------------------------------------------------------
3961: -- We need to calculate the award and exptype balance at this point of time
3962: -- based on unposted records and available balance into
3963: -- gms_award_exp_type_act_cost table.
3964: -- -------------------------------------------------------------------------
3965: SAVEPOINT SAVE_CALC_AWARD_EXP ;
3966: BEGIN
3967:

Line 4072: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST

4068: WHEN RESOURCE_BUSY THEN
4069: -- We couldn't acquire the locks at this time so
4070: -- We need to abort the processing and have the
4071: -- stataus Failed .
4072: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST
4073: -- ------------------------------------------------------------
4074:
4075: ROLLBACK to SAVE_CALC_AWARD_EXP ;
4076: