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.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_PLSQL_DATATYPES

Line 72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

68:
69: l_etc_quantity_pc_pfc NUMBER;
70:
71: /* For TC amounts */
72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

69: l_etc_quantity_pc_pfc NUMBER;
70:
71: /* For TC amounts */
72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;

Line 74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

70:
71: /* For TC amounts */
72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;
78:

Line 75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

71: /* For TC amounts */
72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;
78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

72: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;
78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

75: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;
78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

76: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_tot_quantity_sum NUMBER;
78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
84: l_act_quantity_sum NUMBER;

Line 81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

77: l_tot_quantity_sum NUMBER;
78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
84: l_act_quantity_sum NUMBER;
85:

Line 82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

78:
79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
84: l_act_quantity_sum NUMBER;
85:
86: /* ForPFC amounts */

Line 83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

79: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
80: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
81: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
82: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
83: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
84: l_act_quantity_sum NUMBER;
85:
86: /* ForPFC amounts */
87: l_pfc_currency_code pa_projects_all.project_currency_code%type;

Line 92: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

88: l_rev_gen_method VARCHAR2(3);
89:
90:
91: /* For ETC amounts */
92: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_etc_quantity_sum NUMBER;
94:
95: l_currency_count_act_min_tot NUMBER;
96: l_currency_prorate_act_flag VARCHAR2(1);

Line 100: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

96: l_currency_prorate_act_flag VARCHAR2(1);
97: l_exit_flag VARCHAR2(1) := 'N';
98:
99: /*For PC_TC amounts*/
100: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
101: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
104: l_tot_quantity_pc_sum NUMBER;

Line 101: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

97: l_exit_flag VARCHAR2(1) := 'N';
98:
99: /*For PC_TC amounts*/
100: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
101: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
104: l_tot_quantity_pc_sum NUMBER;
105: l_act_quantity_pc_sum NUMBER;

Line 102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

98:
99: /*For PC_TC amounts*/
100: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
101: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
104: l_tot_quantity_pc_sum NUMBER;
105: l_act_quantity_pc_sum NUMBER;
106: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

99: /*For PC_TC amounts*/
100: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
101: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
104: l_tot_quantity_pc_sum NUMBER;
105: l_act_quantity_pc_sum NUMBER;
106: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
107: l_etc_quantity_pc_sum NUMBER;

Line 106: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

102: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
103: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
104: l_tot_quantity_pc_sum NUMBER;
105: l_act_quantity_pc_sum NUMBER;
106: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
107: l_etc_quantity_pc_sum NUMBER;
108:
109: /*For average rates*/
110: l_pc_pfc_rate_quantity NUMBER;

Line 129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

125: l_pc_pfc_raw_cost_rate NUMBER;
126: l_pc_pfc_brdn_cost_rate NUMBER;
127: l_pc_pfc_revenue_rate NUMBER;
128:
129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

126: l_pc_pfc_brdn_cost_rate NUMBER;
127: l_pc_pfc_revenue_rate NUMBER;
128:
129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

127: l_pc_pfc_revenue_rate NUMBER;
128:
129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_transaction_source_code VARCHAR2(30);

Line 132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

128:
129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_transaction_source_code VARCHAR2(30);
136:

Line 133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

129: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_transaction_source_code VARCHAR2(30);
136:
137: /*For txn currency conversion*/

Line 134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

130: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_transaction_source_code VARCHAR2(30);
136:
137: /*For txn currency conversion*/
138: l_task_id pa_tasks.task_id%type;

Line 1233: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

1229: l_prorating_always_flag VARCHAR2(1);
1230: l_target_version_type pa_budget_versions.version_type%type;
1231:
1232: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
1233: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1234: l_src_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp; /* Created for bug fix 4117267*/
1235: l_cmt_count NUMBER;
1236:
1237: /* For PC amounts */

Line 1234: l_src_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp; /* Created for bug fix 4117267*/

1230: l_target_version_type pa_budget_versions.version_type%type;
1231:
1232: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
1233: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1234: l_src_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp; /* Created for bug fix 4117267*/
1235: l_cmt_count NUMBER;
1236:
1237: /* For PC amounts */
1238: l_pc_currency_code pa_projects_all.project_currency_code%type;

Line 1252: l_etc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1248: l_pfc_currency_code pa_projects_all.project_currency_code%type;
1249: l_rev_gen_method VARCHAR2(3);
1250:
1251: /* For TC amounts */
1252: l_etc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1253: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1254: l_etc_quantity_sum NUMBER;
1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1253: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

1249: l_rev_gen_method VARCHAR2(3);
1250:
1251: /* For TC amounts */
1252: l_etc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1253: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1254: l_etc_quantity_sum NUMBER;
1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1252: l_etc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1253: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1254: l_etc_quantity_sum NUMBER;
1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;

Line 1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

1253: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1254: l_etc_quantity_sum NUMBER;
1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;
1261:

Line 1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

1254: l_etc_quantity_sum NUMBER;
1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;
1261:
1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

1255:
1256: l_cmt_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1257: l_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;
1261:
1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1263: l_etc_noncmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

1258: l_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;
1261:
1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1263: l_etc_noncmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1264: l_etc_noncmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1265: l_etc_noncmt_quantity_sum NUMBER;
1266:

Line 1263: l_etc_noncmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

1259: l_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1260: l_cmt_quantity_sum NUMBER;
1261:
1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1263: l_etc_noncmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1264: l_etc_noncmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1265: l_etc_noncmt_quantity_sum NUMBER;
1266:
1267: /*For PC_TC amounts*/

Line 1264: l_etc_noncmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

1260: l_cmt_quantity_sum NUMBER;
1261:
1262: l_etc_noncmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
1263: l_etc_noncmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1264: l_etc_noncmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1265: l_etc_noncmt_quantity_sum NUMBER;
1266:
1267: /*For PC_TC amounts*/
1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1264: l_etc_noncmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1265: l_etc_noncmt_quantity_sum NUMBER;
1266:
1267: /*For PC_TC amounts*/
1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1269: l_etc_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;

Line 1269: l_etc_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1265: l_etc_noncmt_quantity_sum NUMBER;
1266:
1267: /*For PC_TC amounts*/
1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1269: l_etc_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;
1273:

Line 1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1266:
1267: /*For PC_TC amounts*/
1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1269: l_etc_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;
1273:
1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM

1267: /*For PC_TC amounts*/
1268: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1269: l_etc_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;
1273:
1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1270: l_etc_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;
1273:
1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1277: l_cmt_quantity_pc_sum NUMBER;
1278:

Line 1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1271: l_etc_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp; -- Added for IPM
1272: l_etc_quantity_pc_sum NUMBER;
1273:
1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1277: l_cmt_quantity_pc_sum NUMBER;
1278:
1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1272: l_etc_quantity_pc_sum NUMBER;
1273:
1274: l_cmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1277: l_cmt_quantity_pc_sum NUMBER;
1278:
1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1280: l_etc_noncmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1275: l_cmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1277: l_cmt_quantity_pc_sum NUMBER;
1278:
1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1280: l_etc_noncmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1281: l_etc_noncmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1282: l_etc_noncmt_quantity_pc_sum NUMBER;
1283:

Line 1280: l_etc_noncmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1276: l_cmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1277: l_cmt_quantity_pc_sum NUMBER;
1278:
1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1280: l_etc_noncmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1281: l_etc_noncmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1282: l_etc_noncmt_quantity_pc_sum NUMBER;
1283:
1284: /*For average rates*/

Line 1281: l_etc_noncmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

1277: l_cmt_quantity_pc_sum NUMBER;
1278:
1279: l_etc_noncmt_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1280: l_etc_noncmt_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1281: l_etc_noncmt_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
1282: l_etc_noncmt_quantity_pc_sum NUMBER;
1283:
1284: /*For average rates*/
1285: l_pc_pfc_rate_quantity NUMBER;

Line 1297: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1293:
1294: l_pc_pfc_raw_cost_rate NUMBER;
1295: l_pc_pfc_brdn_cost_rate NUMBER;
1296: l_pc_pfc_revenue_rate NUMBER;
1297: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1298: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1299: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1300:
1301: l_transaction_source_code VARCHAR2(30);

Line 1298: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1294: l_pc_pfc_raw_cost_rate NUMBER;
1295: l_pc_pfc_brdn_cost_rate NUMBER;
1296: l_pc_pfc_revenue_rate NUMBER;
1297: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1298: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1299: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1300:
1301: l_transaction_source_code VARCHAR2(30);
1302:

Line 1299: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1295: l_pc_pfc_brdn_cost_rate NUMBER;
1296: l_pc_pfc_revenue_rate NUMBER;
1297: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1298: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1299: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1300:
1301: l_transaction_source_code VARCHAR2(30);
1302:
1303: /*For txn currency conversion*/

Line 1413: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1409: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES';
1410:
1411: -- Variables added for Bug 5203622
1412: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
1413: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1414:
1415: BEGIN
1416: IF p_pa_debug_mode = 'Y' THEN
1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',

Line 2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

2327: this ETC quantity to different planning currencies based on PC amounts,
2328: convert back from PC to TC.
2329: */
2330: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK
2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

2328: convert back from PC to TC.
2329: */
2330: PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK
2331: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

Line 2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

2332: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
2339: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2340: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

2333: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
2339: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2340: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2341: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,

Line 2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,

2334: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2335: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2336: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2337: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
2338: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
2339: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2340: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2341: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
2342: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2373:
2374: l_etc_quantity_pc_pfc NUMBER;
2375:
2376: /* For TC amounts */
2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

2374: l_etc_quantity_pc_pfc NUMBER;
2375:
2376: /* For TC amounts */
2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;

Line 2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2375:
2376: /* For TC amounts */
2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;
2383:

Line 2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2376: /* For TC amounts */
2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;
2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

2377: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2378: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2379: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;
2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2380: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;
2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

2381: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2382: l_tot_quantity_sum NUMBER;
2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2389: l_act_quantity_sum NUMBER;

Line 2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2382: l_tot_quantity_sum NUMBER;
2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2389: l_act_quantity_sum NUMBER;
2390:

Line 2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2383:
2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2389: l_act_quantity_sum NUMBER;
2390:
2391: /* ForPFC amounts */

Line 2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

2384: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2385: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2386: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2387: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2388: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2389: l_act_quantity_sum NUMBER;
2390:
2391: /* ForPFC amounts */
2392: l_pfc_currency_code pa_projects_all.project_currency_code%type;

Line 2397: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

2393: l_rev_gen_method VARCHAR2(3);
2394:
2395:
2396: /* For ETC amounts */
2397: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2398: l_etc_quantity_sum NUMBER;
2399:
2400: l_currency_count_act_min_tot NUMBER;
2401: l_currency_prorate_act_flag VARCHAR2(1);

Line 2405: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

2401: l_currency_prorate_act_flag VARCHAR2(1);
2402: l_exit_flag VARCHAR2(1) := 'N';
2403:
2404: /*For PC_TC amounts*/
2405: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2406: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2409: l_tot_quantity_pc_sum NUMBER;

Line 2406: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

2402: l_exit_flag VARCHAR2(1) := 'N';
2403:
2404: /*For PC_TC amounts*/
2405: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2406: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2409: l_tot_quantity_pc_sum NUMBER;
2410: l_act_quantity_pc_sum NUMBER;

Line 2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

2403:
2404: /*For PC_TC amounts*/
2405: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2406: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2409: l_tot_quantity_pc_sum NUMBER;
2410: l_act_quantity_pc_sum NUMBER;
2411: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

2404: /*For PC_TC amounts*/
2405: l_tot_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2406: l_tot_raw_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2409: l_tot_quantity_pc_sum NUMBER;
2410: l_act_quantity_pc_sum NUMBER;
2411: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2412: l_etc_quantity_pc_sum NUMBER;

Line 2411: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;

2407: l_tot_brdn_cost_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2408: l_tot_revenue_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2409: l_tot_quantity_pc_sum NUMBER;
2410: l_act_quantity_pc_sum NUMBER;
2411: l_etc_quantity_pc_tab PA_PLSQL_DATATYPES.NumTabTyp;
2412: l_etc_quantity_pc_sum NUMBER;
2413:
2414: /*For average rates*/
2415: l_pc_pfc_rate_quantity NUMBER;

Line 2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2430: l_pc_pfc_raw_cost_rate NUMBER;
2431: l_pc_pfc_brdn_cost_rate NUMBER;
2432: l_pc_pfc_revenue_rate NUMBER;
2433:
2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2431: l_pc_pfc_brdn_cost_rate NUMBER;
2432: l_pc_pfc_revenue_rate NUMBER;
2433:
2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2432: l_pc_pfc_revenue_rate NUMBER;
2433:
2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2440: l_transaction_source_code VARCHAR2(30);

Line 2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2433:
2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2440: l_transaction_source_code VARCHAR2(30);
2441:

Line 2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2434: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2440: l_transaction_source_code VARCHAR2(30);
2441:
2442: /*For txn currency conversion*/

Line 2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

2435: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2436: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2437: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2438: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2439: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
2440: l_transaction_source_code VARCHAR2(30);
2441:
2442: /*For txn currency conversion*/
2443: l_task_id pa_tasks.task_id%type;

Line 2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2471: continue_loop EXCEPTION;
2472: l_dummy NUMBER;
2473:
2474: l_ins_index BINARY_INTEGER;
2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2472: l_dummy NUMBER;
2473:
2474: l_ins_index BINARY_INTEGER;
2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2473:
2474: l_ins_index BINARY_INTEGER;
2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

2474: l_ins_index BINARY_INTEGER;
2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2475: l_ins_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2476: l_ins_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

2477: l_ins_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2478: l_ins_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2479: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

2480: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2488:

Line 2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2481: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2488:
2489: l_msg_count NUMBER;

Line 2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

2482: l_ins_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2488:
2489: l_msg_count NUMBER;
2490: l_msg_data VARCHAR2(2000);

Line 2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

2483: l_ins_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2484: l_ins_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2485: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2486: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
2487: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
2488:
2489: l_msg_count NUMBER;
2490: l_msg_data VARCHAR2(2000);
2491: l_data VARCHAR2(2000);

Line 2503: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2499: l_tot_revenue_sum NUMBER;
2500: l_tot_raw_cost_pc_sum NUMBER;
2501: l_tot_revenue_pc_sum NUMBER;
2502: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
2503: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2504: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2505:
2506: BEGIN
2507: IF p_pa_debug_mode = 'Y' THEN

Line 2504: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2500: l_tot_raw_cost_pc_sum NUMBER;
2501: l_tot_revenue_pc_sum NUMBER;
2502: l_other_rej_code PA_BUDGET_LINES.OTHER_REJECTION_CODE%TYPE;
2503: l_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2504: l_ins_other_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2505:
2506: BEGIN
2507: IF p_pa_debug_mode = 'Y' THEN
2508: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',