[Home] [Help]
7834: ,g_tab_r_list_id(i)
7835: ,p_packet_id
7836: ,g_tab_bc_packet_id(i)
7837: ,g_tab_project_id(i)
7838: FROM DUAL
7839: WHERE substr(nvl(g_tab_result_code(i),'P'),1,1) not in ('R','F')
7840: AND g_tab_r_list_id(i) = resList.resource_list_id
7841: AND g_tab_budget_version_id(i) = resList.budget_version_id
7842: AND g_tab_category_code(i) = 'R' ;
10409: l_err_code NUMBER := 0;
10410: l_return_code varchar2(1):= 'S';
10411: CURSOR cur_fatal_error IS
10412: SELECT 1
10413: FROM DUAL
10414: WHERE EXISTS (SELECT null
10415: FROM pa_bc_packets
10416: WHERE packet_id = p_packet_id
10417: AND status_code = 'T'
10418: );
10419:
10420: CURSOR cur_normal_error IS
10421: SELECT 1
10422: FROM DUAL
10423: WHERE EXISTS (SELECT null
10424: FROM pa_bc_packets
10425: WHERE packet_id = p_packet_id
10426: AND SUBSTR ( nvl(result_code,'P'), 1, 1 ) = 'F'
10428:
10429: /* To check at least one transaction is passed in partial mode */
10430: CURSOR cur_success_recs IS
10431: SELECT 1
10432: FROM DUAL
10433: WHERE EXISTS (SELECT null
10434: FROM pa_bc_packets
10435: WHERE packet_id = p_packet_id
10436: AND SUBSTR ( nvl(result_code,'P'), 1, 1 ) = 'P'
11780: x_e_stage VARCHAR2(2000);
11781:
11782: CURSOR cur_packets IS
11783: SELECT gl_bc_packets_s.nextval
11784: FROM dual;
11785:
11786: CURSOR cur_sob(v_packet_id number) IS
11787: SELECT set_of_books_id
11788: FROM pa_bc_packets
13711: -- entries by PA (PA_PO_BURDEN) are present and that will synch the records
13712: -- so, the issue is only for non-integrated budgets ..
13713: Cursor cur_ap_matched_case is
13714: SELECT 'Y'
13715: FROM dual
13716: WHERE EXISTS(
13717: select 1
13718: from pa_bc_packets pbc1
13719: where pbc1.packet_id = p_pa_packet_id
13890: Begin
13891:
13892: select null -- null is ok ..
13893: into x_result_code
13894: from dual
13895: where exists
13896: (Select 1
13897: from pa_bc_packets
13898: where packet_id = l_pa_packet_id
13963: Begin
13964:
13965: select null -- null is ok ..
13966: into x_result_code
13967: from dual
13968: where exists
13969: (Select 1
13970: from pa_bc_packets
13971: where packet_id = l_pa_packet_id
14041: Begin
14042:
14043: select null -- null is ok ..
14044: into x_result_code
14045: from dual
14046: where exists
14047: (Select 1
14048: from pa_bc_packets
14049: where packet_id = l_pa_packet_id
14145: -- Check if its a "projects transaction" related FC
14146:
14147: Select 'TXN_FC'
14148: into p_return_code
14149: from dual
14150: where exists
14151: (select 1 from pa_bc_packets
14152: where packet_id = p_packet_id);
14153:
14406: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_packets');
14407: End If;
14408:
14409: Begin
14410: Select 'Y' into p_txn_exists_in_bc_pkt from dual where exists
14411: (select 1 from pa_bc_packets where project_id = p_project_id and status_code in ('A','P','I'));
14412: Exception
14413: When no_data_found then
14414: p_txn_exists_in_bc_pkt := 'N';
14418: log_message(p_msg_token1=>'Any_txns_against_project:Baseline/CF Mode-Check if txns. exists in pa_bc_commitments');
14419: End If;
14420:
14421: Begin
14422: Select 'Y' into p_txn_exists_in_bc_cmt from dual where exists
14423: (select 1 from pa_bc_commitments where project_id = p_project_id);
14424: Exception
14425: When no_data_found then
14426: p_txn_exists_in_bc_cmt := 'N';
14629: l_dummy_value := 0;
14630:
14631: Begin
14632:
14633: Select 1 into l_dummy_value from dual
14634: where exists (Select 1
14635: from gl_bc_packets glbc,
14636: pa_budget_lines pbl
14637: where glbc.packet_id = p_packet_id
14907: End If;
14908:
14909: Begin
14910:
14911: Select 'Y' into l_gl_failure_flag from dual where exists
14912: (select 1 from gl_bc_packets
14913: where packet_id = p_packet_id
14914: and substr(nvl(result_code,'P'),1,1) = 'F');
14915: Exception
16455:
16456: Begin
16457: select 'Y'
16458: into l_baseline_failed
16459: from dual
16460: where exists
16461: (select packet_id
16462: from gl_bc_packets glbc
16463: where glbc.event_id in