266: i IN BINARY_INTEGER);
267:
268: PROCEDURE populate_tax_reg_num(
269: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
270: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
271: P_TAX_DATE IN zx_lines.tax_date%TYPE,
272: i BINARY_INTEGER);
273:
274:
267:
268: PROCEDURE populate_tax_reg_num(
269: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
270: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
271: P_TAX_DATE IN zx_lines.tax_date%TYPE,
272: i BINARY_INTEGER);
273:
274:
275: PROCEDURE initialize_variables (
3147: END initialize_variables ;
3148:
3149: PROCEDURE populate_tax_reg_num(
3150: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
3151: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3152: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3153: i BINARY_INTEGER) IS
3154:
3155: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3148:
3149: PROCEDURE populate_tax_reg_num(
3150: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
3151: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3152: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3153: i BINARY_INTEGER) IS
3154:
3155: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3156: c_le_id NUMBER,
3151: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
3152: P_TAX_DATE IN zx_lines.tax_date%TYPE,
3153: i BINARY_INTEGER) IS
3154:
3155: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3156: c_le_id NUMBER,
3157: c_tax_date zx_lines.tax_date%TYPE
3158: ) IS
3159: SELECT ptp.rep_registration_number
3153: i BINARY_INTEGER) IS
3154:
3155: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
3156: c_le_id NUMBER,
3157: c_tax_date zx_lines.tax_date%TYPE
3158: ) IS
3159: SELECT ptp.rep_registration_number
3160: FROM xle_tax_associations rel
3161: ,zx_party_tax_profile ptp