APPS.ZX_AR_POPULATE_PKG dependencies on ZX_LINES

Line 387: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,

383: PROCEDURE get_tax_rate_info_dist_adj(i IN BINARY_INTEGER);
384:
385: PROCEDURE populate_tax_reg_num(
386: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
387: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
388: P_TAX_DATE IN zx_lines.tax_date%TYPE,
389: i BINARY_INTEGER);
390:
391: PROCEDURE UPDATE_REP_DETAIL_T(p_count IN NUMBER);

Line 388: P_TAX_DATE IN zx_lines.tax_date%TYPE,

384:
385: PROCEDURE populate_tax_reg_num(
386: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
387: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
388: P_TAX_DATE IN zx_lines.tax_date%TYPE,
389: i BINARY_INTEGER);
390:
391: PROCEDURE UPDATE_REP_DETAIL_T(p_count IN NUMBER);
392:

Line 1060: FROM zx_lines zl,

1056:
1057: IF l_mau is NOT NULL THEN
1058: UPDATE zx_rep_trx_detail_t DET
1059: SET taxable_amt_funcl_curr = ROUND(((SELECT (zl.line_amt * DIST.PERCENT)/100
1060: FROM zx_lines zl,
1061: RA_CUST_TRX_LINE_GL_DIST_ALL DIST
1062: WHERE ZL.TAX_LINE_ID = DET.TAX_LINE_ID
1063: AND DIST.CUST_TRX_LINE_GL_DIST_ID = DET.ACTG_SOURCE_ID
1064: AND DIST.CUSTOMER_TRX_ID = ZL.TRX_ID) * currency_conversion_rate) / l_mau) * l_mau

Line 1070: AND exists (SELECT 1 FROM zx_lines lines

1066: AND extract_source_ledger = 'AR'
1067: AND ledger_id = p_trl_global_variables_rec.ledger_id
1068: AND NVL(functional_currency_code,'X') <> NVL(trx_currency_code,'X')
1069: AND currency_conversion_rate <> 1
1070: AND exists (SELECT 1 FROM zx_lines lines
1071: WHERE lines.tax_line_id = DET.tax_line_id
1072: AND lines.manually_entered_flag = 'Y'
1073: AND lines.tax_amt_included_flag = 'N');
1074: END IF;

Line 3820: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;

3816: --Bug 5622686
3817: p_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3818: p_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3819: p_account_Type_Code zx_registrations.account_type_code%TYPE;
3820: p_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
3821: p_tax ZX_TAXES_B.TAX%TYPE;
3822: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3823: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3824: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;

Line 4574: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,

4570: END EXTRACT_PARTY_INFO;
4571:
4572: PROCEDURE populate_tax_reg_num(
4573: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
4574: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
4575: P_TAX_DATE IN zx_lines.tax_date%TYPE,
4576: i BINARY_INTEGER) IS
4577:
4578: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,

Line 4575: P_TAX_DATE IN zx_lines.tax_date%TYPE,

4571:
4572: PROCEDURE populate_tax_reg_num(
4573: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
4574: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
4575: P_TAX_DATE IN zx_lines.tax_date%TYPE,
4576: i BINARY_INTEGER) IS
4577:
4578: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
4579: c_le_id NUMBER,

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

4574: P_ORG_ID IN zx_lines.internal_organization_id%TYPE ,
4575: P_TAX_DATE IN zx_lines.tax_date%TYPE,
4576: i BINARY_INTEGER) IS
4577:
4578: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
4579: c_le_id NUMBER,
4580: c_tax_date zx_lines.tax_date%TYPE
4581: ) IS
4582: SELECT ptp.rep_registration_number

Line 4580: c_tax_date zx_lines.tax_date%TYPE

4576: i BINARY_INTEGER) IS
4577:
4578: CURSOR trn_ptp_id_cur (c_org_id zx_lines.internal_organization_id%TYPE,
4579: c_le_id NUMBER,
4580: c_tax_date zx_lines.tax_date%TYPE
4581: ) IS
4582: SELECT ptp.rep_registration_number
4583: FROM xle_tax_associations rel
4584: ,zx_party_tax_profile ptp