APPS.ZX_EXTRACT_PKG dependencies on ZX_REP_CONTEXT_T

Line 1433: FROM zx_rep_context_t

1429: BEGIN
1430: -- Validation of Parameters:
1431:
1432: SELECT count(*) INTO l_count
1433: FROM zx_rep_context_t
1434: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1435:
1436: IF l_count > 0 THEN
1437: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1749: | zx_rep_context_t |

1745: | extract_additional_info |
1746: | |
1747: | DESCRIPTION |
1748: | This procedure populates Additional information in |
1749: | zx_rep_context_t |
1750: | |
1751: | Called from ZX_EXTRACT_PKG.POPULATE |
1752: | |
1753: | MODIFICATION HISTORY |

Line 1769: FROM zx_rep_context_t rep_context,

1765: c_set_of_books_id IN NUMBER)
1766: IS
1767: SELECT rep_context.rep_context_id , rep_context.rep_entity_id ,
1768: mo.operating_unit_id
1769: FROM zx_rep_context_t rep_context,
1770: fnd_mo_reporting_entities_v mo
1771: WHERE rep_context.rep_entity_id = mo.operating_unit_id
1772: AND mo.ledger_id = c_set_of_books_id
1773: AND rep_context.request_id = c_request_id

Line 1783: FROM zx_rep_context_t rep_context

1779: c_request_id IN NUMBER) IS
1780: SELECT rep_context.rep_context_id,
1781: rep_context.rep_entity_id ,
1782: rep_context.rep_entity_id
1783: FROM zx_rep_context_t rep_context
1784: WHERE rep_context.request_id = c_request_id;
1785:
1786:
1787: l_rep_context_id_rec zx_extract_pkg.rep_context_id_rectype;

Line 2176: | zx_rep_context_t |

2172: | insert_rep_context_itf |
2173: | |
2174: | DESCRIPTION |
2175: | This PROCEDURE inserts Reporting Context information INTO |
2176: | zx_rep_context_t |
2177: | |
2178: | SCOPE - Private |
2179: | |
2180: | NOTES |

Line 2558: SELECT zx_rep_context_t_s.nextval

2554: END;
2555:
2556:
2557: BEGIN
2558: SELECT zx_rep_context_t_s.nextval
2559: INTO l_rep_context_id FROM dual;
2560:
2561: IF (g_level_procedure >= g_current_runtime_level ) THEN
2562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',

Line 2577: INSERT INTO zx_rep_context_t(

2573: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
2574: END IF;
2575:
2576: Begin
2577: INSERT INTO zx_rep_context_t(
2578: rep_context_id,
2579: request_id,
2580: rep_entity_id,
2581: rep_context_entity_location_id,

Line 3033: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;

3029: IF PG_DEBUG = 'N' THEN
3030: delete from ZX_REP_ACTG_EXT_T where request_id = p_request_id;
3031: delete from ZX_REP_TRX_JX_EXT_T where request_id = p_request_id;
3032: delete from ZX_REP_TRX_DETAIL_T where request_id = p_request_id;
3033: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;
3034: END IF;
3035:
3036: /*
3037: delete from ar_tax_extr_sub_com_ext com_ext where com_ext.extract_line_id

Line 3194: FROM zx_rep_context_t rep_context

3190: CURSOR legal_rep_context_cur (
3191: c_request_id IN NUMBER)
3192: IS
3193: SELECT rep_context.rep_context_id
3194: FROM zx_rep_context_t rep_context
3195: WHERE request_id = c_request_id;
3196: --AND rep_context.rep_entity_id = c_legal_entity_id;
3197:
3198: BEGIN