APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_JE_BATCHES

Line 803: --+need to set the status to 'S' in gl_je_batches, means selected to be posted

799: END Get_Postable_Rows;
800:
801: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
802: --+Do Journal Post
803: --+need to set the status to 'S' in gl_je_batches, means selected to be posted
804: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
805: PROCEDURE Run_Journal_Post(
806: user_id IN number,
807: resp_id IN number,

Line 842: v_Batches gl_je_batches%ROWTYPE;

838: l_batch_name varchar2(100);
839: v_ReturnCursor t_RefCur;
840: v_Ledger_Cursor t_RefCur;
841: v_ALC_Cursor t_RefCur;
842: v_Batches gl_je_batches%ROWTYPE;
843:
844: l_status varchar2(1);
845: l_request_id number(15);
846: dummy NUMBER(1);

Line 854: l_batch_status GL_JE_BATCHES.STATUS%TYPE;

850: rstatus VARCHAR2(80);
851: dphase VARCHAR2(30);
852: dstatus VARCHAR2(30);
853: message VARCHAR2(240);
854: l_batch_status GL_JE_BATCHES.STATUS%TYPE;
855: l_budgetary_status GL_JE_BATCHES.BUDGETARY_CONTROL_STATUS%TYPE;
856:
857: BEGIN
858: l_count := 1;

Line 855: l_budgetary_status GL_JE_BATCHES.BUDGETARY_CONTROL_STATUS%TYPE;

851: dphase VARCHAR2(30);
852: dstatus VARCHAR2(30);
853: message VARCHAR2(240);
854: l_batch_status GL_JE_BATCHES.STATUS%TYPE;
855: l_budgetary_status GL_JE_BATCHES.BUDGETARY_CONTROL_STATUS%TYPE;
856:
857: BEGIN
858: l_count := 1;
859: l_ok_to_post := TRUE;

Line 874: 'from gl_je_batches ' ||

870: --+or it is 'I' = UNDERWAY and concurrent request is RUNNING then don't post
871: --+if the status is 'P', don't post again, just exit
872: --+ lock this row too!
873: v_SelectSQL := 'select status, request_id, budgetary_control_status ' ||
874: 'from gl_je_batches ' ||
875: 'WHERE je_batch_id = :b_id ' ||
876: 'and default_period_name = :pd ' ||
877: -- 'and ledger_id = :ledger ' ||
878: 'and actual_flag = :flag ' ||

Line 926: v_UpdateSQL := 'UPDATE gl_je_batches ' ||

922: l_batch_status := 'S';
923: open get_new_id;
924: fetch get_new_id into post_run_id;
925: close get_new_id;
926: v_UpdateSQL := 'UPDATE gl_je_batches ' ||
927: 'SET posting_run_id = :post_run_id, ' ||
928: 'status = :bs ' ||
929: 'WHERE je_batch_id = :b_id ' ||
930: 'and default_period_name = :pd ' ||

Line 935: v_SelectSQL := 'select name from gl_je_batches ' ||

931: -- 'and ledger_id = :ledger ' ||
932: 'and actual_flag = :flag';
933: EXECUTE IMMEDIATE v_UpdateSQL USING post_run_id,l_batch_status,
934: batch_id, pd_name, actual_flag;
935: v_SelectSQL := 'select name from gl_je_batches ' ||
936: 'WHERE je_batch_id = :b_id';
937: EXECUTE IMMEDIATE v_SelectSQL INTO l_batch_name USING batch_id;
938: --+dbms_output.put_line('get batch name');
939:

Line 1036: v_UpdateSQL := 'UPDATE gl_je_batches ' ||

1032: END IF;
1033: --+dbms_output.put_line('after post submitted' || reqid);
1034:
1035: IF (reqid <> 0) THEN
1036: v_UpdateSQL := 'UPDATE gl_je_batches ' ||
1037: 'SET request_id = :request_id ' ||
1038: 'WHERE je_batch_id = :b_id ' ||
1039: 'and default_period_name = :pd ' ||
1040: -- 'and ledger_id = :ledger ' ||