APPS.ZX_PARTY_TAX_PROFILE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure INSERT_ROW (
  P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
  P_PROVIDER_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
  P_TAX_CLASSIFICATION_CODE in VARCHAR2,
  P_SELF_ASSESS_FLAG in VARCHAR2,
  P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
  P_REP_REGISTRATION_NUMBER in VARCHAR2,
  P_EFFECTIVE_FROM_USE_LE in DATE,
  P_RECORD_TYPE_CODE in VARCHAR2,
  P_REQUEST_ID in NUMBER,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_PARTY_ID in NUMBER,
  P_PROGRAM_LOGIN_ID in NUMBER,
  P_PARTY_TYPE_CODE in VARCHAR2,
  P_SUPPLIER_FLAG in VARCHAR2,
  P_CUSTOMER_FLAG in VARCHAR2,
  P_SITE_FLAG in VARCHAR2,
  P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
  P_ROUNDING_LEVEL_CODE in VARCHAR2,
  P_ROUNDING_RULE_CODE in VARCHAR2,
  P_WITHHOLDING_START_DATE in DATE,
  P_INCLUSIVE_TAX_FLAG in VARCHAR2,
  P_ALLOW_AWT_FLAG in VARCHAR2,
  P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
  P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
  P_FIRST_PARTY_LE_FLAG in VARCHAR2,
  P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
  X_RETURN_STATUS out NOCOPY VARCHAR2
) is
  L_PARTY_TAX_PROFILE_ID	ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line: 53

  CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
  WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;

Line: 58

  select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

Line: 63

  select nvl(substr(created_by_module,1,3),'ZX') created_by_module
    into L_CREATED_BY_MODULE
    from hz_parties where party_id = P_PARTY_ID;

Line: 82

    insert into ZX_PARTY_TAX_PROFILE (
    COLLECTING_AUTHORITY_FLAG,
    PROVIDER_TYPE_CODE,
    CREATE_AWT_DISTS_TYPE_CODE,
    CREATE_AWT_INVOICES_TYPE_CODE,
    TAX_CLASSIFICATION_CODE,
    SELF_ASSESS_FLAG,
    ALLOW_OFFSET_TAX_FLAG,
    REP_REGISTRATION_NUMBER,
    EFFECTIVE_FROM_USE_LE,
    RECORD_TYPE_CODE,
    REQUEST_ID,
    PARTY_TAX_PROFILE_ID,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    PARTY_ID,
    PROGRAM_LOGIN_ID,
    PARTY_TYPE_CODE,
    SUPPLIER_FLAG,
    CUSTOMER_FLAG,
    SITE_FLAG,
    PROCESS_FOR_APPLICABILITY_FLAG,
    ROUNDING_LEVEL_CODE,
    ROUNDING_RULE_CODE,
    WITHHOLDING_START_DATE,
    INCLUSIVE_TAX_FLAG,
    ALLOW_AWT_FLAG,
    USE_LE_AS_SUBSCRIBER_FLAG,
    LEGAL_ESTABLISHMENT_FLAG,
    FIRST_PARTY_LE_FLAG,
    REPORTING_AUTHORITY_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    P_COLLECTING_AUTHORITY_FLAG,
    P_PROVIDER_TYPE_CODE,
    P_CREATE_AWT_DISTS_TYPE_CODE,
    P_CREATE_AWT_INVOICES_TYPE_COD,
    P_TAX_CLASSIFICATION_CODE,
    P_SELF_ASSESS_FLAG,
    P_ALLOW_OFFSET_TAX_FLAG,
    DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,
           NULL, P_REP_REGISTRATION_NUMBER),
    L_EFFECTIVE_FROM_USE_LE,
    P_RECORD_TYPE_CODE,
    P_REQUEST_ID,
    L_PARTY_TAX_PROFILE_ID,
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_ATTRIBUTE7,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE10,
    P_ATTRIBUTE11,
    P_ATTRIBUTE12,
    P_ATTRIBUTE13,
    P_ATTRIBUTE14,
    P_ATTRIBUTE15,
    P_ATTRIBUTE_CATEGORY,
    P_PARTY_ID,
    P_PROGRAM_LOGIN_ID,
    P_PARTY_TYPE_CODE,
    P_SUPPLIER_FLAG,
    P_CUSTOMER_FLAG,
    P_SITE_FLAG,
    P_PROCESS_FOR_APPLICABILITY_FL,
    P_ROUNDING_LEVEL_CODE,
    P_ROUNDING_RULE_CODE,
    P_WITHHOLDING_START_DATE,
    P_INCLUSIVE_TAX_FLAG,
    P_ALLOW_AWT_FLAG,
    P_USE_LE_AS_SUBSCRIBER_FLAG,
    P_LEGAL_ESTABLISHMENT_FLAG,
    P_FIRST_PARTY_LE_FLAG,
    P_REPORTING_AUTHORITY_FLAG,
    sysdate,
    FND_GLOBAL.User_ID,
    sysdate,
    FND_GLOBAL.User_ID,
    FND_GLOBAL.Login_ID,
    1
    );

Line: 191

	  arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

Line: 201

end INSERT_ROW;

Line: 204

procedure INSERT_ROW (
  P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
  P_PROVIDER_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
  P_TAX_CLASSIFICATION_CODE in VARCHAR2,
  P_SELF_ASSESS_FLAG in VARCHAR2,
  P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
  P_REP_REGISTRATION_NUMBER in VARCHAR2,
  P_EFFECTIVE_FROM_USE_LE in DATE,
  P_RECORD_TYPE_CODE in VARCHAR2,
  P_REQUEST_ID in NUMBER,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_PARTY_ID in NUMBER,
  P_PROGRAM_LOGIN_ID in NUMBER,
  P_PARTY_TYPE_CODE in VARCHAR2,
  P_SUPPLIER_FLAG in VARCHAR2,
  P_CUSTOMER_FLAG in VARCHAR2,
  P_SITE_FLAG in VARCHAR2,
  P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
  P_ROUNDING_LEVEL_CODE in VARCHAR2,
  P_ROUNDING_RULE_CODE in VARCHAR2,
  P_WITHHOLDING_START_DATE in DATE,
  P_INCLUSIVE_TAX_FLAG in VARCHAR2,
  P_ALLOW_AWT_FLAG in VARCHAR2,
  P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
  P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
  P_FIRST_PARTY_LE_FLAG in VARCHAR2,
  P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
  X_RETURN_STATUS out NOCOPY VARCHAR2,
  P_REGISTRATION_TYPE_CODE IN VARCHAR2,
  P_COUNTRY_CODE IN VARCHAR2
) is
  L_PARTY_TAX_PROFILE_ID	ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line: 255

  CURSOR ptp_cur IS SELECT PARTY_TAX_PROFILE_ID FROM ZX_PARTY_TAX_PROFILE
  WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;

Line: 260

  select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

Line: 263

  select nvl(substr(created_by_module,1,3),'ZX') created_by_module
    into L_CREATED_BY_MODULE
    from hz_parties where party_id = P_PARTY_ID;

Line: 284

    insert into ZX_PARTY_TAX_PROFILE (
    COLLECTING_AUTHORITY_FLAG,
    PROVIDER_TYPE_CODE,
    CREATE_AWT_DISTS_TYPE_CODE,
    CREATE_AWT_INVOICES_TYPE_CODE,
    TAX_CLASSIFICATION_CODE,
    SELF_ASSESS_FLAG,
    ALLOW_OFFSET_TAX_FLAG,
    REP_REGISTRATION_NUMBER,
    EFFECTIVE_FROM_USE_LE,
    RECORD_TYPE_CODE,
    REQUEST_ID,
    PARTY_TAX_PROFILE_ID,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    PARTY_ID,
    PROGRAM_LOGIN_ID,
    PARTY_TYPE_CODE,
    SUPPLIER_FLAG,
    CUSTOMER_FLAG,
    SITE_FLAG,
    PROCESS_FOR_APPLICABILITY_FLAG,
    ROUNDING_LEVEL_CODE,
    ROUNDING_RULE_CODE,
    WITHHOLDING_START_DATE,
    INCLUSIVE_TAX_FLAG,
    ALLOW_AWT_FLAG,
    USE_LE_AS_SUBSCRIBER_FLAG,
    LEGAL_ESTABLISHMENT_FLAG,
    FIRST_PARTY_LE_FLAG,
    REPORTING_AUTHORITY_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    REGISTRATION_TYPE_CODE,
    COUNTRY_CODE
  ) values (
    P_COLLECTING_AUTHORITY_FLAG,
    P_PROVIDER_TYPE_CODE,
    P_CREATE_AWT_DISTS_TYPE_CODE,
    P_CREATE_AWT_INVOICES_TYPE_COD,
    P_TAX_CLASSIFICATION_CODE,
    P_SELF_ASSESS_FLAG,
    P_ALLOW_OFFSET_TAX_FLAG,
    DECODE(P_REP_REGISTRATION_NUMBER, fnd_api.g_miss_char,
           NULL, P_REP_REGISTRATION_NUMBER),
    L_EFFECTIVE_FROM_USE_LE,
    P_RECORD_TYPE_CODE,
    P_REQUEST_ID,
    L_PARTY_TAX_PROFILE_ID,
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_ATTRIBUTE7,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE10,
    P_ATTRIBUTE11,
    P_ATTRIBUTE12,
    P_ATTRIBUTE13,
    P_ATTRIBUTE14,
    P_ATTRIBUTE15,
    P_ATTRIBUTE_CATEGORY,
    P_PARTY_ID,
    P_PROGRAM_LOGIN_ID,
    P_PARTY_TYPE_CODE,
    P_SUPPLIER_FLAG,
    P_CUSTOMER_FLAG,
    P_SITE_FLAG,
    P_PROCESS_FOR_APPLICABILITY_FL,
    P_ROUNDING_LEVEL_CODE,
    P_ROUNDING_RULE_CODE,
    P_WITHHOLDING_START_DATE,
    P_INCLUSIVE_TAX_FLAG,
    P_ALLOW_AWT_FLAG,
    P_USE_LE_AS_SUBSCRIBER_FLAG,
    P_LEGAL_ESTABLISHMENT_FLAG,
    P_FIRST_PARTY_LE_FLAG,
    P_REPORTING_AUTHORITY_FLAG,
    sysdate,
    FND_GLOBAL.User_ID,
    sysdate,
    FND_GLOBAL.User_ID,
    FND_GLOBAL.Login_ID,
    1,
    P_REGISTRATION_TYPE_CODE,
    P_COUNTRY_CODE
    );

Line: 397

	  arp_util_tax.debug('Error: "The Ptp row has not been inserted for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

Line: 407

end INSERT_ROW;

Line: 410

procedure UPDATE_ROW (
  P_PARTY_TAX_PROFILE_ID in NUMBER,
  P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
  P_PROVIDER_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
  P_TAX_CLASSIFICATION_CODE in VARCHAR2,
  P_SELF_ASSESS_FLAG in VARCHAR2,
  P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
  P_REP_REGISTRATION_NUMBER in VARCHAR2,
  P_EFFECTIVE_FROM_USE_LE in DATE,
  P_RECORD_TYPE_CODE in VARCHAR2,
  P_REQUEST_ID in NUMBER,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_PARTY_ID in NUMBER,
  P_PROGRAM_LOGIN_ID in NUMBER,
  P_PARTY_TYPE_CODE in VARCHAR2,
  P_SUPPLIER_FLAG in VARCHAR2,
  P_CUSTOMER_FLAG in VARCHAR2,
  P_SITE_FLAG in VARCHAR2,
  P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
  P_ROUNDING_LEVEL_CODE in VARCHAR2,
  P_ROUNDING_RULE_CODE in VARCHAR2,
  P_WITHHOLDING_START_DATE in DATE,
  P_INCLUSIVE_TAX_FLAG in VARCHAR2,
  P_ALLOW_AWT_FLAG in VARCHAR2,
  P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
  P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
  P_FIRST_PARTY_LE_FLAG in VARCHAR2,
  P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
  X_RETURN_STATUS out NOCOPY VARCHAR2
) is
  L_EFFECTIVE_FROM_USE_LE	ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE	:= P_EFFECTIVE_FROM_USE_LE;

Line: 475

    update ZX_PARTY_TAX_PROFILE set
    COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
    PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
    CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
    CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),
    TAX_CLASSIFICATION_CODE = DECODE( P_TAX_CLASSIFICATION_CODE, NULL, TAX_CLASSIFICATION_CODE, P_TAX_CLASSIFICATION_CODE ),
    SELF_ASSESS_FLAG = DECODE( P_SELF_ASSESS_FLAG, NULL, SELF_ASSESS_FLAG, P_SELF_ASSESS_FLAG ),
    ALLOW_OFFSET_TAX_FLAG = DECODE( P_ALLOW_OFFSET_TAX_FLAG, NULL, ALLOW_OFFSET_TAX_FLAG, P_ALLOW_OFFSET_TAX_FLAG ),
    REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),
    EFFECTIVE_FROM_USE_LE = DECODE( L_EFFECTIVE_FROM_USE_LE, NULL, EFFECTIVE_FROM_USE_LE, L_EFFECTIVE_FROM_USE_LE ),
    RECORD_TYPE_CODE = DECODE( P_RECORD_TYPE_CODE, NULL, RECORD_TYPE_CODE, P_RECORD_TYPE_CODE ),
    REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
    ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),
    ATTRIBUTE2 = DECODE( P_ATTRIBUTE2, NULL, ATTRIBUTE2, P_ATTRIBUTE2 ),
    ATTRIBUTE3 = DECODE( P_ATTRIBUTE3, NULL, ATTRIBUTE3, P_ATTRIBUTE3 ),
    ATTRIBUTE4 = DECODE( P_ATTRIBUTE4, NULL, ATTRIBUTE4, P_ATTRIBUTE4 ),
    ATTRIBUTE5 = DECODE( P_ATTRIBUTE5, NULL, ATTRIBUTE5, P_ATTRIBUTE5 ),
    ATTRIBUTE6 = DECODE( P_ATTRIBUTE6, NULL, ATTRIBUTE6, P_ATTRIBUTE6 ),
    ATTRIBUTE7 = DECODE( P_ATTRIBUTE7, NULL, ATTRIBUTE7, P_ATTRIBUTE7 ),
    ATTRIBUTE8 = DECODE( P_ATTRIBUTE8, NULL, ATTRIBUTE8, P_ATTRIBUTE8 ),
    ATTRIBUTE9 = DECODE( P_ATTRIBUTE9, NULL, ATTRIBUTE9, P_ATTRIBUTE9 ),
    ATTRIBUTE10 = DECODE( P_ATTRIBUTE10, NULL, ATTRIBUTE10, P_ATTRIBUTE10 ),
    ATTRIBUTE11 = DECODE( P_ATTRIBUTE11, NULL, ATTRIBUTE11, P_ATTRIBUTE11 ),
    ATTRIBUTE12 = DECODE( P_ATTRIBUTE12, NULL, ATTRIBUTE12, P_ATTRIBUTE12 ),
    ATTRIBUTE13 = DECODE( P_ATTRIBUTE13, NULL, ATTRIBUTE13, P_ATTRIBUTE13 ),
    ATTRIBUTE14 = DECODE( P_ATTRIBUTE14, NULL, ATTRIBUTE14, P_ATTRIBUTE14 ),
    ATTRIBUTE15 = DECODE( P_ATTRIBUTE15, NULL, ATTRIBUTE15, P_ATTRIBUTE15 ),
    ATTRIBUTE_CATEGORY = DECODE( P_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY ),
    PARTY_ID = DECODE( P_PARTY_ID, NULL, PARTY_ID, P_PARTY_ID ),
    PROGRAM_LOGIN_ID = DECODE( P_PROGRAM_LOGIN_ID, NULL, PROGRAM_LOGIN_ID, P_PROGRAM_LOGIN_ID ),
    PARTY_TYPE_CODE = DECODE( P_PARTY_TYPE_CODE, NULL, PARTY_TYPE_CODE, P_PARTY_TYPE_CODE),
    SUPPLIER_FLAG = DECODE( P_SUPPLIER_FLAG, NULL, SUPPLIER_FLAG, P_SUPPLIER_FLAG ),
    CUSTOMER_FLAG = DECODE( P_CUSTOMER_FLAG, NULL, CUSTOMER_FLAG, P_CUSTOMER_FLAG ),
    SITE_FLAG = DECODE( P_SITE_FLAG, NULL, SITE_FLAG, P_SITE_FLAG ),
    PROCESS_FOR_APPLICABILITY_FLAG = DECODE( P_PROCESS_FOR_APPLICABILITY_FL, NULL, PROCESS_FOR_APPLICABILITY_FLAG, P_PROCESS_FOR_APPLICABILITY_FL ),
    ROUNDING_LEVEL_CODE = DECODE( P_ROUNDING_LEVEL_CODE, NULL, ROUNDING_LEVEL_CODE, P_ROUNDING_LEVEL_CODE ),
    ROUNDING_RULE_CODE = DECODE( P_ROUNDING_RULE_CODE, NULL, ROUNDING_RULE_CODE, P_ROUNDING_RULE_CODE ),
    WITHHOLDING_START_DATE = DECODE( P_WITHHOLDING_START_DATE, NULL, WITHHOLDING_START_DATE, P_WITHHOLDING_START_DATE ),
    INCLUSIVE_TAX_FLAG = DECODE( P_INCLUSIVE_TAX_FLAG, NULL, INCLUSIVE_TAX_FLAG, P_INCLUSIVE_TAX_FLAG ),
    ALLOW_AWT_FLAG = DECODE( P_ALLOW_AWT_FLAG, NULL, ALLOW_AWT_FLAG, P_ALLOW_AWT_FLAG ),
    USE_LE_AS_SUBSCRIBER_FLAG = DECODE( P_USE_LE_AS_SUBSCRIBER_FLAG, NULL, USE_LE_AS_SUBSCRIBER_FLAG, P_USE_LE_AS_SUBSCRIBER_FLAG ),
    LEGAL_ESTABLISHMENT_FLAG = DECODE( P_LEGAL_ESTABLISHMENT_FLAG, NULL, LEGAL_ESTABLISHMENT_FLAG, P_LEGAL_ESTABLISHMENT_FLAG ),
    FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
    REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = FND_GLOBAL.User_ID,
    LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
    where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;

Line: 527

      arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

Line: 530

end UPDATE_ROW;

Line: 532

procedure UPDATE_ROW (
  P_PARTY_TAX_PROFILE_ID in NUMBER,
  P_COLLECTING_AUTHORITY_FLAG in VARCHAR2,
  P_PROVIDER_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_DISTS_TYPE_CODE in VARCHAR2,
  P_CREATE_AWT_INVOICES_TYPE_COD in VARCHAR2,
  P_TAX_CLASSIFICATION_CODE in VARCHAR2,
  P_SELF_ASSESS_FLAG in VARCHAR2,
  P_ALLOW_OFFSET_TAX_FLAG in VARCHAR2,
  P_REP_REGISTRATION_NUMBER in VARCHAR2,
  P_EFFECTIVE_FROM_USE_LE in DATE,
  P_RECORD_TYPE_CODE in VARCHAR2,
  P_REQUEST_ID in NUMBER,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_PARTY_ID in NUMBER,
  P_PROGRAM_LOGIN_ID in NUMBER,
  P_PARTY_TYPE_CODE in VARCHAR2,
  P_SUPPLIER_FLAG in VARCHAR2,
  P_CUSTOMER_FLAG in VARCHAR2,
  P_SITE_FLAG in VARCHAR2,
  P_PROCESS_FOR_APPLICABILITY_FL in VARCHAR2,
  P_ROUNDING_LEVEL_CODE in VARCHAR2,
  P_ROUNDING_RULE_CODE in VARCHAR2,
  P_WITHHOLDING_START_DATE in DATE,
  P_INCLUSIVE_TAX_FLAG in VARCHAR2,
  P_ALLOW_AWT_FLAG in VARCHAR2,
  P_USE_LE_AS_SUBSCRIBER_FLAG in VARCHAR2,
  P_LEGAL_ESTABLISHMENT_FLAG in VARCHAR2,
  P_FIRST_PARTY_LE_FLAG in VARCHAR2,
  P_REPORTING_AUTHORITY_FLAG in VARCHAR2,
  X_RETURN_STATUS out NOCOPY VARCHAR2,
  P_REGISTRATION_TYPE_CODE in VARCHAR2,
  P_COUNTRY_CODE in VARCHAR2
) is
  L_EFFECTIVE_FROM_USE_LE	ZX_PARTY_TAX_PROFILE.EFFECTIVE_FROM_USE_LE%TYPE	:= P_EFFECTIVE_FROM_USE_LE;

Line: 599

    update ZX_PARTY_TAX_PROFILE set
    COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
    PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
    CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
    CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),
    TAX_CLASSIFICATION_CODE = DECODE( P_TAX_CLASSIFICATION_CODE, NULL, TAX_CLASSIFICATION_CODE, P_TAX_CLASSIFICATION_CODE ),
    SELF_ASSESS_FLAG = DECODE( P_SELF_ASSESS_FLAG, NULL, SELF_ASSESS_FLAG, P_SELF_ASSESS_FLAG ),
    ALLOW_OFFSET_TAX_FLAG = DECODE( P_ALLOW_OFFSET_TAX_FLAG, NULL, ALLOW_OFFSET_TAX_FLAG, P_ALLOW_OFFSET_TAX_FLAG ),
    REP_REGISTRATION_NUMBER = DECODE( P_REP_REGISTRATION_NUMBER, NULL, REP_REGISTRATION_NUMBER,fnd_api.g_miss_char, NULL, P_REP_REGISTRATION_NUMBER ),
    EFFECTIVE_FROM_USE_LE = DECODE( L_EFFECTIVE_FROM_USE_LE, NULL, EFFECTIVE_FROM_USE_LE, L_EFFECTIVE_FROM_USE_LE ),
    RECORD_TYPE_CODE = DECODE( P_RECORD_TYPE_CODE, NULL, RECORD_TYPE_CODE, P_RECORD_TYPE_CODE ),
    REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
    ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),
    ATTRIBUTE2 = DECODE( P_ATTRIBUTE2, NULL, ATTRIBUTE2, P_ATTRIBUTE2 ),
    ATTRIBUTE3 = DECODE( P_ATTRIBUTE3, NULL, ATTRIBUTE3, P_ATTRIBUTE3 ),
    ATTRIBUTE4 = DECODE( P_ATTRIBUTE4, NULL, ATTRIBUTE4, P_ATTRIBUTE4 ),
    ATTRIBUTE5 = DECODE( P_ATTRIBUTE5, NULL, ATTRIBUTE5, P_ATTRIBUTE5 ),
    ATTRIBUTE6 = DECODE( P_ATTRIBUTE6, NULL, ATTRIBUTE6, P_ATTRIBUTE6 ),
    ATTRIBUTE7 = DECODE( P_ATTRIBUTE7, NULL, ATTRIBUTE7, P_ATTRIBUTE7 ),
    ATTRIBUTE8 = DECODE( P_ATTRIBUTE8, NULL, ATTRIBUTE8, P_ATTRIBUTE8 ),
    ATTRIBUTE9 = DECODE( P_ATTRIBUTE9, NULL, ATTRIBUTE9, P_ATTRIBUTE9 ),
    ATTRIBUTE10 = DECODE( P_ATTRIBUTE10, NULL, ATTRIBUTE10, P_ATTRIBUTE10 ),
    ATTRIBUTE11 = DECODE( P_ATTRIBUTE11, NULL, ATTRIBUTE11, P_ATTRIBUTE11 ),
    ATTRIBUTE12 = DECODE( P_ATTRIBUTE12, NULL, ATTRIBUTE12, P_ATTRIBUTE12 ),
    ATTRIBUTE13 = DECODE( P_ATTRIBUTE13, NULL, ATTRIBUTE13, P_ATTRIBUTE13 ),
    ATTRIBUTE14 = DECODE( P_ATTRIBUTE14, NULL, ATTRIBUTE14, P_ATTRIBUTE14 ),
    ATTRIBUTE15 = DECODE( P_ATTRIBUTE15, NULL, ATTRIBUTE15, P_ATTRIBUTE15 ),
    ATTRIBUTE_CATEGORY = DECODE( P_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY ),
    PARTY_ID = DECODE( P_PARTY_ID, NULL, PARTY_ID, P_PARTY_ID ),
    PROGRAM_LOGIN_ID = DECODE( P_PROGRAM_LOGIN_ID, NULL, PROGRAM_LOGIN_ID, P_PROGRAM_LOGIN_ID ),
    PARTY_TYPE_CODE = DECODE( P_PARTY_TYPE_CODE, NULL, PARTY_TYPE_CODE, P_PARTY_TYPE_CODE),
    SUPPLIER_FLAG = DECODE( P_SUPPLIER_FLAG, NULL, SUPPLIER_FLAG, P_SUPPLIER_FLAG ),
    CUSTOMER_FLAG = DECODE( P_CUSTOMER_FLAG, NULL, CUSTOMER_FLAG, P_CUSTOMER_FLAG ),
    SITE_FLAG = DECODE( P_SITE_FLAG, NULL, SITE_FLAG, P_SITE_FLAG ),
    PROCESS_FOR_APPLICABILITY_FLAG = DECODE( P_PROCESS_FOR_APPLICABILITY_FL, NULL, PROCESS_FOR_APPLICABILITY_FLAG, P_PROCESS_FOR_APPLICABILITY_FL ),
    ROUNDING_LEVEL_CODE = DECODE( P_ROUNDING_LEVEL_CODE, NULL, ROUNDING_LEVEL_CODE, P_ROUNDING_LEVEL_CODE ),
    ROUNDING_RULE_CODE = DECODE( P_ROUNDING_RULE_CODE, NULL, ROUNDING_RULE_CODE, P_ROUNDING_RULE_CODE ),
    WITHHOLDING_START_DATE = DECODE( P_WITHHOLDING_START_DATE, NULL, WITHHOLDING_START_DATE, P_WITHHOLDING_START_DATE ),
    INCLUSIVE_TAX_FLAG = DECODE( P_INCLUSIVE_TAX_FLAG, NULL, INCLUSIVE_TAX_FLAG, P_INCLUSIVE_TAX_FLAG ),
    ALLOW_AWT_FLAG = DECODE( P_ALLOW_AWT_FLAG, NULL, ALLOW_AWT_FLAG, P_ALLOW_AWT_FLAG ),
    USE_LE_AS_SUBSCRIBER_FLAG = DECODE( P_USE_LE_AS_SUBSCRIBER_FLAG, NULL, USE_LE_AS_SUBSCRIBER_FLAG, P_USE_LE_AS_SUBSCRIBER_FLAG ),
    LEGAL_ESTABLISHMENT_FLAG = DECODE( P_LEGAL_ESTABLISHMENT_FLAG, NULL, LEGAL_ESTABLISHMENT_FLAG, P_LEGAL_ESTABLISHMENT_FLAG ),
    FIRST_PARTY_LE_FLAG = DECODE( P_FIRST_PARTY_LE_FLAG, NULL, FIRST_PARTY_LE_FLAG, P_FIRST_PARTY_LE_FLAG ),
    REPORTING_AUTHORITY_FLAG = DECODE( P_REPORTING_AUTHORITY_FLAG, NULL, REPORTING_AUTHORITY_FLAG, P_REPORTING_AUTHORITY_FLAG ),
    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = FND_GLOBAL.User_ID,
    LAST_UPDATE_LOGIN = FND_GLOBAL.Login_ID,
    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
    REGISTRATION_TYPE_CODE = DECODE (P_REGISTRATION_TYPE_CODE,NULL, REGISTRATION_TYPE_CODE, P_REGISTRATION_TYPE_CODE),
    COUNTRY_CODE = DECODE (P_COUNTRY_CODE,NULL, COUNTRY_CODE, P_COUNTRY_CODE)
    where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;

Line: 653

      arp_util_tax.debug('Error: "The Ptp row has not been updated for Party Id: ' || P_PARTY_ID || ' and Party Type: ' ||P_PARTY_TYPE_CODE || '."');

Line: 656

end UPDATE_ROW;

Line: 658

procedure DELETE_ROW (
  P_PARTY_TAX_PROFILE_ID in NUMBER,
  X_RETURN_STATUS out NOCOPY VARCHAR2
) is
begin
  --Initialise x_return_status variable
  X_RETURN_STATUS :=  FND_API.G_RET_STS_SUCCESS;

Line: 666

  delete from ZX_PARTY_TAX_PROFILE
  where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;

Line: 674

end DELETE_ROW;