DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on ZX_LINES

Line 270: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,

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:

Line 271: P_TAX_DATE IN zx_lines.tax_date%TYPE,

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 (

Line 3151: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,

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,

Line 3152: P_TAX_DATE IN zx_lines.tax_date%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,

Line 3155: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%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,
3157: c_tax_date zx_lines.tax_date%TYPE
3158: ) IS
3159: SELECT ptp.rep_registration_number

Line 3157: c_tax_date 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
3160: FROM xle_tax_associations rel
3161: ,zx_party_tax_profile ptp