APPS.GL_WF_JE_APPROVAL_PKG dependencies on GL_JE_BATCHES

Line 292: UPDATE gl_je_batches

288: diagn_msg('Executing Start_Approval_Workflow for JE batch '||
289: to_char(p_je_batch_id));
290:
291: -- Update the approval status of the batch to 'I'
292: UPDATE gl_je_batches
293: SET approval_status_code = 'I'
294: WHERE je_batch_id = p_je_batch_id;
295:
296: -- Get Approval run id

Line 666: FROM GL_JE_BATCHES

662: l_control_total,
663: l_running_total_dr,
664: l_running_total_cr,
665: l_budgetary_status
666: FROM GL_JE_BATCHES
667: WHERE je_batch_id = l_je_batch_id;
668:
669: diagn_msg('JEB Attributes retrieved from db');
670:

Line 913: UPDATE GL_JE_BATCHES

909: itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'BATCH_ID');
912:
913: UPDATE GL_JE_BATCHES
914: SET approval_status_code = 'V'
915: WHERE je_batch_id = l_je_batch_id;
916:
917: ELSIF ( funcmode = 'CANCEL' ) THEN

Line 999: UPDATE GL_JE_BATCHES

995: itemtype => itemtype,
996: itemkey => itemkey,
997: aname => 'BATCH_ID');
998:
999: UPDATE GL_JE_BATCHES
1000: SET approval_status_code = 'A'
1001: WHERE je_batch_id = l_je_batch_id;
1002:
1003: ELSIF ( funcmode = 'CANCEL' ) THEN

Line 1139: UPDATE GL_JE_BATCHES

1135: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1136: itemkey => itemkey,
1137: aname => 'APPROVER_ID' );
1138:
1139: UPDATE GL_JE_BATCHES
1140: SET approver_employee_id = l_approver_id
1141: WHERE je_batch_id = l_je_batch_id;
1142:
1143: ELSIF (funcmode = 'CANCEL') THEN

Line 1173: UPDATE GL_JE_BATCHES

1169: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'BATCH_ID' );
1172:
1173: UPDATE GL_JE_BATCHES
1174: SET approval_status_code = 'A'
1175: WHERE je_batch_id = l_je_batch_id;
1176:
1177: -- diagn_msg('JE batch '||to_char(l_je_batch_id)||' is approved');

Line 1215: UPDATE GL_JE_BATCHES

1211: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1212: itemkey => itemkey,
1213: aname => 'BATCH_ID' );
1214:
1215: UPDATE GL_JE_BATCHES
1216: SET approval_status_code = 'J'
1217: WHERE je_batch_id = l_je_batch_id;
1218:
1219: ELSIF ( funcmode = 'CANCEL' ) THEN

Line 1760: UPDATE GL_JE_BATCHES

1756: l_je_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1757: itemkey => itemkey,
1758: aname => 'BATCH_ID');
1759:
1760: UPDATE GL_JE_BATCHES
1761: SET approval_status_code = 'R'
1762: WHERE je_batch_id = l_je_batch_id;
1763:
1764: -- then abort the process