APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on GL_PERIODS

Line 291: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,

287: P_ERRBUF IN OUT NOCOPY VARCHAR2,
288: P_RETCODE IN OUT NOCOPY VARCHAR2);
289:
290: PROCEDURE get_period_date_range (
291: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
292: p_period IN GL_PERIODS.period_name%TYPE,
293: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
294: x_return_status OUT NOCOPY VARCHAR2);
295:

Line 292: p_period IN GL_PERIODS.period_name%TYPE,

288: P_RETCODE IN OUT NOCOPY VARCHAR2);
289:
290: PROCEDURE get_period_date_range (
291: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
292: p_period IN GL_PERIODS.period_name%TYPE,
293: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
294: x_return_status OUT NOCOPY VARCHAR2);
295:
296: PROCEDURE get_VAT_reporting_details (

Line 329: p_end_date IN GL_PERIODS.END_DATE%TYPE,

325:
326: PROCEDURE tax_date_maintenance_program (
327: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
328: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
329: p_end_date IN GL_PERIODS.END_DATE%TYPE,
330: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
331: p_debug_flag IN VARCHAR2,
332: x_return_status OUT NOCOPY VARCHAR2,
333: x_errbuf OUT NOCOPY VARCHAR2 );

Line 442: ,gl_periods glp

438: cursor last_reported_date_from_11i (pn_vat_rep_entity_id number) IS
439: select glp.start_date,glp.end_date,acct.last_reported_period
440: from jg_zz_vat_rep_entities legal
441: ,jg_zz_vat_rep_entities acct
442: ,gl_periods glp
443: where acct.entity_type_code = 'ACCOUNTING'
444: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
445: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id
446: and glp.period_set_name = legal.tax_calendar_name

Line 1107: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,

1103: | |
1104: +===========================================================================*/
1105:
1106: PROCEDURE get_period_date_range (
1107: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
1108: p_period IN GL_PERIODS.period_name%TYPE,
1109: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1110: x_return_status OUT NOCOPY VARCHAR2
1111: ) IS

Line 1108: p_period IN GL_PERIODS.period_name%TYPE,

1104: +===========================================================================*/
1105:
1106: PROCEDURE get_period_date_range (
1107: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
1108: p_period IN GL_PERIODS.period_name%TYPE,
1109: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1110: x_return_status OUT NOCOPY VARCHAR2
1111: ) IS
1112: l_api_name CONSTANT VARCHAR2(30) := 'GET_PERIOD_DATE_RANGE';

Line 1132: FROM GL_PERIODS

1128: SELECT start_date,
1129: end_date
1130: INTO p_global_variables_rec.tax_invoice_date_low,
1131: p_global_variables_rec.tax_invoice_date_high
1132: FROM GL_PERIODS
1133: WHERE period_set_name = p_calendar_name
1134: AND period_name = p_period;
1135:
1136: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2876: ,gl_periods glp

2872: select glp.start_date
2873: ,glp.end_date
2874: from jg_zz_vat_rep_entities legal
2875: ,jg_zz_vat_rep_entities acct
2876: ,gl_periods glp
2877: where acct.entity_type_code='ACCOUNTING'
2878: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
2879: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id
2880: and glp.period_set_name = legal.tax_calendar_name

Line 3755: p_end_date IN GL_PERIODS.end_date%TYPE,

3751: +===========================================================================*/
3752: PROCEDURE tax_date_maintenance_program
3753: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3754: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3755: p_end_date IN GL_PERIODS.end_date%TYPE,
3756: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3757: p_debug_flag IN VARCHAR2,
3758: x_return_status OUT NOCOPY VARCHAR2,
3759: x_errbuf OUT NOCOPY VARCHAR2