eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_SWEEPER dependencies on GMS_AWARD_EXP_TYPE_ACT_COST

Line 42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,

38:
39: Upd_Reason_Table Fail_Tab;
40:
41: -- Variables used for recording burdenable raw cost and raw cost -- Bug 4053891
42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,
43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,

39: Upd_Reason_Table Fail_Tab;
40:
41: -- Variables used for recording burdenable raw cost and raw cost -- Bug 4053891
42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,
43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

40:
41: -- Variables used for recording burdenable raw cost and raw cost -- Bug 4053891
42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,
43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

41: -- Variables used for recording burdenable raw cost and raw cost -- Bug 4053891
42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,
43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

42: TYPE Rec_Award_Exp is RECORD(award_id gms_award_exp_type_act_cost.award_id%type,
43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

43: expenditure_type gms_award_exp_type_act_cost.expenditure_type%type,
44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

44: exp_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

45: exp_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);

Line 50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

46: ap_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);
54:

Line 51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

47: ap_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);
54:
55: --TYPE Tab_Award_exp is TABLE OF gms_award_exp_type_act_cost%ROWTYPE;

Line 52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,

48: po_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);
54:
55: --TYPE Tab_Award_exp is TABLE OF gms_award_exp_type_act_cost%ROWTYPE;
56: TYPE Tab_Award_exp is TABLE OF Rec_Award_Exp INDEX by BINARY_INTEGER;

Line 53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);

49: po_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
50: req_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);
54:
55: --TYPE Tab_Award_exp is TABLE OF gms_award_exp_type_act_cost%ROWTYPE;
56: TYPE Tab_Award_exp is TABLE OF Rec_Award_Exp INDEX by BINARY_INTEGER;
57: Tab_Award_exp_burden Tab_Award_exp;

Line 55: --TYPE Tab_Award_exp is TABLE OF gms_award_exp_type_act_cost%ROWTYPE;

51: req_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
52: enc_raw_cost gms_award_exp_type_act_cost.exp_raw_cost%type,
53: enc_burdenable_cost gms_award_exp_type_act_cost.exp_raw_cost%type);
54:
55: --TYPE Tab_Award_exp is TABLE OF gms_award_exp_type_act_cost%ROWTYPE;
56: TYPE Tab_Award_exp is TABLE OF Rec_Award_Exp INDEX by BINARY_INTEGER;
57: Tab_Award_exp_burden Tab_Award_exp;
58:
59: /* -----------------------------------------------------------------------------------------------

Line 77: amounts that needs to be posted to gms_award_exp_type_act_cost

73:
74: /* -----------------------------------------------------------------------------------------------
75: Procedure : Record_burden_amounts (Bug 4053891)
76: Purpose : This procedure will record the burdenable raw cost and the raw cost
77: amounts that needs to be posted to gms_award_exp_type_act_cost
78: -------------------------------------------------------------------------------------------------- */
79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,
80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,
81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,

Line 79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,

75: Procedure : Record_burden_amounts (Bug 4053891)
76: Purpose : This procedure will record the burdenable raw cost and the raw cost
77: amounts that needs to be posted to gms_award_exp_type_act_cost
78: -------------------------------------------------------------------------------------------------- */
79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,
80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,
81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
82: p_burdenable_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
83: p_doc_type IN VARCHAR2,

Line 80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,

76: Purpose : This procedure will record the burdenable raw cost and the raw cost
77: amounts that needs to be posted to gms_award_exp_type_act_cost
78: -------------------------------------------------------------------------------------------------- */
79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,
80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,
81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
82: p_burdenable_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
83: p_doc_type IN VARCHAR2,
84: p_Tab_Award_exp_burden IN OUT NOCOPY Tab_Award_exp,

Line 81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,

77: amounts that needs to be posted to gms_award_exp_type_act_cost
78: -------------------------------------------------------------------------------------------------- */
79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,
80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,
81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
82: p_burdenable_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
83: p_doc_type IN VARCHAR2,
84: p_Tab_Award_exp_burden IN OUT NOCOPY Tab_Award_exp,
85: p_error_code OUT NOCOPY Varchar2

Line 82: p_burdenable_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,

78: -------------------------------------------------------------------------------------------------- */
79: PROCEDURE Record_burden_amounts(p_award_id IN gms_award_exp_type_act_cost.award_id%type,
80: p_exp_type IN gms_award_exp_type_act_cost.expenditure_type%type,
81: p_raw_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
82: p_burdenable_cost IN gms_award_exp_type_act_cost.exp_raw_cost%type,
83: p_doc_type IN VARCHAR2,
84: p_Tab_Award_exp_burden IN OUT NOCOPY Tab_Award_exp,
85: p_error_code OUT NOCOPY Varchar2
86: ) IS

Line 206: amounts to gms_award_exp_type_act_cost

202:
203: /* -----------------------------------------------------------------------------------------------
204: Procedure : Post_burden_amounts (Bug 4053891)
205: Purpose : This procedure will post the burdenable raw cost and the raw cost
206: amounts to gms_award_exp_type_act_cost
207: -------------------------------------------------------------------------------------------------- */
208: PROCEDURE Post_burden_amounts (p_plsql_count IN Number,
209: p_Tab_Award_exp_burden IN Tab_Award_exp,
210: p_error_code OUT NOCOPY Varchar2)

Line 224: -- 2.Update burden summary table: gms_award_exp_type_act_cost

220:
221: -- 1. Get gms_bc_packet records for burdne posting
222: For x in 1..p_plsql_count
223: loop
224: -- 2.Update burden summary table: gms_award_exp_type_act_cost
225: Update gms_award_exp_type_act_cost
226: Set exp_raw_cost = nvl(exp_raw_cost,0) + nvl(p_Tab_Award_exp_burden(x).exp_raw_cost,0),
227: exp_burdenable_cost = nvl(exp_burdenable_cost,0)+ nvl(p_Tab_Award_exp_burden(x).exp_burdenable_cost,0),
228: ap_raw_cost = nvl(ap_raw_cost,0) + nvl(p_Tab_Award_exp_burden(x).ap_raw_cost,0),

Line 225: Update gms_award_exp_type_act_cost

221: -- 1. Get gms_bc_packet records for burdne posting
222: For x in 1..p_plsql_count
223: loop
224: -- 2.Update burden summary table: gms_award_exp_type_act_cost
225: Update gms_award_exp_type_act_cost
226: Set exp_raw_cost = nvl(exp_raw_cost,0) + nvl(p_Tab_Award_exp_burden(x).exp_raw_cost,0),
227: exp_burdenable_cost = nvl(exp_burdenable_cost,0)+ nvl(p_Tab_Award_exp_burden(x).exp_burdenable_cost,0),
228: ap_raw_cost = nvl(ap_raw_cost,0) + nvl(p_Tab_Award_exp_burden(x).ap_raw_cost,0),
229: ap_burdenable_cost = nvl(ap_burdenable_cost,0) + nvl(p_Tab_Award_exp_burden(x).ap_burdenable_cost,0),

Line 241: INSERT INTO GMS_award_exp_type_act_cost (award_id,

237: And expenditure_type = p_Tab_Award_exp_burden(x).expenditure_type;
238:
239: -- 3. If burden summary record does not exist, create it
240: IF SQL%NOTFOUND then
241: INSERT INTO GMS_award_exp_type_act_cost (award_id,
242: expenditure_type,
243: exp_raw_cost,
244: exp_burdenable_cost,
245: ap_raw_cost,