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.JG_ZZ_VAT_PRE_REP_PROC_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 87: p_reporting_level IN jg_zz_vat_rep_entities.entity_level_code%TYPE,

83: +===========================================================================*/
84: PROCEDURE main
85: ( errbuf OUT NOCOPY VARCHAR2,
86: retcode OUT NOCOPY NUMBER,
87: p_reporting_level IN jg_zz_vat_rep_entities.entity_level_code%TYPE,
88: p_vat_reporting_entity_id IN jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
89: p_chart_of_account_id IN NUMBER,
90: p_bsv IN jg_zz_vat_rep_entities.balancing_segment_value%TYPE,
91: p_period IN jg_zz_vat_rep_status.tax_calendar_period%TYPE

Line 88: p_vat_reporting_entity_id IN jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,

84: PROCEDURE main
85: ( errbuf OUT NOCOPY VARCHAR2,
86: retcode OUT NOCOPY NUMBER,
87: p_reporting_level IN jg_zz_vat_rep_entities.entity_level_code%TYPE,
88: p_vat_reporting_entity_id IN jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
89: p_chart_of_account_id IN NUMBER,
90: p_bsv IN jg_zz_vat_rep_entities.balancing_segment_value%TYPE,
91: p_period IN jg_zz_vat_rep_status.tax_calendar_period%TYPE
92: ) IS

Line 90: p_bsv IN jg_zz_vat_rep_entities.balancing_segment_value%TYPE,

86: retcode OUT NOCOPY NUMBER,
87: p_reporting_level IN jg_zz_vat_rep_entities.entity_level_code%TYPE,
88: p_vat_reporting_entity_id IN jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
89: p_chart_of_account_id IN NUMBER,
90: p_bsv IN jg_zz_vat_rep_entities.balancing_segment_value%TYPE,
91: p_period IN jg_zz_vat_rep_status.tax_calendar_period%TYPE
92: ) IS
93:
94: l_return_status VARCHAR2(1);

Line 97: CURSOR c_last_rep_period_csr (p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE)

93:
94: l_return_status VARCHAR2(1);
95: l_return_message VARCHAR2(1000);
96:
97: CURSOR c_last_rep_period_csr (p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE)
98: IS
99: SELECT last_reported_period
100: FROM jg_zz_vat_rep_entities
101: WHERE vat_reporting_entity_id = p_vat_reporting_entity_id;

Line 100: FROM jg_zz_vat_rep_entities

96:
97: CURSOR c_last_rep_period_csr (p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE)
98: IS
99: SELECT last_reported_period
100: FROM jg_zz_vat_rep_entities
101: WHERE vat_reporting_entity_id = p_vat_reporting_entity_id;
102:
103: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number)
104: IS

Line 121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;

117: AND ZX.event_class_code = JGTRD.event_class_code
118: AND rownum=1;
119:
120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;
121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;

Line 122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;

118: AND rownum=1;
119:
120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;
121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;

Line 123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;

119:
120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;
121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

Line 124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;

120: l_country XLE_FIRSTPARTY_INFORMATION_V.country%TYPE;
121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;

Line 125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;

121: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;
129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;

Line 126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;

122: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;
129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
130: l_start_date DATE;

Line 127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

123: l_driving_date_code JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;
129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
130: l_start_date DATE;
131: l_end_date DATE;

Line 128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;

124: l_driving_date_code_es JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE;
125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;
129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
130: l_start_date DATE;
131: l_end_date DATE;
132: l_is_mgr_trx_exist NUMBER(15);

Line 129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;

125: l_mapping_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE;
126: l_tax_calendar_name JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE;
127: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
128: l_bsv_vat_rep_entity_id JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE;
129: l_ledger_id JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
130: l_start_date DATE;
131: l_end_date DATE;
132: l_is_mgr_trx_exist NUMBER(15);
133:

Line 158: FROM JG_ZZ_VAT_REP_ENTITIES LEGAL

154: ,l_mapping_rep_entity_id
155: ,l_tax_calendar_name
156: ,l_ledger_id
157: ,l_legal_entity_id
158: FROM JG_ZZ_VAT_REP_ENTITIES LEGAL
159: ,JG_ZZ_VAT_REP_ENTITIES ACCT
160: WHERE ACCT.VAT_REPORTING_ENTITY_ID = p_vat_reporting_entity_id
161: AND LEGAL.VAT_REPORTING_ENTITY_ID = ACCT.mapping_vat_rep_entity_id;
162:

Line 159: ,JG_ZZ_VAT_REP_ENTITIES ACCT

155: ,l_tax_calendar_name
156: ,l_ledger_id
157: ,l_legal_entity_id
158: FROM JG_ZZ_VAT_REP_ENTITIES LEGAL
159: ,JG_ZZ_VAT_REP_ENTITIES ACCT
160: WHERE ACCT.VAT_REPORTING_ENTITY_ID = p_vat_reporting_entity_id
161: AND LEGAL.VAT_REPORTING_ENTITY_ID = ACCT.mapping_vat_rep_entity_id;
162:
163: -- get country code

Line 457: UPDATE JG_ZZ_VAT_REP_ENTITIES

453:
454:
455: IF p_reporting_level = 'LEDGER' THEN
456:
457: UPDATE JG_ZZ_VAT_REP_ENTITIES
458: SET LAST_REPORTED_PERIOD = p_period
459: WHERE VAT_REPORTING_ENTITY_ID = p_vat_reporting_entity_id;
460:
461: ELSE --p_reporting_level = 'BSV'

Line 462: UPDATE JG_ZZ_VAT_REP_ENTITIES

458: SET LAST_REPORTED_PERIOD = p_period
459: WHERE VAT_REPORTING_ENTITY_ID = p_vat_reporting_entity_id;
460:
461: ELSE --p_reporting_level = 'BSV'
462: UPDATE JG_ZZ_VAT_REP_ENTITIES
463: SET LAST_REPORTED_PERIOD = p_period
464: WHERE VAT_REPORTING_ENTITY_ID = l_bsv_vat_rep_entity_id;
465: END IF;
466: