[Home] [Help]
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
640: select 'Y'
641: from dual
642: Where exists
643: (select null
644: from pa_bc_commitments_all comm
645: where comm.project_id = l_project_id
646: and comm.task_id = l_task_id
647: and comm.budget_version_id = l_budget_version_id
648: and comm.document_line_id = l_document_line_id
800: CLOSE cur_cwk_amts;
801: pa_funds_control_pkg.log_message(p_msg_token1 => 'CommRawAmt['||l_comm_raw_amt||']CommbdAmt['||l_comm_bd_amt||
802: ']RelvdComm['||l_relvd_comm_raw_amt||']RelvdBd['||l_relvd_comm_bd_amt||']');
803: l_rows_updated := 0;
804: UPDATE pa_bc_commitments_all com
805: SET com.comm_tot_raw_amt = nvl(com.comm_tot_raw_amt,0) +
806: decode(p_calling_module,'GL',decode(cwk.line_type,'RAW',nvl(l_comm_raw_amt,0),0),0)
807: ,com.comm_tot_bd_amt = nvl(com.comm_tot_bd_amt,0) +
808: decode(p_calling_module,'GL'
993: If l_cwk_multiplier is NOT NULL Then
994: l_cwk_multiplier := pa_currency.round_trans_currency_amt
995: (l_cwk_multiplier,g_acct_currency_code);
996: End If;
997: UPDATE pa_bc_commitments_all cmt
998: SET cmt.compiled_multiplier = decode (cmt.document_line_id,NULL,cmt.compiled_multiplier,
999: l_cwk_multiplier)
1000: WHERE cmt.summary_record_flag = 'Y'
1001: AND cmt.document_line_id is NOT NULL
5120: --
5121: -- Bug : 3703180
5122: -- PJ.M:B5:P1:QA:CWK: PAXBLRSL- -VE COMMITMENT CREATED WHEN PO CANCELLED AFTER
5123: -- Resolution : Compare the burden cost calculated with the summary record in
5124: -- pa_bc_packets /pa_bc_commitments_all. We are using the amounts in the summary
5125: -- table if summary has amounts less than the calculated in pa bc packets.
5126: -- If we have zero burden in pa bc packets then we use the entire amounts in
5127: -- the summary record.
5128: --
5234:
5235: --
5236: -- BUG 3703180
5237: -- Different line burdening setup.
5238: -- We determine the summary record from pa bc packets or pa bc commitments all table.
5239: -- compare the summary amounts with the pa bc packets burden and use the one less than
5240: -- the other. If pa bc packets burden cost is ZERO than we use the burden cost from the
5241: -- summary table record.
5242: --
6551: * nvl(pkttrx.accounted_cr,0) accounted_cr,
6552: /* End : Bug 13911609*/
6553: pktburd.expenditure_type,
6554: pktburd.compiled_multiplier
6555: FROM pa_bc_commitments_all pktburd
6556: ,pa_bc_commitments_all pktraw
6557: ,pa_bc_packets pkttrx
6558: WHERE pktburd.document_distribution_id = l_req_id
6559: AND pktburd.document_header_id = l_po_header_id
6552: /* End : Bug 13911609*/
6553: pktburd.expenditure_type,
6554: pktburd.compiled_multiplier
6555: FROM pa_bc_commitments_all pktburd
6556: ,pa_bc_commitments_all pktraw
6557: ,pa_bc_packets pkttrx
6558: WHERE pktburd.document_distribution_id = l_req_id
6559: AND pktburd.document_header_id = l_po_header_id
6560: AND pktburd.document_type = l_comm_doc_type
8429: AND gl.set_of_books_id = pbc.set_of_books_id
8430: AND gl.period_name = pbc.period_name) gl_start_date,
8431: pbc.exp_item_id,
8432: pbc.transfer_status_code
8433: FROM pa_bc_commitments_all pbc,
8434: pa_tasks pt,
8435: pa_budget_versions bv,
8436: pa_budget_entry_methods pm
8437: WHERE pbc.document_header_id = p_doc_header_id