eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_AUTO_ALLOC_BATCH_HISTORY

Line 492: From GL_AUTO_ALLOC_BATCH_HISTORY

488: , BATCH_ID
489: , BATCH_TYPE_CODE
490: , ALLOCATION_METHOD_CODE
491: , OWNER
492: From GL_AUTO_ALLOC_BATCH_HISTORY
493: Where REQUEST_ID = to_number(p_item_key)
494: AND Step_number > l_step_number
495: Order by Step_number ASC;
496:

Line 510: GL_AUTO_ALLOC_BATCH_HISTORY bh

506:
507: Cursor get_je_batch_status_C IS
508: Select jb.status, jb.je_batch_id
509: FROM GL_JE_BATCHES jb,
510: GL_AUTO_ALLOC_BATCH_HISTORY bh
511: WHERE bh.request_id = to_number(p_item_key)
512: AND bh.step_number = l_step
513: AND jb.je_batch_id = bh.generated_je_batch_id;
514:

Line 583: Update GL_AUTO_ALLOC_BATCH_HISTORY

579: IF l_fail_flag = 'N' THEN
580: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
581: diagn_debug_msg('Next_Step_Type: ' || 'Batch is posted. Mark step as complete');
582: END IF;
583: Update GL_AUTO_ALLOC_BATCH_HISTORY
584: Set COMPLETE_FLAG = 'Y'
585: Where REQUEST_ID = to_number(p_item_key)
586: And STEP_NUMBER = l_step;
587: --And BATCH_ID = l_batch_id

Line 879: GL_AUTO_ALLOC_BATCH_HISTORY bh

875:
876: Cursor jrnl_approval_required_C IS
877: Select JB.APPROVAL_STATUS_CODE,JB.JE_BATCH_ID
878: FROM GL_JE_BATCHES jb,
879: GL_AUTO_ALLOC_BATCH_HISTORY bh
880: WHERE bh.request_id = to_number(p_item_key)
881: AND bh.step_number = l_step_number
882: AND jb.je_batch_id = bh.generated_je_batch_id;
883:

Line 978: GL_AUTO_ALLOC_BATCH_HISTORY bh

974:
975: Cursor jrnl_approval_status_C IS
976: Select JB.APPROVAL_STATUS_CODE,JB.NAME,JB.JE_BATCH_ID
977: FROM GL_JE_BATCHES jb,
978: GL_AUTO_ALLOC_BATCH_HISTORY bh
979: WHERE bh.request_id = to_number(p_item_key)
980: AND bh.step_number = l_step_number
981: AND jb.je_batch_id = bh.generated_je_batch_id;
982:

Line 1091: GL_AUTO_ALLOC_BATCH_HISTORY bh

1087:
1088: Cursor jrnl_approval_status_C IS
1089: Select JB.APPROVAL_STATUS_CODE,JB.JE_BATCH_ID
1090: FROM GL_JE_BATCHES jb,
1091: GL_AUTO_ALLOC_BATCH_HISTORY bh
1092: WHERE bh.request_id = to_number(p_item_key)
1093: AND bh.step_number = l_step_number
1094: AND jb.je_batch_id = bh.generated_je_batch_id;
1095:

Line 1210: ,GL_AUTO_ALLOC_BATCH_HISTORY A

1206: Cursor get_gen_batch_id_C Is
1207: Select A.GENERATED_JE_BATCH_ID,
1208: JEB.Name
1209: From GL_JE_BATCHES JEB
1210: ,GL_AUTO_ALLOC_BATCH_HISTORY A
1211: Where JEB.JE_BATCH_ID = A.GENERATED_JE_BATCH_ID
1212: AND A.REQUEST_ID = to_number(p_item_key)
1213: AND A.STEP_NUMBER = l_step_number;
1214:

Line 1352: GL_AUTO_ALLOC_BATCH_HISTORY bh

1348:
1349: CURSOR get_all_batches_C IS
1350: SELECT jb.je_batch_id
1351: FROM GL_JE_BATCHES jb,
1352: GL_AUTO_ALLOC_BATCH_HISTORY bh
1353: WHERE bh.request_id = to_number(p_item_key)
1354: AND bh.step_number = l_step_number
1355: AND jb.je_batch_id = bh.generated_je_batch_id
1356: AND jb.status NOT IN ('P','I','S');

Line 1485: GL_AUTO_ALLOC_BATCH_HISTORY bh

1481:
1482: Cursor check_JE_batch_status_C IS
1483: Select jb.je_batch_id, jb.status
1484: From GL_JE_BATCHES jb,
1485: GL_AUTO_ALLOC_BATCH_HISTORY bh
1486: Where bh.request_id = to_number(p_item_key)
1487: And bh.step_number = l_step_number
1488: And jb.je_batch_id = bh.generated_je_batch_id;
1489:

Line 1601: ,GL_AUTO_ALLOC_BATCH_HISTORY H

1597: ,H.COMPLETE_FLAG
1598: ,JEB.Name
1599: ,JEB.Status
1600: From GL_JE_BATCHES JEB
1601: ,GL_AUTO_ALLOC_BATCH_HISTORY H
1602: Where
1603: JEB.JE_BATCH_ID = H.GENERATED_JE_BATCH_ID
1604: AND H.REQUEST_ID = to_number(p_item_key)
1605: AND H.GENERATED_JE_BATCH_ID IS Not Null

Line 1611: From GL_AUTO_ALLOC_BATCH_HISTORY

1607: Order By H.STEP_NUMBER Desc;
1608:
1609: Cursor Set_Status_C IS
1610: Select step_number
1611: From GL_AUTO_ALLOC_BATCH_HISTORY
1612: Where
1613: REQUEST_ID= to_number(p_item_key)
1614: AND GENERATED_JE_BATCH_ID IS NULL
1615: AND STATUS_CODE <> 'NS';

Line 1719: From GL_AUTO_ALLOC_BATCH_HISTORY

1715: Cursor Get_Batches_C IS
1716: Select
1717: Step_Number
1718: ,GENERATED_JE_BATCH_ID
1719: From GL_AUTO_ALLOC_BATCH_HISTORY
1720: WHERE REQUEST_ID = to_number(p_item_key)
1721: And COMPLETE_FLAG = 'Y'
1722: And Nvl(ALL_HEADERS_REVERSED,'N') <> 'Y'
1723: And STEP_NUMBER <= l_step_number

Line 1781: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY

1777: diagn_debug_msg('Are_More_JE_Reverse: ' || '*********************************************************');
1778: diagn_debug_msg('Are_More_JE_Reverse: ' || 'ROLLBACK: All HEADERS ARE REVERSED FOR STEP '||to_char(l_step_number)|| ' GEN BATCH '||to_char(l_gen_batch_id));
1779: diagn_debug_msg('Are_More_JE_Reverse: ' || '*********************************************************');
1780: END IF;
1781: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
1782: Set ALL_HEADERS_REVERSED = 'Y'
1783: WHERE REQUEST_ID = to_number(p_item_key)
1784: And GENERATED_JE_BATCH_ID = l_gen_batch_id;
1785: diagn_debug_msg('Rows updated = '||to_char(SQL%ROWCOUNT));

Line 1864: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY

1860: diagn_debug_msg('Are_More_JE_Reverse: ' || '*ROLLBACK: All HEADERS ARE REVERSED FOR STEP '||
1861: to_char(l_step_number)|| ' GEN BATCH '||to_char(l_gen_batch_id));
1862: diagn_debug_msg('Are_More_JE_Reverse: ' || '*********************************************************');
1863: END IF;
1864: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
1865: Set ALL_HEADERS_REVERSED = 'Y'
1866: WHERE REQUEST_ID = to_number(p_item_key)
1867: And GENERATED_JE_BATCH_ID = l_gen_batch_id;
1868: diagn_debug_msg('Rollback:Rows updated = '||to_char(SQL%ROWCOUNT));

Line 2087: ,GL_AUTO_ALLOC_BATCH_HISTORY BH

2083: Select
2084: GLAARV.REVERSAL_JE_BATCH_ID
2085: ,BH.step_Number
2086: FROM GL_JE_BATCHES GLB
2087: ,GL_AUTO_ALLOC_BATCH_HISTORY BH
2088: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
2089: Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
2090: AND GLAARV.JE_BATCH_ID = BH.GENERATED_JE_BATCH_ID
2091: AND GLB.STATUS NOT In ('P','I','S')

Line 2209: ,GL_AUTO_ALLOC_BATCH_HISTORY BH

2205: Select JEB.Status
2206: ,JEB.JE_Batch_Id
2207: ,BH.Step_Number
2208: From GL_JE_BATCHES JEB
2209: ,GL_AUTO_ALLOC_BATCH_HISTORY BH
2210: ,GL_AUTO_ALLOC_REV_BATCHES RB
2211: Where JEB.JE_BATCH_ID = RB.REVERSAL_JE_BATCH_ID
2212: And RB.JE_BATCH_ID = BH.GENERATED_JE_BATCH_ID
2213: AND BH.REQUEST_ID = to_number(p_item_key)

Line 2498: GL_AUTO_ALLOC_BATCH_HISTORY bh

2494:
2495: CURSOR get_request_id_c IS
2496: SELECT jb.request_id,bh.generated_je_batch_id
2497: FROM GL_JE_BATCHES jb,
2498: GL_AUTO_ALLOC_BATCH_HISTORY bh
2499: WHERE bh.request_id = to_number(p_item_key)
2500: AND bh.step_number = l_step_number
2501: AND jb.je_batch_id = bh.generated_je_batch_id;
2502:

Line 2633: FROM GL_AUTO_ALLOC_BATCH_HISTORY bh,

2629: Set Posting_Run_Id = l_posting_run_id,
2630: Status = 'S'
2631: Where JE_BATCH_ID IN
2632: ( SELECT bh.generated_je_batch_id
2633: FROM GL_AUTO_ALLOC_BATCH_HISTORY bh,
2634: GL_JE_BATCHES jb
2635: WHERE bh.request_id = to_number(p_item_key)
2636: AND bh.step_number = l_step_number
2637: AND jb.je_batch_id = bh.generated_je_batch_id

Line 3355: ,GL_AUTO_ALLOC_BATCH_HISTORY H

3351: ,H.GENERATED_JE_BATCH_ID
3352: ,H.COMPLETE_FLAG
3353: ,JEB.Status
3354: From GL_JE_BATCHES JEB
3355: ,GL_AUTO_ALLOC_BATCH_HISTORY H
3356: Where
3357: JEB.JE_BATCH_ID = H.GENERATED_JE_BATCH_ID
3358: AND H.REQUEST_ID = to_number(p_item_key)
3359: Order By H.STEP_NUMBER Desc;

Line 3369: ,GL_AUTO_ALLOC_BATCH_HISTORY H

3365: ,H.BATCH_TYPE_CODE
3366: ,H.GENERATED_JE_BATCH_ID
3367: ,JEB.Name
3368: From GL_JE_BATCHES JEB
3369: ,GL_AUTO_ALLOC_BATCH_HISTORY H
3370: Where JEB.JE_BATCH_ID = H.GENERATED_JE_BATCH_ID
3371: AND H.REQUEST_ID = to_number(p_item_key)
3372: AND H.COMPLETE_FLAG = 'Y'
3373: Order By H.STEP_NUMBER Desc;

Line 3417: Update GL_AUTO_ALLOC_BATCH_HISTORY

3413: --shouldn't happen but still not a fatal error
3414: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3415: diagn_debug_msg('VAL_SET_FOR_ROLLBACK: ' || 'Batch is posted.Complete flag=N .Marking step as completed');
3416: END IF;
3417: Update GL_AUTO_ALLOC_BATCH_HISTORY
3418: Set COMPLETE_FLAG = 'Y'
3419: Where REQUEST_ID = to_number(p_item_key)
3420: And STEP_NUMBER = l_step_number;
3421: --And BATCH_ID = l_batch_id

Line 3620: From GL_AUTO_ALLOC_BATCH_HISTORY

3616: f_step_number NUMBER;
3617:
3618: Cursor get_steps_C IS
3619: Select step_number
3620: From GL_AUTO_ALLOC_BATCH_HISTORY
3621: WHERE request_Id = p_PARENT_REQUEST_ID
3622: AND Status_Code Not In ( 'NS','RNR','RC');
3623:
3624: Begin

Line 3728: FROM gl_auto_alloc_batch_history

3724: l_batch_type VARCHAR2(1);
3725: l_Contain_Project BOOLEAN;
3726: CURSOR get_type_h IS
3727: SELECT batch_type_code
3728: FROM gl_auto_alloc_batch_history
3729: WHERE Request_Id = X_Request_Id;
3730: BEGIN
3731: l_Contain_Project := FALSE;
3732:

Line 3761: FROM GL_AUTO_ALLOC_BATCH_HISTORY

3757: Cursor status_code_C IS
3758: Select
3759: STATUS_CODE
3760: ,STEP_NUMBER
3761: FROM GL_AUTO_ALLOC_BATCH_HISTORY
3762: WHERE REQUEST_ID = l_request_id
3763: AND ( STEP_NUMBER = l_step_number OR
3764: -1 = l_step_number) ;
3765:

Line 3780: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY

3776: ,f_step_number;
3777: Exit WHEN status_code_C%NOTFOUND;
3778: If f_status_code <> l_status_code AND
3779: f_status_code not in ('RC','NS','RNR') Then
3780: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
3781: SET STATUS_CODE = l_status_code
3782: WHERE REQUEST_ID = l_request_id
3783: AND STEP_NUMBER = f_step_number;
3784: End If;

Line 3793: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY

3789: f_status_code
3790: ,f_step_number;
3791: If f_status_code <> l_status_code Or
3792: f_status_code IS NULL Then
3793: UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
3794: SET STATUS_CODE = l_status_code
3795: WHERE REQUEST_ID = l_request_id
3796: AND STEP_NUMBER = l_step_number;
3797: End If;