APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on GL_PERIODS

Line 285: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,

281: P_ERRBUF IN OUT NOCOPY VARCHAR2,
282: P_RETCODE IN OUT NOCOPY VARCHAR2);
283:
284: PROCEDURE get_period_date_range (
285: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
286: p_period IN GL_PERIODS.period_name%TYPE,
287: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
288: x_return_status OUT NOCOPY VARCHAR2);
289:

Line 286: p_period IN GL_PERIODS.period_name%TYPE,

282: P_RETCODE IN OUT NOCOPY VARCHAR2);
283:
284: PROCEDURE get_period_date_range (
285: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
286: p_period IN GL_PERIODS.period_name%TYPE,
287: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
288: x_return_status OUT NOCOPY VARCHAR2);
289:
290: PROCEDURE get_VAT_reporting_details (

Line 323: p_end_date IN GL_PERIODS.END_DATE%TYPE,

319:
320: PROCEDURE tax_date_maintenance_program (
321: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
322: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
323: p_end_date IN GL_PERIODS.END_DATE%TYPE,
324: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
325: p_debug_flag IN VARCHAR2,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_errbuf OUT NOCOPY VARCHAR2 );

Line 1052: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,

1048: | |
1049: +===========================================================================*/
1050:
1051: PROCEDURE get_period_date_range (
1052: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
1053: p_period IN GL_PERIODS.period_name%TYPE,
1054: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1055: x_return_status OUT NOCOPY VARCHAR2
1056: ) IS

Line 1053: p_period IN GL_PERIODS.period_name%TYPE,

1049: +===========================================================================*/
1050:
1051: PROCEDURE get_period_date_range (
1052: p_calendar_name IN GL_PERIODS.period_set_name%TYPE,
1053: p_period IN GL_PERIODS.period_name%TYPE,
1054: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1055: x_return_status OUT NOCOPY VARCHAR2
1056: ) IS
1057: l_api_name CONSTANT VARCHAR2(30) := 'GET_PERIOD_DATE_RANGE';

Line 1077: FROM GL_PERIODS

1073: SELECT start_date,
1074: end_date
1075: INTO p_global_variables_rec.tax_invoice_date_low,
1076: p_global_variables_rec.tax_invoice_date_high
1077: FROM GL_PERIODS
1078: WHERE period_set_name = p_calendar_name
1079: AND period_name = p_period;
1080:
1081: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2760: ,gl_periods glp

2756: select glp.start_date
2757: ,glp.end_date
2758: from jg_zz_vat_rep_entities legal
2759: ,jg_zz_vat_rep_entities acct
2760: ,gl_periods glp
2761: where acct.entity_type_code='ACCOUNTING'
2762: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
2763: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id
2764: and glp.period_set_name = legal.tax_calendar_name

Line 3574: p_end_date IN GL_PERIODS.end_date%TYPE,

3570: +===========================================================================*/
3571: PROCEDURE tax_date_maintenance_program
3572: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3573: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3574: p_end_date IN GL_PERIODS.end_date%TYPE,
3575: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3576: p_debug_flag IN VARCHAR2,
3577: x_return_status OUT NOCOPY VARCHAR2,
3578: x_errbuf OUT NOCOPY VARCHAR2