APPS.IGI_ITR dependencies on GL_JE_BATCHES

Line 552: b_budgetary_control_status gl_je_batches.budgetary_control_status%TYPE;

548: * STATUS
549: */
550: procedure STATUS( p_batch_id number) as
551:
552: b_budgetary_control_status gl_je_batches.budgetary_control_status%TYPE;
553: b_status_flag gl_je_batches.status%TYPE;
554: l_status_flag varchar2(1);
555: l_posting_flag varchar2(1);
556: b_actual_flag varchar2(1);

Line 553: b_status_flag gl_je_batches.status%TYPE;

549: */
550: procedure STATUS( p_batch_id number) as
551:
552: b_budgetary_control_status gl_je_batches.budgetary_control_status%TYPE;
553: b_status_flag gl_je_batches.status%TYPE;
554: l_status_flag varchar2(1);
555: l_posting_flag varchar2(1);
556: b_actual_flag varchar2(1);
557: a number;

Line 573: from gl_je_batches

569:
570: begin
571: select budgetary_control_status, status,actual_flag into
572: b_budgetary_control_status, b_status_flag , b_actual_flag
573: from gl_je_batches
574: where je_batch_id = p_batch_id;
575:
576: for current_header in c_header(p_batch_id) loop
577:

Line 618: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

614: FROM gl_je_headers
615: WHERE je_batch_id = p_batch_id
616: );
617: DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
618: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
619:
620:
621: elsif b_budgetary_control_status = 'R'
622: and b_status_flag in ('D','Z')

Line 642: delete gl_je_batches where je_batch_id = p_batch_id;

638: (SELECT je_header_id
639: FROM gl_je_headers
640: WHERE je_batch_id = p_batch_id);
641: delete gl_je_headers where je_batch_id = p_batch_id;
642: delete gl_je_batches where je_batch_id = p_batch_id;
643:
644:
645: elsif b_budgetary_control_status NOT IN ('R')
646: and b_status_flag in ('D','Z')

Line 667: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

663: FROM gl_je_headers
664: WHERE je_batch_id = p_batch_id
665: );
666: DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
667: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
668: */
669: elsif b_budgetary_control_status = 'N'
670: then
671: if l_status_flag IS NULL

Line 689: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

685: FROM gl_je_headers
686: WHERE je_batch_id = p_batch_id
687: );
688: DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
689: DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
690:
691: elsif b_budgetary_control_status = 'P'
692: then
693: if l_status_flag IS NULL