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.ZX_EXTRACT_PKG dependencies on ZX_REP_CONTEXT_T

Line 692: FROM zx_rep_context_t;

688: ,buff => 'zx_rep_trx_jx_ext_t : '||l_count);
689:
690: SELECT COUNT(rep_context_id)
691: INTO l_count
692: FROM zx_rep_context_t;
693:
694: FND_FILE.put_line(which => FND_FILE.LOG
695: ,buff => 'zx_rep_context_t : '||l_count);
696:

Line 695: ,buff => 'zx_rep_context_t : '||l_count);

691: INTO l_count
692: FROM zx_rep_context_t;
693:
694: FND_FILE.put_line(which => FND_FILE.LOG
695: ,buff => 'zx_rep_context_t : '||l_count);
696:
697: l_start_time := SYSDATE;
698: END IF;
699:

Line 1901: FROM zx_rep_context_t

1897: BEGIN
1898: -- Validation of Parameters:
1899:
1900: SELECT count(*) INTO l_count
1901: FROM zx_rep_context_t
1902: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1903:
1904: IF l_count > 0 THEN
1905: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2216: | zx_rep_context_t |

2212: | extract_additional_info |
2213: | |
2214: | DESCRIPTION |
2215: | This procedure populates Additional information in |
2216: | zx_rep_context_t |
2217: | |
2218: | Called from ZX_EXTRACT_PKG.POPULATE |
2219: | |
2220: | MODIFICATION HISTORY |

Line 2236: FROM zx_rep_context_t rep_context,

2232: c_set_of_books_id IN NUMBER)
2233: IS
2234: SELECT rep_context.rep_context_id , rep_context.rep_entity_id ,
2235: mo.operating_unit_id
2236: FROM zx_rep_context_t rep_context,
2237: fnd_mo_reporting_entities_v mo
2238: WHERE rep_context.rep_entity_id = mo.operating_unit_id
2239: AND mo.ledger_id = c_set_of_books_id
2240: AND rep_context.request_id = c_request_id

Line 2250: FROM zx_rep_context_t rep_context

2246: c_request_id IN NUMBER) IS
2247: SELECT rep_context.rep_context_id,
2248: rep_context.rep_entity_id ,
2249: rep_context.rep_entity_id
2250: FROM zx_rep_context_t rep_context
2251: WHERE rep_context.request_id = c_request_id;
2252:
2253: l_rep_context_id_rec zx_extract_pkg.rep_context_id_rectype;
2254: i BINARY_INTEGER;

Line 2637: | zx_rep_context_t |

2633: | insert_rep_context_itf |
2634: | |
2635: | DESCRIPTION |
2636: | This PROCEDURE inserts Reporting Context information INTO |
2637: | zx_rep_context_t |
2638: | |
2639: | SCOPE - Private |
2640: | |
2641: | NOTES |

Line 3017: SELECT zx_rep_context_t_s.nextval

3013: END;
3014:
3015:
3016: BEGIN
3017: SELECT zx_rep_context_t_s.nextval
3018: INTO l_rep_context_id FROM dual;
3019:
3020: IF (g_level_procedure >= g_current_runtime_level ) THEN
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',

Line 3036: INSERT INTO zx_rep_context_t(

3032: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
3033: END IF;
3034:
3035: Begin
3036: INSERT INTO zx_rep_context_t(
3037: rep_context_id,
3038: request_id,
3039: rep_entity_id,
3040: rep_context_entity_location_id,

Line 3510: from ZX_REP_CONTEXT_T

3506: where request_id = p_request_id;
3507: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3508: 'Num of Rows in ZX_REP_TRX_JX_EXT_T :'||num_rows_deleted);
3509: select count(*) into num_rows_deleted
3510: from ZX_REP_CONTEXT_T
3511: where request_id = p_request_id;
3512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3513: 'Num of Rows in ZX_REP_CONTEXT_T :'||num_rows_deleted);
3514: END IF;

Line 3513: 'Num of Rows in ZX_REP_CONTEXT_T :'||num_rows_deleted);

3509: select count(*) into num_rows_deleted
3510: from ZX_REP_CONTEXT_T
3511: where request_id = p_request_id;
3512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3513: 'Num of Rows in ZX_REP_CONTEXT_T :'||num_rows_deleted);
3514: END IF;
3515:
3516: IF PG_DEBUG = 'N' THEN
3517: delete from ZX_REP_ACTG_EXT_T where request_id = p_request_id;

Line 3520: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;

3516: IF PG_DEBUG = 'N' THEN
3517: delete from ZX_REP_ACTG_EXT_T where request_id = p_request_id;
3518: delete from ZX_REP_TRX_JX_EXT_T where request_id = p_request_id;
3519: delete from ZX_REP_TRX_DETAIL_T where request_id = p_request_id;
3520: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;
3521: IF (g_level_procedure >= g_current_runtime_level ) THEN
3522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',
3523: 'In Delete when PG_DEBUG = N ');
3524: END IF;

Line 3690: FROM zx_rep_context_t rep_context

3686: CURSOR legal_rep_context_cur (
3687: c_request_id IN NUMBER)
3688: IS
3689: SELECT rep_context.rep_context_id
3690: FROM zx_rep_context_t rep_context
3691: WHERE request_id = c_request_id;
3692: --AND rep_context.rep_entity_id = c_legal_entity_id;
3693:
3694: BEGIN