2150: NULL,--l_legal_entity_number,
2151: NULL,--l_establishment_number,
2152: p_event_class_rec.process_for_applicability_flag,
2153: sysdate,
2154: fnd_global.user_id,
2155: sysdate,
2156: fnd_global.user_id,
2157: fnd_global.conc_login_id);
2158: end if;
2152: p_event_class_rec.process_for_applicability_flag,
2153: sysdate,
2154: fnd_global.user_id,
2155: sysdate,
2156: fnd_global.user_id,
2157: fnd_global.conc_login_id);
2158: end if;
2159: FOR i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
2160: LOOP
2153: sysdate,
2154: fnd_global.user_id,
2155: sysdate,
2156: fnd_global.user_id,
2157: fnd_global.conc_login_id);
2158: end if;
2159: FOR i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
2160: LOOP
2161: If l_tax_provider_id = 1 then/*Case for VERTEX*/
2515: 'N',
2516: 'Y',
2517: 'EBTAX_CREATED',
2518: sysdate, --creation_date
2519: fnd_global.user_Id, --created_by
2520: sysdate, --last_update_date
2521: fnd_global.user_id, --last_updated_by
2522: fnd_global.conc_login_id --last_update_login
2523: );
2517: 'EBTAX_CREATED',
2518: sysdate, --creation_date
2519: fnd_global.user_Id, --created_by
2520: sysdate, --last_update_date
2521: fnd_global.user_id, --last_updated_by
2522: fnd_global.conc_login_id --last_update_login
2523: );
2524:
2525:
2518: sysdate, --creation_date
2519: fnd_global.user_Id, --created_by
2520: sysdate, --last_update_date
2521: fnd_global.user_id, --last_updated_by
2522: fnd_global.conc_login_id --last_update_login
2523: );
2524:
2525:
2526: INSERT INTO ZX_API_REGISTRATIONS (
2547: srvctypes.service_type_id,
2548: 'EBTAX_CREATED',
2549: 1,
2550: sysdate, --creation_date
2551: fnd_global.user_Id, --created_by
2552: sysdate, --last_update_date
2553: fnd_global.user_id, --last_updated_by
2554: fnd_global.conc_login_id --last_update_login;
2555: FROM ZX_REGIMES_USAGES ru,
2549: 1,
2550: sysdate, --creation_date
2551: fnd_global.user_Id, --created_by
2552: sysdate, --last_update_date
2553: fnd_global.user_id, --last_updated_by
2554: fnd_global.conc_login_id --last_update_login;
2555: FROM ZX_REGIMES_USAGES ru,
2556: ZX_API_CODE_COMBINATIONS comb,
2557: ZX_SRVC_SUBSCRIPTIONS srvc,
2550: sysdate, --creation_date
2551: fnd_global.user_Id, --created_by
2552: sysdate, --last_update_date
2553: fnd_global.user_id, --last_updated_by
2554: fnd_global.conc_login_id --last_update_login;
2555: FROM ZX_REGIMES_USAGES ru,
2556: ZX_API_CODE_COMBINATIONS comb,
2557: ZX_SRVC_SUBSCRIPTIONS srvc,
2558: ZX_SERVICE_TYPES srvctypes
2585: SELECT ru.first_pty_org_id,
2586: 'USER_EXT',
2587: 'NEW',
2588: sysdate, --creation_date
2589: fnd_global.user_Id, --created_by
2590: sysdate, --last_update_date
2591: fnd_global.user_id, --last_updated_by
2592: fnd_global.conc_login_id --last_update_login;
2593: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
2587: 'NEW',
2588: sysdate, --creation_date
2589: fnd_global.user_Id, --created_by
2590: sysdate, --last_update_date
2591: fnd_global.user_id, --last_updated_by
2592: fnd_global.conc_login_id --last_update_login;
2593: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
2594: ZX_REGIMES_USAGES ru
2595: WHERE ru.regime_usage_id = p_regime_usage_id
2588: sysdate, --creation_date
2589: fnd_global.user_Id, --created_by
2590: sysdate, --last_update_date
2591: fnd_global.user_id, --last_updated_by
2592: fnd_global.conc_login_id --last_update_login;
2593: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
2594: ZX_REGIMES_USAGES ru
2595: WHERE ru.regime_usage_id = p_regime_usage_id
2596: AND srvc.srvc_provider_id = p_srvc_prvdr_id