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 596: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id

592: ,pa_projects_all pp
593: ,pa_project_types_all pt
594: where pkt.packet_id = p_packet_id
595: and pkt.document_line_id is NOT NULL -- with R12 this check is not sufficient to find if the PO is an CWK PO
596: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id
597: ,pkt.document_distribution_id,pkt.org_id) = 'Y' -- R12 Funds management uptake
598: and pkt.document_type in ('PO') --,'EXP')
599: and pkt.status_code in ('P','A','C','I')
600: and substr(NVL(pkt.result_code,'P'),1,1) = 'P'

Line 2035: SELECT pa_funds_control_utils2.is_CWK_PO

2031: l_new_rec_index NUMBER;
2032:
2033: -- Cursor to fetch PO details for PO relieving record
2034: CURSOR c_po_cwk_accrue_details_cur(p_po_distribution_id NUMBER) IS
2035: SELECT pa_funds_control_utils2.is_CWK_PO
2036: (po.po_header_id,
2037: po.po_line_id,
2038: po.po_distribution_id,
2039: po.org_id) cwk_po_flag,

Line 2722: (pa_funds_control_utils2.is_CWK_PO -- Bug 5494476

2718: AND apd.po_distribution_id IS NOT NULL
2719: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y' -- Bug 5348212
2720: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))
2721: OR
2722: (pa_funds_control_utils2.is_CWK_PO -- Bug 5494476
2723: (pod.po_header_id,pod.po_line_id,pod.po_distribution_id,pod.org_id) = 'Y'
2724: AND apd.line_type_lookup_code IN ('ITEM','NONREC_TAX') -- Bug 5533290
2725: AND NVL(apd.amount_variance,0)= 0
2726: AND NVL(apd.base_amount_variance,0)=0

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

3318: END IF;
3319:
3320: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3321: pa_funds_control_pkg.log_message(p_msg_token1 => 'After deriving DR and CR column ');
3322: pa_funds_control_pkg.log_message(p_msg_token1 => 'Calling pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER');
3323: End if;
3324:
3325: -- Code to populate budget_version_id
3326: g_tab_budget_version_id(l_index)

Line 3327: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3323: End if;
3324:
3325: -- Code to populate budget_version_id
3326: g_tab_budget_version_id(l_index)
3327: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3328: (g_tab_project_id(l_index),'GL','BASELINE');
3329: If (g_tab_budget_version_id(l_index) is NULL ) Then
3330:
3331: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN

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

3333: End if;
3334: g_tab_result_code(l_index) := 'F166';
3335: g_tab_status_code(l_index) := 'R';
3336: g_tab_fck_reqd_flag(l_index) := 'Y';
3337: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3338: (g_tab_project_id(l_index),'GL','DRAFT'),-9999);
3339:
3340: GOTO END_OF_AP_LOOP; -- process next record
3341:

Line 3583: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER

3579: End if;
3580:
3581: -- Code to populate budget_version_id
3582: g_tab_budget_version_id(l_index)
3583: := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3584: (g_tab_project_id(l_index),'GL','BASELINE');
3585: If (g_tab_budget_version_id(l_index) is NULL ) Then
3586: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3587: pa_funds_control_pkg.log_message(p_msg_token1 => 'Budget derivation failed marking to F166 ');

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

3588: End if;
3589: g_tab_result_code(l_index) := 'F166';
3590: g_tab_status_code(l_index) := 'R';
3591: g_tab_fck_reqd_flag(l_index) := 'Y';
3592: g_tab_budget_version_id(l_index) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
3593: (g_tab_project_id(l_index),'GL','DRAFT'),-9999);
3594:
3595: GOTO END_OF_REQ_LOOP;
3596:

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

4224: ** ***************************************************************************************/
4225: g_cwk_po_unreserve := 'N' ;
4226: FOR c_rate_po in is_cwk_po_unreserve LOOP
4227:
4228: IF pa_funds_control_utils2.is_cwk_po(c_rate_po.document_header_id,
4229: c_rate_po.document_line_id,
4230: NULL,
4231: c_rate_po.org_id) = 'Y' THEN
4232: g_project_id_tab.delete ;

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

9128: g_tab_pkt_reference1(i) := g_tab_doc_type(i);
9129: g_tab_pkt_reference2(i) := g_tab_doc_header_id(i);
9130: g_tab_pkt_reference3(i) := g_tab_doc_distribution_id(i);
9131:
9132: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9133: (g_tab_project_id(i),'GL','BASELINE');
9134: If (g_tab_budget_version_id(i) is NULL ) Then
9135: g_tab_result_code(i) := 'F166';
9136: g_tab_status_code(i) := 'R';

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

9134: If (g_tab_budget_version_id(i) is NULL ) Then
9135: g_tab_result_code(i) := 'F166';
9136: g_tab_status_code(i) := 'R';
9137: g_tab_fck_reqd_flag(i) := 'Y';
9138: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9139: (g_tab_project_id(i),'GL','DRAFT'),-9999);
9140:
9141: End If;
9142: pa_funds_control_pkg.log_message(p_msg_token1 => 'igc cursor Bdgt_Version['

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

9223: If g_tab_rowid.EXISTS(1) then
9224: /* added for bug fix: 3086398 */
9225: FOR i IN g_tab_rowid.FIRST .. g_tab_rowid.LAST LOOP
9226: g_tab_doc_line_id(i) := NULL;
9227: g_tab_budget_version_id(i) := pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9228: (g_tab_project_id(i),'CC','BASELINE');
9229: If (g_tab_budget_version_id(i) is NULL ) Then
9230: g_tab_result_code(i) := 'F166';
9231: g_tab_status_code(i) := 'R';

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

9229: If (g_tab_budget_version_id(i) is NULL ) Then
9230: g_tab_result_code(i) := 'F166';
9231: g_tab_status_code(i) := 'R';
9232: g_tab_fck_reqd_flag(i) := 'Y';
9233: g_tab_budget_version_id(i) := NVL(pa_funds_control_utils2.GET_DRAFTORBASELINE_BDGTVER
9234: (g_tab_project_id(i),'CC','DRAFT'),-9999);
9235:
9236: End If;
9237: END LOOP;