APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_BC_COMMITMENTS_ALL

Line 299: from pa_bc_commitments_all com

295: ,sum(decode(com.parent_bc_packet_id, NULL,(nvl(com.accounted_dr,0) - nvl(com.accounted_cr,0)),0)
296: ) ComRawAmt
297: Into l_combdamt
298: ,l_comrawamt
299: from pa_bc_commitments_all com
300: where com.project_id = p_project_id
301: and com.task_id = p_task_id
302: and com.budget_version_id = p_budget_version_id
303: and com.document_line_id = p_document_line_id

Line 629: from pa_bc_commitments_all comm

625: select 'Y'
626: from dual
627: Where exists
628: (select null
629: from pa_bc_commitments_all comm
630: where comm.project_id = l_project_id
631: and comm.task_id = l_task_id
632: and comm.budget_version_id = l_budget_version_id
633: and comm.document_line_id = l_document_line_id

Line 789: UPDATE pa_bc_commitments_all com

785: CLOSE cur_cwk_amts;
786: pa_funds_control_pkg.log_message(p_msg_token1 => 'CommRawAmt['||l_comm_raw_amt||']CommbdAmt['||l_comm_bd_amt||
787: ']RelvdComm['||l_relvd_comm_raw_amt||']RelvdBd['||l_relvd_comm_bd_amt||']');
788: l_rows_updated := 0;
789: UPDATE pa_bc_commitments_all com
790: SET com.comm_tot_raw_amt = nvl(com.comm_tot_raw_amt,0) +
791: decode(p_calling_module,'GL',decode(cwk.line_type,'RAW',nvl(l_comm_raw_amt,0),0),0)
792: ,com.comm_tot_bd_amt = nvl(com.comm_tot_bd_amt,0) +
793: decode(p_calling_module,'GL'

Line 982: UPDATE pa_bc_commitments_all cmt

978: If l_cwk_multiplier is NOT NULL Then
979: l_cwk_multiplier := pa_currency.round_trans_currency_amt
980: (l_cwk_multiplier,g_acct_currency_code);
981: End If;
982: UPDATE pa_bc_commitments_all cmt
983: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier,
984: l_cwk_multiplier)
985: WHERE cmt.summary_record_flag = 'Y'
986: AND cmt.document_line_id is NOT NULL

Line 4821: -- pa_bc_packets /pa_bc_commitments_all. We are using the amounts in the summary

4817: --
4818: -- Bug : 3703180
4819: -- PJ.M:B5:P1:QA:CWK: PAXBLRSL- -VE COMMITMENT CREATED WHEN PO CANCELLED AFTER
4820: -- Resolution : Compare the burden cost calculated with the summary record in
4821: -- pa_bc_packets /pa_bc_commitments_all. We are using the amounts in the summary
4822: -- table if summary has amounts less than the calculated in pa bc packets.
4823: -- If we have zero burden in pa bc packets then we use the entire amounts in
4824: -- the summary record.
4825: --

Line 4930: -- We determine the summary record from pa bc packets or pa bc commitments all table.

4926:
4927: --
4928: -- BUG 3703180
4929: -- Different line burdening setup.
4930: -- We determine the summary record from pa bc packets or pa bc commitments all table.
4931: -- compare the summary amounts with the pa bc packets burden and use the one less than
4932: -- the other. If pa bc packets burden cost is ZERO than we use the burden cost from the
4933: -- summary table record.
4934: --

Line 6223: FROM pa_bc_commitments_all pktburd

6219: 'BCCMT',
6220: 'A')) accounted_cr,
6221: pktburd.expenditure_type,
6222: pktburd.compiled_multiplier
6223: FROM pa_bc_commitments_all pktburd
6224: ,pa_bc_commitments_all pktraw
6225: ,pa_bc_packets pkttrx
6226: WHERE pktburd.document_distribution_id = l_req_id
6227: AND pktburd.document_header_id = l_po_header_id

Line 6224: ,pa_bc_commitments_all pktraw

6220: 'A')) accounted_cr,
6221: pktburd.expenditure_type,
6222: pktburd.compiled_multiplier
6223: FROM pa_bc_commitments_all pktburd
6224: ,pa_bc_commitments_all pktraw
6225: ,pa_bc_packets pkttrx
6226: WHERE pktburd.document_distribution_id = l_req_id
6227: AND pktburd.document_header_id = l_po_header_id
6228: AND pktburd.document_type = l_comm_doc_type

Line 8059: FROM pa_bc_commitments_all pbc,

8055: AND gl.set_of_books_id = pbc.set_of_books_id
8056: AND gl.period_name = pbc.period_name) gl_start_date,
8057: pbc.exp_item_id,
8058: pbc.transfer_status_code
8059: FROM pa_bc_commitments_all pbc,
8060: pa_tasks pt,
8061: pa_budget_versions bv,
8062: pa_budget_entry_methods pm
8063: WHERE pbc.document_header_id = p_doc_header_id