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_FUNDS_CONTROL_PKG1 dependencies on PA_FUNDS_CONTROL_UTILS2

Line 611: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id

607: ,pa_projects_all pp
608: ,pa_project_types_all pt
609: where pkt.packet_id = p_packet_id
610: and pkt.document_line_id is NOT NULL -- with R12 this check is not sufficient to find if the PO is an CWK PO
611: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id
612: ,pkt.document_distribution_id,pkt.org_id) = 'Y' -- R12 Funds management uptake
613: and pkt.document_type in ('PO') --,'EXP')
614: and pkt.status_code in ('P','A','C','I')
615: and substr(NVL(pkt.result_code,'P'),1,1) = 'P'

Line 2081: SELECT pa_funds_control_utils2.is_CWK_PO

2077: l_new_rec_index NUMBER;
2078:
2079: -- Cursor to fetch PO details for PO relieving record
2080: CURSOR c_po_cwk_accrue_details_cur(p_po_distribution_id NUMBER) IS
2081: SELECT pa_funds_control_utils2.is_CWK_PO
2082: (po.po_header_id,
2083: po.po_line_id,
2084: po.po_distribution_id,
2085: po.org_id) cwk_po_flag,

Line 2769: (pa_funds_control_utils2.is_CWK_PO -- Bug 5494476

2765: AND apd.po_distribution_id IS NOT NULL
2766: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y' -- Bug 5348212
2767: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))
2768: OR
2769: (pa_funds_control_utils2.is_CWK_PO -- Bug 5494476
2770: (pod.po_header_id,pod.po_line_id,pod.po_distribution_id,pod.org_id) = 'Y'
2771: AND apd.line_type_lookup_code IN ('ITEM','NONREC_TAX') -- Bug 5533290
2772: AND NVL(apd.amount_variance,0)= 0
2773: AND NVL(apd.base_amount_variance,0)=0

Line 2829: (pa_funds_control_utils2.is_CWK_PO

2825: AND apd.po_distribution_id IS NOT NULL
2826: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
2827: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))
2828: OR
2829: (pa_funds_control_utils2.is_CWK_PO
2830: (pod.po_header_id,pod.po_line_id,pod.po_distribution_id,pod.org_id) = 'Y'
2831: AND apd.line_type_lookup_code IN ('ITEM','NONREC_TAX')
2832: AND NVL(apd.amount_variance,0)= 0
2833: AND NVL(apd.base_amount_variance,0)=0

Line 3601: pa_funds_control_pkg.log_message(p_msg_token1 => 'Calling pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER');

3597: END IF;
3598:
3599: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3600: pa_funds_control_pkg.log_message(p_msg_token1 => 'After deriving DR and CR column ');
3601: pa_funds_control_pkg.log_message(p_msg_token1 => 'Calling pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER');
3602: End if;
3603:
3604: -- Code to populate budget_version_id
3605: g_tab_budget_version_id(l_index)

Line 3606: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3602: End if;
3603:
3604: -- Code to populate budget_version_id
3605: g_tab_budget_version_id(l_index)
3606: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3607: (g_tab_project_id(l_index),'GL','BASELINE');
3608: If (g_tab_budget_version_id(l_index) is NULL ) Then
3609:
3610: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN

Line 3616: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3612: End if;
3613: g_tab_result_code(l_index) := 'F166';
3614: g_tab_status_code(l_index) := 'R';
3615: g_tab_fck_reqd_flag(l_index) := 'Y';
3616: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3617: (g_tab_project_id(l_index),'GL','DRAFT'),-9999);
3618: -- Added as part of bug 13638904
3619: fnd_message.set_name('PA','PA_BC_NO_BASELINE_BGT');
3620: PSA_BC_XLA_PVT.psa_xla_error('PA_BC_NO_BASELINE_BGT',g_tab_source_event_id(l_index));

Line 3865: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3861: End if;
3862:
3863: -- Code to populate budget_version_id
3864: g_tab_budget_version_id(l_index)
3865: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3866: (g_tab_project_id(l_index),'GL','BASELINE');
3867: If (g_tab_budget_version_id(l_index) is NULL ) Then
3868: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3869: pa_funds_control_pkg.log_message(p_msg_token1 => 'Budget derivation failed marking to F166 ');

Line 3874: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3870: End if;
3871: g_tab_result_code(l_index) := 'F166';
3872: g_tab_status_code(l_index) := 'R';
3873: g_tab_fck_reqd_flag(l_index) := 'Y';
3874: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3875: (g_tab_project_id(l_index),'GL','DRAFT'),-9999);
3876: -- Added as part of bug 13638904
3877: fnd_message.set_name('PA','PA_BC_NO_BASELINE_BGT');
3878: PSA_BC_XLA_PVT.psa_xla_error('PA_BC_NO_BASELINE_BGT',g_tab_source_event_id(l_index));

Line 4517: IF pa_funds_control_utils2.is_cwk_po(c_rate_po.document_header_id,

4513: ** ***************************************************************************************/
4514: g_cwk_po_unreserve := 'N' ;
4515: FOR c_rate_po in is_cwk_po_unreserve LOOP
4516:
4517: IF pa_funds_control_utils2.is_cwk_po(c_rate_po.document_header_id,
4518: c_rate_po.document_line_id,
4519: NULL,
4520: c_rate_po.org_id) = 'Y' THEN
4521: g_project_id_tab.delete ;

Line 9520: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

9516: g_tab_pkt_reference1(i) := g_tab_doc_type(i);
9517: g_tab_pkt_reference2(i) := g_tab_doc_header_id(i);
9518: g_tab_pkt_reference3(i) := g_tab_doc_distribution_id(i);
9519:
9520: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9521: (g_tab_project_id(i),'GL','BASELINE');
9522: If (g_tab_budget_version_id(i) is NULL ) Then
9523: g_tab_result_code(i) := 'F166';
9524: g_tab_status_code(i) := 'R';

Line 9526: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

9522: If (g_tab_budget_version_id(i) is NULL ) Then
9523: g_tab_result_code(i) := 'F166';
9524: g_tab_status_code(i) := 'R';
9525: g_tab_fck_reqd_flag(i) := 'Y';
9526: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9527: (g_tab_project_id(i),'GL','DRAFT'),-9999);
9528: -- Added as part of bug 13638904
9529: fnd_message.set_name('PA','PA_BC_NO_BASELINE_BGT');
9530: PSA_BC_XLA_PVT.psa_xla_error('PA_BC_NO_BASELINE_BGT',g_tab_source_event_id(i));

Line 9618: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

9614: If g_tab_rowid.EXISTS(1) then
9615: /* added for bug fix: 3086398 */
9616: FOR i IN g_tab_rowid.FIRST .. g_tab_rowid.LAST LOOP
9617: g_tab_doc_line_id(i) := NULL;
9618: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9619: (g_tab_project_id(i),'CC','BASELINE');
9620: If (g_tab_budget_version_id(i) is NULL ) Then
9621: g_tab_result_code(i) := 'F166';
9622: g_tab_status_code(i) := 'R';

Line 9624: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

9620: If (g_tab_budget_version_id(i) is NULL ) Then
9621: g_tab_result_code(i) := 'F166';
9622: g_tab_status_code(i) := 'R';
9623: g_tab_fck_reqd_flag(i) := 'Y';
9624: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9625: (g_tab_project_id(i),'CC','DRAFT'),-9999);
9626: -- Added as part of bug 13638904
9627: fnd_message.set_name('PA','PA_BC_NO_BASELINE_BGT');
9628: PSA_BC_XLA_PVT.psa_xla_error('PA_BC_NO_BASELINE_BGT',g_tab_source_event_id(i));