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 904: -- The gms_award_exp_type_act_cost is updated in

900:
901: close c_award_exp_total;
902: -- ---------------------------------------------------
903: -- Find out NOCOPY the unposted balances from GMS_BC_PACKETS
904: -- The gms_award_exp_type_act_cost is updated in
905: -- gms_gl_return_code process and burden_posted_flag
906: -- is updated to 'Y'. It is possible that there exists
907: -- some records for which funds_check has approved and
908: -- amounts are not posted.

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

996: END IF;
997: -- We couldn't acquire the locks at this time so
998: -- We need to abort the processing and have the
999: -- stataus Failed .
1000: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST
1001: -- ------------------------------------------------------------
1002: IF get_burden_cost_limit%ISOPEN THEN
1003: CLOSE get_burden_cost_limit ;
1004: END IF ;

Line 4345: -- gms_award_exp_type_act_cost table.

4341:
4342: -- ------------------------------------------------------------------------
4343: -- We need to calculate the award and exptype balance at this point of time
4344: -- based on unposted records and available balance into
4345: -- gms_award_exp_type_act_cost table.
4346: -- -------------------------------------------------------------------------
4347: SAVEPOINT SAVE_CALC_AWARD_EXP ;
4348: BEGIN
4349:

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

4450: WHEN RESOURCE_BUSY THEN
4451: -- We couldn't acquire the locks at this time so
4452: -- We need to abort the processing and have the
4453: -- stataus Failed .
4454: -- F40 - Unable to acquire Locks on GMS_AWARD_EXP_TYPE_ACT_COST
4455: -- ------------------------------------------------------------
4456:
4457: ROLLBACK to SAVE_CALC_AWARD_EXP ;
4458: