DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on ZX_LINES

Line 299: p_org_id IN zx_lines.internal_organization_id%TYPE ,

295: );
296:
297: PROCEDURE populate_tax_reg_num(
298: p_trl_global_variables_rec IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
299: p_org_id IN zx_lines.internal_organization_id%TYPE ,
300: p_tax_date IN zx_lines.tax_date%TYPE,
301: i IN BINARY_INTEGER);
302:
303:

Line 300: p_tax_date IN zx_lines.tax_date%TYPE,

296:
297: PROCEDURE populate_tax_reg_num(
298: p_trl_global_variables_rec IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
299: p_org_id IN zx_lines.internal_organization_id%TYPE ,
300: p_tax_date IN zx_lines.tax_date%TYPE,
301: i IN BINARY_INTEGER);
302:
303:
304: PROCEDURE initialize_variables (

Line 3641: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,

3637: END initialize_variables ;
3638:
3639: PROCEDURE populate_tax_reg_num(
3640: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
3641: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3642: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3643: i BINARY_INTEGER) IS
3644:
3645: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,

Line 3642: P_TAX_DATE IN zx_lines.tax_date%TYPE,

3638:
3639: PROCEDURE populate_tax_reg_num(
3640: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
3641: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3642: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3643: i BINARY_INTEGER) IS
3644:
3645: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3646: c_le_id NUMBER,

Line 3645: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,

3641: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3642: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3643: i BINARY_INTEGER) IS
3644:
3645: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3646: c_le_id NUMBER,
3647: c_tax_date zx_lines.tax_date%TYPE
3648: ) IS
3649: SELECT ptp.rep_registration_number

Line 3647: c_tax_date zx_lines.tax_date%TYPE

3643: i BINARY_INTEGER) IS
3644:
3645: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3646: c_le_id NUMBER,
3647: c_tax_date zx_lines.tax_date%TYPE
3648: ) IS
3649: SELECT ptp.rep_registration_number
3650: FROM xle_tax_associations rel
3651: ,zx_party_tax_profile ptp