APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TPM_WORKING_HDRS_T

Line 2426: FROM XLA_TPM_WORKING_HDRS_T xtw

2422: ,p_array_merge_option IN t_varchar30_array
2423: ) is
2424: CURSOR c_lastRunningReq is
2425: SELECT xtw.request_id
2426: FROM XLA_TPM_WORKING_HDRS_T xtw
2427: , fnd_concurrent_requests fcr
2428: WHERE xtw.merge_event_id = p_event_id
2429: AND xtw.process_type_flag in ('B', 'R')
2430: AND xtw.request_id = fcr.request_id

Line 2464: DELETE from XLA_TPM_WORKING_HDRS_T

2460: END IF;
2461: -- check if the request is still running, report error if it is
2462: raise LastRequestRunning;
2463: ELSE
2464: DELETE from XLA_TPM_WORKING_HDRS_T
2465: WHERE merge_event_id = p_event_id;
2466: COMMIT;
2467: END IF;
2468:

Line 2471: INSERT INTO XLA_TPM_WORKING_HDRS_T

2467: END IF;
2468:
2469: IF(p_merge_type = 'PARTIAL_MERGE') THEN
2470: FORALL i in 1..p_array_ledger_id.count
2471: INSERT INTO XLA_TPM_WORKING_HDRS_T
2472: ( request_id
2473: ,ae_header_id
2474: ,merge_event_id
2475: ,process_type_flag)

Line 2513: INSERT INTO XLA_TPM_WORKING_HDRS_T

2509:
2510: commit;
2511:
2512: FORALL i in 1..p_array_ledger_id.count
2513: INSERT INTO XLA_TPM_WORKING_HDRS_T
2514: ( request_id
2515: ,ae_header_id
2516: ,merge_event_id
2517: ,process_type_flag)

Line 2554: INSERT INTO XLA_TPM_WORKING_HDRS_T

2550: END IF;
2551: commit;
2552: ELSE
2553: FORALL i in 1..p_array_ledger_id.count
2554: INSERT INTO XLA_TPM_WORKING_HDRS_T
2555: ( request_id
2556: ,ae_header_id
2557: ,merge_event_id
2558: ,process_type_flag)

Line 2592: INSERT INTO XLA_TPM_WORKING_HDRS_T

2588: END IF;
2589: commit;
2590:
2591: FORALL i in 1..p_array_ledger_id.count
2592: INSERT INTO XLA_TPM_WORKING_HDRS_T
2593: ( request_id
2594: ,ae_header_id
2595: ,merge_event_id
2596: ,process_type_flag)

Line 2816: FROM XLA_TPM_WORKING_HDRS_T xtwh

2812: AND aeh.ACCOUNTING_DATE <= p_merge_date
2813: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE = 'F'
2814: AND aeh.ae_header_id in (
2815: SELECT ae_header_id
2816: FROM XLA_TPM_WORKING_HDRS_T xtwh
2817: WHERE xtwh.merge_event_id = p_event_id
2818: AND xtwh.process_type_flag= 'B'
2819: AND rownum <= C_WORK_UNIT)
2820: AND aeh.merge_event_id is null

Line 2982: FROM XLA_TPM_WORKING_HDRS_T xtwh

2978: AND aeh.ACCOUNTING_DATE <= p_merge_date
2979: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE = 'F'
2980: AND aeh.ae_header_id in (
2981: SELECT ae_header_id
2982: FROM XLA_TPM_WORKING_HDRS_T xtwh
2983: WHERE xtwh.merge_event_id = p_event_id
2984: AND xtwh.process_type_flag= 'B'
2985: AND rownum <= C_WORK_UNIT)
2986: AND aeh.merge_event_id is null

Line 3310: FROM XLA_TPM_WORKING_HDRS_T xtwh

3306: AND aeh.ACCOUNTING_DATE > p_merge_date
3307: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE = 'F'
3308: AND aeh.ae_header_id in (
3309: SELECT ae_header_id
3310: FROM XLA_TPM_WORKING_HDRS_T xtwh
3311: WHERE xtwh.merge_event_id = p_event_id
3312: AND xtwh.process_type_flag= 'R'
3313: AND rownum <= C_WORK_UNIT)
3314: AND aeh.merge_event_id is null

Line 3496: FROM XLA_TPM_WORKING_HDRS_T xtwh

3492: AND aeh.ACCOUNTING_DATE > p_merge_date
3493: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE = 'F'
3494: AND aeh.ae_header_id in (
3495: SELECT ae_header_id
3496: FROM XLA_TPM_WORKING_HDRS_T xtwh
3497: WHERE xtwh.merge_event_id = p_event_id
3498: AND xtwh.process_type_flag= 'R'
3499: AND rownum <= C_WORK_UNIT)
3500: AND aeh.merge_event_id is null

Line 3748: DELETE XLA_TPM_WORKING_HDRS_T xtwh

3744: END IF;
3745:
3746: v_row_count1 := 0 ;
3747: IF(v_status = 'B') THEN
3748: DELETE XLA_TPM_WORKING_HDRS_T xtwh
3749: WHERE xtwh.merge_event_id = p_event_id
3750: AND xtwh.process_type_flag= 'B'
3751: AND rownum <= C_WORK_UNIT;
3752: v_row_count1 :=SQL%ROWCOUNT;

Line 3754: DELETE XLA_TPM_WORKING_HDRS_T xtwh

3750: AND xtwh.process_type_flag= 'B'
3751: AND rownum <= C_WORK_UNIT;
3752: v_row_count1 :=SQL%ROWCOUNT;
3753: ELSE
3754: DELETE XLA_TPM_WORKING_HDRS_T xtwh
3755: WHERE xtwh.merge_event_id = p_event_id
3756: AND xtwh.process_type_flag= 'R'
3757: AND rownum <= C_WORK_UNIT;
3758: v_row_count1 :=SQL%ROWCOUNT;