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 911: UPDATE GL_JE_BATCHES

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

Line 997: UPDATE GL_JE_BATCHES

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

Line 1137: UPDATE GL_JE_BATCHES

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

Line 1171: UPDATE GL_JE_BATCHES

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

Line 1213: UPDATE GL_JE_BATCHES

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

Line 1758: UPDATE GL_JE_BATCHES

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