[Home] [Help]
1999: L_PARENT_GEOGRAPHY_TYPE ,
2000: L_PARENT_GEOGRAPHY_ID ,
2001: L_ALLOW_MASS_CREATE_FLAG ,
2002: L_APPLIED_AMT_HANDLING_FLAG ,
2003: ZX_TAXES_B_S.NEXTVAL ,
2004: L_CONTENT_OWNER_ID ,
2005: L_REP_TAX_AUTHORITY_ID ,
2006: L_COLL_TAX_AUTHORITY_ID ,
2007: L_THRSHLD_CHK_TMPLT_CODE ,
2038: LAST_UPDATE_LOGIN
2039: )
2040: VALUES
2041: (
2042: ZX_TAXES_B_S.NEXTVAL ,
2043: USERENV('LANG') ,
2044: USERENV('LANG') ,
2045: 'LOCATION' ,
2046: L_CREATED_BY ,
2156: WHERE country_code = asp.default_country
2157: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2158: 'N' L_ALLOW_MASS_CREATE_FLAG,
2159: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2160: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2161: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2162: NULL L_REP_TAX_AUTHORITY_ID,
2163: NULL L_COLL_TAX_AUTHORITY_ID,
2164: NULL L_THRSHLD_CHK_TMPLT_CODE,
2414: L_PARENT_GEOGRAPHY_TYPE ,
2415: L_PARENT_GEOGRAPHY_ID ,
2416: L_ALLOW_MASS_CREATE_FLAG ,
2417: L_APPLIED_AMT_HANDLING_FLAG ,
2418: ZX_TAXES_B_S.NEXTVAL ,
2419: L_CONTENT_OWNER_ID ,
2420: L_REP_TAX_AUTHORITY_ID ,
2421: L_COLL_TAX_AUTHORITY_ID ,
2422: L_THRSHLD_CHK_TMPLT_CODE ,
2453: LAST_UPDATE_LOGIN
2454: )
2455: VALUES
2456: (
2457: ZX_TAXES_B_S.NEXTVAL ,
2458: USERENV('LANG') ,
2459: USERENV('LANG') ,
2460: 'LOCATION' ,
2461: L_CREATED_BY ,
2571: WHERE country_code = asp.default_country
2572: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2573: 'N' L_ALLOW_MASS_CREATE_FLAG,
2574: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2575: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2576: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2577: NULL L_REP_TAX_AUTHORITY_ID,
2578: NULL L_COLL_TAX_AUTHORITY_ID,
2579: NULL L_THRSHLD_CHK_TMPLT_CODE,
6489: NULL , -- PARENT_GEOGRAPHY_TYPE
6490: NULL , -- PARENT_GEOGRAPHY_ID
6491: 'Y' , -- ALLOW_MASS_CREATE_FLAG /*Bug fix 552412*/
6492: 'P' , -- APPLIED_AMT_HANDLING_FLAG
6493: zx_taxes_b_s.nextval , -- TAX_ID
6494: -99 , -- CONTENT_OWNER_ID
6495: NULL , -- REP_TAX_AUTHORITY_ID
6496: NULL , -- COLL_TAX_AUTHORITY_ID
6497: NULL , -- THRSHLD_CHK_TMPLT_CODE
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6555: )*/
6556: SELECT 1 FROM DUAL;
6557:
6558: EXCEPTION
7630: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7631: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7632: 'N' ,--ALLOW_MASS_CREATE_FLAG
7633: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7634: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7635: L_CONTENT_OWNER_ID ,
7636: NULL ,--REP_TAX_AUTHORITY_ID
7637: NULL ,--COLL_TAX_AUTHORITY_ID
7638: NULL ,--THRSHLD_CHK_TMPLT_CODE
7983: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7984: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7985: 'N' ,--ALLOW_MASS_CREATE_FLAG
7986: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7987: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7988: L_CONTENT_OWNER_ID ,
7989: NULL ,--REP_TAX_AUTHORITY_ID
7990: NULL ,--COLL_TAX_AUTHORITY_ID
7991: NULL ,--THRSHLD_CHK_TMPLT_CODE
9084: FROM
9085: (
9086: SELECT
9087: CASE WHEN LENGTHB(codes.tax_code) > 30
9088: THEN SUBSTRB(codes.tax_code, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
9089: ELSE codes.tax_code
9090: END LOOKUP_CODE,
9091: CASE WHEN LENGTHB(codes.tax_code) > 30
9092: THEN codes.tax_code