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_JE_BATCHES

Line 509: FROM GL_JE_BATCHES jb,

505: l_fail_batches Varchar2(2000);
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;

Line 878: FROM GL_JE_BATCHES jb,

874: l_approval_batch Varchar2(2000);
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;

Line 977: FROM GL_JE_BATCHES jb,

973: l_gl_allow_preparer_approval Varchar2(30);
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;

Line 1090: FROM GL_JE_BATCHES jb,

1086: l_fail_batches Varchar2(2000);
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;

Line 1209: From GL_JE_BATCHES JEB

1205:
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;

Line 1280: diagn_debug_msg('Is_Batch_Generated: ' || 'Batch not Generated or Not found in GL_JE_BATCHES. Sending Notification');

1276: END IF;
1277: l_generated_flag := 'Y';
1278: Else
1279: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
1280: diagn_debug_msg('Is_Batch_Generated: ' || 'Batch not Generated or Not found in GL_JE_BATCHES. Sending Notification');
1281: END IF;
1282: End IF;
1283: END LOOP;
1284: CLOSE get_gen_batch_id_C;

Line 1351: FROM GL_JE_BATCHES jb,

1347: l_batches_not_valid Varchar2(32000) := NULL;
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

Line 1484: From GL_JE_BATCHES jb,

1480: l_fail_batches Varchar2(150);
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;

Line 1600: From GL_JE_BATCHES JEB

1596: ,H.GENERATED_JE_BATCH_ID
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)

Line 1665: DELETE gl_je_batches

1661: DELETE gl_je_headers
1662: WHERE je_batch_id = l_gen_batch_Id;
1663:
1664: -- Delete gl_je_batch
1665: DELETE gl_je_batches
1666: WHERE je_batch_id = l_gen_batch_Id;
1667:
1668: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
1669: diagn_debug_msg('Delete_Batch: ' || 'Rollback:Batch deleted');

Line 1923: From GL_JE_BATCHES JEB

1919:
1920:
1921: Cursor verify_rev_batch_C IS
1922: Select R.REVERSAL_JE_HEADER_ID
1923: From GL_JE_BATCHES JEB
1924: ,GL_AUTO_ALLOC_REV_BATCHES R
1925: Where JEB.JE_BATCH_ID = R.REVERSAL_JE_BATCH_ID
1926: AND JEB.STATUS Not In ('P','I')
1927: AND R.PARENT_REQUEST_ID = to_number(p_item_key);

Line 2086: FROM GL_JE_BATCHES GLB

2082: Cursor get_all_rev_batches_C IS
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

Line 2208: From GL_JE_BATCHES JEB

2204: Cursor check_JE_batch_status_C IS
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

Line 2497: FROM GL_JE_BATCHES jb,

2493: l_post_flag VARCHAR2(1) := 'Y';
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;

Line 2586: l_posting_run_id := gl_je_batches_post_pkg.get_unique_id;

2582: END IF;
2583:
2584: END IF;
2585:
2586: l_posting_run_id := gl_je_batches_post_pkg.get_unique_id;
2587:
2588: Submit_Request( l_parent_req_id
2589: ,l_step_number
2590: ,'GLPPOS'

Line 2609: Update GL_JE_BATCHES

2605: If submit_request_id = 0 Then
2606: p_result := 'COMPLETE:FAIL';
2607: Else
2608: If l_operating_mode = 'R' Then
2609: Update GL_JE_BATCHES
2610: Set Posting_Run_Id = l_posting_run_id
2611: ,Status = 'S'
2612: Where JE_BATCH_ID in ( Select GLAARV.REVERSAL_JE_BATCH_ID
2613: From GL_JE_BATCHES GLB

Line 2613: From GL_JE_BATCHES GLB

2609: Update GL_JE_BATCHES
2610: Set Posting_Run_Id = l_posting_run_id
2611: ,Status = 'S'
2612: Where JE_BATCH_ID in ( Select GLAARV.REVERSAL_JE_BATCH_ID
2613: From GL_JE_BATCHES GLB
2614: ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
2615: Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
2616: AND GLB.STATUS NOT In ('P','I','S')
2617: AND GLAARV.PARENT_REQUEST_ID = to_number(p_item_key) );

Line 2628: Update GL_JE_BATCHES

2624: ,-1
2625: ,'RPP'
2626: );
2627: Else
2628: Update GL_JE_BATCHES
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

Line 2634: GL_JE_BATCHES jb

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
2638: AND jb.status NOT IN ('P','I','S')

Line 2723: From GL_JE_BATCHES

2719: ,ACTUAL_FLAG
2720: ,BUDGETARY_CONTROL_STATUS
2721: ,STATUS
2722: ,APPROVAL_STATUS_CODE
2723: From GL_JE_BATCHES
2724: Where JE_BATCH_ID = l_je_batch_id;
2725:
2726:
2727: CURSOR get_je_header_attributes_C IS

Line 2768: Update GL_JE_BATCHES

2764: itemkey => p_item_key,
2765: aname => 'OPERATING_MODE');
2766: If l_operating_mode = 'R' Then
2767: --during rollback, we don't require approval
2768: Update GL_JE_BATCHES
2769: Set approval_status_code = 'Z'
2770: Where je_batch_id = l_je_batch_id;
2771:
2772: result := 'Y';

Line 3354: From GL_JE_BATCHES JEB

3350: ,H.BATCH_TYPE_CODE
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)

Line 3368: From GL_JE_BATCHES JEB

3364: ,H.Batch_Id
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'