DBA Data[Home] [Help]

APPS.HZ_BUSINESS_EVENT_V2PVT SQL Statements

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

Line: 66

        l_list.DELETE;
Line: 78

PROCEDURE update_person_event (
    p_person_rec                            IN     HZ_PARTY_V2PUB.PERSON_REC_TYPE,
    p_old_person_rec                        IN     HZ_PARTY_V2PUB.PERSON_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 87

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.Person.update';
Line: 90

   SAVEPOINT update_person_event;
Line: 131

        l_list.DELETE;
Line: 139

  ROLLBACK TO update_person_event;
Line: 141

END update_person_event;
Line: 195

        l_list.DELETE;
Line: 207

PROCEDURE update_group_event (
    p_group_rec                             IN     HZ_PARTY_V2PUB.GROUP_REC_TYPE,
    p_old_group_rec                         IN     HZ_PARTY_V2PUB.GROUP_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 216

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.Group.update';
Line: 219

  SAVEPOINT update_group_event;
Line: 260

        l_list.DELETE;
Line: 268

  ROLLBACK TO  update_group_event;
Line: 270

END update_group_event;
Line: 323

        l_list.DELETE;
Line: 335

PROCEDURE update_organization_event (
    p_organization_rec                      IN     HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
    p_old_organization_rec                  IN     HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 344

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.Organization.update';
Line: 347

  SAVEPOINT update_organization_event;
Line: 389

        l_list.DELETE;
Line: 397

  ROLLBACK TO update_organization_event;
Line: 399

END update_organization_event;
Line: 462

        l_list.DELETE;
Line: 474

PROCEDURE update_relationship_event (
    p_relationship_rec                      IN     HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
    p_old_relationship_rec                  IN     HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 483

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.Relationship.update';
Line: 486

   SAVEPOINT update_relationship_event;
Line: 529

        l_list.DELETE;
Line: 537

  ROLLBACK TO update_relationship_event;
Line: 539

END update_relationship_event;
Line: 594

        l_list.DELETE;
Line: 605

PROCEDURE update_party_site_event (
    p_party_site_rec                        IN     HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
    p_old_party_site_rec                    IN     HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 614

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.PartySite.update';
Line: 617

  SAVEPOINT update_party_site_event;
Line: 660

        l_list.DELETE;
Line: 668

  ROLLBACK TO update_party_site_event;
Line: 670

END update_party_site_event;
Line: 724

        l_list.DELETE;
Line: 736

PROCEDURE update_party_site_use_event (
    p_party_site_use_rec                    IN     HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE,
    p_old_party_site_use_rec                IN     HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 745

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.PartySiteUse.update';
Line: 748

  SAVEPOINT update_party_site_use_event;
Line: 790

        l_list.DELETE;
Line: 798

  ROLLBACK TO update_party_site_use_event;
Line: 800

END update_party_site_use_event;
Line: 855

        l_list.DELETE;
Line: 867

PROCEDURE update_org_contact_event (
    p_org_contact_rec                       IN     HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE,
    p_old_org_contact_rec                   IN     HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 876

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContact.update';
Line: 879

   SAVEPOINT update_org_contact_event;
Line: 922

        l_list.DELETE;
Line: 930

  ROLLBACK TO update_org_contact_event;
Line: 932

END update_org_contact_event;
Line: 985

        l_list.DELETE;
Line: 997

PROCEDURE update_org_contact_role_event (
    p_org_contact_role_rec                  IN     HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE,
    p_old_org_contact_role_rec              IN     HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1006

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContactRole.update';
Line: 1009

  SAVEPOINT update_org_contact_role_event;
Line: 1051

        l_list.DELETE;
Line: 1059

  ROLLBACK TO update_org_contact_role_event;
Line: 1061

END update_org_contact_role_event;
Line: 1116

        l_list.DELETE;
Line: 1128

PROCEDURE update_location_event (
    p_location_rec                          IN     HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
    p_old_location_rec                      IN     HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1137

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.Location.update';
Line: 1140

  SAVEPOINT update_location_event;
Line: 1183

        l_list.DELETE;
Line: 1191

  ROLLBACK TO update_location_event;
Line: 1193

END update_location_event;
Line: 1265

      l_list.delete;
Line: 1281

  PROCEDURE update_contact_point_event (
    p_contact_point_rec     IN   hz_contact_point_v2pub.contact_point_rec_type,
    p_old_contact_point_rec IN   hz_contact_point_v2pub.contact_point_rec_type,
    p_edi_rec               IN   hz_contact_point_v2pub.edi_rec_type,
    p_old_edi_rec           IN   hz_contact_point_v2pub.edi_rec_type,
    p_eft_rec               IN   hz_contact_point_v2pub.eft_rec_type,
    p_old_eft_rec           IN   hz_contact_point_v2pub.eft_rec_type,
    p_email_rec             IN   hz_contact_point_v2pub.email_rec_type,
    p_old_email_rec         IN   hz_contact_point_v2pub.email_rec_type,
    p_phone_rec             IN   hz_contact_point_v2pub.phone_rec_type,
    p_old_phone_rec         IN   hz_contact_point_v2pub.phone_rec_type,
    p_telex_rec             IN   hz_contact_point_v2pub.telex_rec_type,
    p_old_telex_rec         IN   hz_contact_point_v2pub.telex_rec_type,
    p_web_rec               IN   hz_contact_point_v2pub.web_rec_type,
    p_old_web_rec           IN   hz_contact_point_v2pub.web_rec_type
  ) IS

    l_list            WF_PARAMETER_LIST_T;
Line: 1302

    l_event_name      VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPoint.update';
Line: 1305

    SAVEPOINT update_contact_point_event;
Line: 1360

      l_list.delete;
Line: 1368

      ROLLBACK TO update_contact_point_event;
Line: 1369

  END update_contact_point_event;
Line: 1423

        l_list.DELETE;
Line: 1435

PROCEDURE update_contact_prefer_event (
    p_contact_preference_rec                IN     HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,
    p_old_contact_preference_rec            IN     HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1444

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPreference.update';
Line: 1447

  SAVEPOINT update_contact_prefer_event;
Line: 1489

        l_list.DELETE;
Line: 1497

  ROLLBACK TO update_contact_prefer_event;
Line: 1499

END update_contact_prefer_event;
Line: 1575

        l_list.DELETE;
Line: 1659

        l_list.DELETE;
Line: 1671

PROCEDURE update_cust_account_event (
    p_cust_account_rec                      IN     HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE,
    p_old_cust_account_rec                  IN     HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1680

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccount.update';
Line: 1683

   SAVEPOINT update_cust_account_event;
Line: 1725

        l_list.DELETE;
Line: 1733

  ROLLBACK TO update_cust_account_event;
Line: 1735

END update_cust_account_event;
Line: 1794

        l_list.DELETE;
Line: 1806

PROCEDURE update_cust_acct_relate_event (
    p_cust_acct_relate_rec                  IN     HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE,
    p_old_cust_acct_relate_rec              IN     HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1815

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctRelate.update';
Line: 1818

   SAVEPOINT update_cust_acct_relate_event;
Line: 1867

        l_list.DELETE;
Line: 1875

  ROLLBACK TO  update_cust_acct_relate_event;
Line: 1877

END update_cust_acct_relate_event;
Line: 1939

        l_list.DELETE;
Line: 1951

PROCEDURE update_customer_profile_event (
    p_customer_profile_rec                  IN     HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
    p_old_customer_profile_rec              IN     HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 1960

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustomerProfile.update';
Line: 1963

  SAVEPOINT update_customer_profile_event;
Line: 2005

        l_list.DELETE;
Line: 2013

  ROLLBACK TO update_customer_profile_event;
Line: 2015

END update_customer_profile_event;
Line: 2068

        l_list.DELETE;
Line: 2081

PROCEDURE update_cust_profile_amt_event (
    p_cust_profile_amt_rec                  IN     HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE,
    p_old_cust_profile_amt_rec              IN     HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2090

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustProfileAmt.update';
Line: 2093

  SAVEPOINT update_cust_profile_amt_event;
Line: 2133

        l_list.DELETE;
Line: 2141

  ROLLBACK TO update_cust_profile_amt_event;
Line: 2143

END update_cust_profile_amt_event;
Line: 2200

        l_list.DELETE;
Line: 2212

PROCEDURE update_cust_acct_site_event (
    p_cust_acct_site_rec                    IN     HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE,
    p_old_cust_acct_site_rec                IN     HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2221

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSite.update';
Line: 2224

   SAVEPOINT update_cust_acct_site_event;
Line: 2267

        l_list.DELETE;
Line: 2275

  ROLLBACK TO update_cust_acct_site_event;
Line: 2277

END update_cust_acct_site_event;
Line: 2353

        l_list.DELETE;
Line: 2365

PROCEDURE update_cust_site_use_event (
    p_cust_site_use_rec                     IN     HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE,
    p_old_cust_site_use_rec                 IN     HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2374

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSiteUse.update';
Line: 2377

   SAVEPOINT update_cust_site_use_event;
Line: 2420

        l_list.DELETE;
Line: 2428

  ROLLBACK TO update_cust_site_use_event;
Line: 2430

END update_cust_site_use_event;
Line: 2485

        l_list.DELETE;
Line: 2497

PROCEDURE update_cust_account_role_event (
    p_cust_account_role_rec                 IN     HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE,
    p_old_cust_account_role_rec             IN     HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2506

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccountRole.update';
Line: 2509

   SAVEPOINT update_cust_account_role_event;
Line: 2551

        l_list.DELETE;
Line: 2559

  ROLLBACK TO update_cust_account_role_event;
Line: 2561

END update_cust_account_role_event;
Line: 2614

        l_list.DELETE;
Line: 2626

PROCEDURE update_role_resp_event (
    p_role_responsibility_rec               IN     HZ_CUST_ACCOUNT_ROLE_V2PUB.ROLE_RESPONSIBILITY_REC_TYPE,
    p_old_role_responsibility_rec           IN     HZ_CUST_ACCOUNT_ROLE_V2PUB.ROLE_RESPONSIBILITY_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2635

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.RoleResponsibility.update';
Line: 2638

    SAVEPOINT update_role_resp_event;
Line: 2680

        l_list.DELETE;
Line: 2688

  ROLLBACK TO update_role_resp_event;
Line: 2690

END update_role_resp_event;
Line: 2745

        l_list.DELETE;
Line: 2757

PROCEDURE update_class_category_event (
    p_class_category_rec                    IN     HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_REC_TYPE,
    p_old_class_category_rec                IN     HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2766

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategory.update';
Line: 2769

    SAVEPOINT update_class_category_event;
Line: 2811

        l_list.DELETE;
Line: 2819

  ROLLBACK TO update_class_category_event;
Line: 2821

END update_class_category_event;
Line: 2870

        l_list.DELETE;
Line: 2883

PROCEDURE update_class_code_event (
    p_class_code_rec                    IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_REC_TYPE,
    p_old_class_code_rec                IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 2892

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCode.update';
Line: 2895

    SAVEPOINT update_class_code_event;
Line: 2931

        l_list.DELETE;
Line: 2939

  ROLLBACK TO update_class_category_event;
Line: 2941

END update_class_code_event;
Line: 3005

        l_list.DELETE;
Line: 3017

PROCEDURE update_class_code_rel_event (
    p_class_code_relation_rec               IN     HZ_CLASSIFICATION_V2PUB.CLASS_CODE_RELATION_REC_TYPE,
    p_old_class_code_relation_rec           IN     HZ_CLASSIFICATION_V2PUB.CLASS_CODE_RELATION_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 3026

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCodeRelation.update';
Line: 3029

   SAVEPOINT update_class_code_rel_event;
Line: 3081

        l_list.DELETE;
Line: 3089

  ROLLBACK TO update_class_code_rel_event;
Line: 3091

END update_class_code_rel_event;
Line: 3145

        l_list.DELETE;
Line: 3157

PROCEDURE update_code_assignment_event (
    p_code_assignment_rec                   IN     HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE,
    p_old_code_assignment_rec               IN     HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 3166

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.CodeAssignment.update';
Line: 3169

   SAVEPOINT update_code_assignment_event;
Line: 3212

        l_list.DELETE;
Line: 3220

  ROLLBACK TO update_code_assignment_event;
Line: 3222

END update_code_assignment_event;
Line: 3286

        l_list.DELETE;
Line: 3298

PROCEDURE update_class_cat_use_event (
    p_class_category_use_rec                IN     HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_USE_REC_TYPE,
    p_old_class_category_use_rec            IN     HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_USE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 3307

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategoryUse.update';
Line: 3310

    SAVEPOINT update_class_cat_use_event;
Line: 3362

        l_list.DELETE;
Line: 3370

  ROLLBACK TO update_class_cat_use_event;
Line: 3372

END update_class_cat_use_event;
Line: 3427

        l_list.DELETE;
Line: 3439

PROCEDURE update_person_language_event (
    p_person_language_rec                   IN     HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE,
    p_old_person_language_rec               IN     HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE
) IS

    l_list                                  WF_PARAMETER_LIST_T;
Line: 3448

    l_event_name                            VARCHAR2(240) := 'oracle.apps.ar.hz.PersonLanguage.update';
Line: 3451

   SAVEPOINT update_person_language_event;
Line: 3492

        l_list.DELETE;
Line: 3500

  ROLLBACK TO update_person_language_event;
Line: 3502

END update_person_language_event;
Line: 3554

   l_list.DELETE;
Line: 3567

PROCEDURE update_bill_pref_event
( p_billing_preferences_rec   IN HZ_CUST_ACCT_INFO_PUB.BILLING_PREFERENCES_REC_TYPE)
IS
 l_list wf_parameter_list_t;
Line: 3574

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.BillingPreference.update';
Line: 3576

 SAVEPOINT update_bill_pref_event;
Line: 3612

   l_list.DELETE;
Line: 3620

  ROLLBACK TO update_bill_pref_event;
Line: 3621

END update_bill_pref_event;
Line: 3669

   l_list.DELETE;
Line: 3681

PROCEDURE update_bank_acct_uses_event
( p_bank_acct_uses_rec   IN  HZ_CUST_ACCT_INFO_PUB.BANK_ACCT_USES_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 3688

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.BankAccountUse.update';
Line: 3690

 SAVEPOINT update_bank_acct_uses_event;
Line: 3726

   l_list.DELETE;
Line: 3735

END update_bank_acct_uses_event;
Line: 3783

   l_list.DELETE;
Line: 3795

PROCEDURE update_suspension_act_event
( p_suspension_activity_rec   IN  HZ_CUST_ACCT_INFO_PUB.SUSPENSION_ACTIVITY_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 3802

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.SuspensionActivity.update';
Line: 3804

 SAVEPOINT update_suspension_act_event;
Line: 3839

   l_list.DELETE;
Line: 3847

  ROLLBACK TO update_suspension_act_event;
Line: 3848

END update_suspension_act_event;
Line: 3900

   l_list.DELETE;
Line: 3913

PROCEDURE update_stock_markets_event
( p_stock_markets_rec IN HZ_ORG_INFO_PUB.STOCK_MARKETS_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 3920

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.StockMarket.update';
Line: 3922

 SAVEPOINT update_stock_markets_event;
Line: 3958

   l_list.DELETE;
Line: 3966

  ROLLBACK TO update_stock_markets_event;
Line: 3968

END update_stock_markets_event;
Line: 4016

   l_list.DELETE;
Line: 4029

PROCEDURE update_sec_issued_event
( p_security_issued_rec IN HZ_ORG_INFO_PUB.SECURITY_ISSUED_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 4036

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.SecurityIssued.update';
Line: 4038

 SAVEPOINT update_sec_issued_event;
Line: 4074

   l_list.DELETE;
Line: 4082

  ROLLBACK TO update_sec_issued_event;
Line: 4084

END update_sec_issued_event;
Line: 4132

   l_list.DELETE;
Line: 4145

PROCEDURE update_fin_reports_event
( p_financial_reports_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,
  p_old_financial_reports_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 4153

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialReport.update';
Line: 4155

 SAVEPOINT update_fin_reports_event;
Line: 4192

   l_list.DELETE;
Line: 4200

  ROLLBACK TO update_fin_reports_event;
Line: 4202

END update_fin_reports_event;
Line: 4250

   l_list.DELETE;
Line: 4263

PROCEDURE update_fin_numbers_event
( p_financial_numbers_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE ,
  p_old_financial_numbers_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 4271

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialNumber.update';
Line: 4273

 SAVEPOINT update_fin_numbers_events;
Line: 4310

   l_list.DELETE;
Line: 4318

  ROLLBACK TO update_fin_numbers_event;
Line: 4319

END update_fin_numbers_event;
Line: 4368

   l_list.DELETE;
Line: 4380

PROCEDURE update_certifications_event
( p_certifications_rec IN HZ_ORG_INFO_PUB.CERTIFICATIONS_REC_TYPE )
IS
 l_list wf_parameter_list_t;
Line: 4387

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.Certification.update';
Line: 4389

 SAVEPOINT update_certifications_event;
Line: 4426

   l_list.DELETE;
Line: 4434

  ROLLBACK TO update_certifications_event;
Line: 4435

END update_certifications_event;
Line: 4484

   l_list.DELETE;
Line: 4497

PROCEDURE update_person_interest_event
(p_per_interest_rec       IN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE,
 p_old_per_interest_rec   IN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE
)
IS
 l_list wf_parameter_list_t;
Line: 4506

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.PersonInterest.update';
Line: 4508

 SAVEPOINT update_per_interest_event;
Line: 4545

   l_list.DELETE;
Line: 4553

  ROLLBACK TO update_per_interest_event;
Line: 4555

END update_person_interest_event;
Line: 4603

   l_list.DELETE;
Line: 4617

PROCEDURE update_citizenship_event
(p_citizenship_rec       IN HZ_PERSON_INFO_V2PUB.CITIZENSHIP_REC_TYPE,
 p_old_citizenship_rec   IN HZ_PERSON_INFO_V2PUB.CITIZENSHIP_REC_TYPE
 )
IS
 l_list wf_parameter_list_t;
Line: 4626

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.Citizenship.update';
Line: 4628

 SAVEPOINT update_citizenship_event;
Line: 4665

   l_list.DELETE;
Line: 4673

  ROLLBACK TO update_citizenship_event;
Line: 4675

END update_citizenship_event;
Line: 4724

   l_list.DELETE;
Line: 4738

PROCEDURE update_education_event
(p_education_rec   IN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE,
 p_old_education_rec   IN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE
 )
IS
 l_list wf_parameter_list_t;
Line: 4747

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.Education.update';
Line: 4749

 SAVEPOINT update_education_event;
Line: 4786

   l_list.DELETE;
Line: 4794

  ROLLBACK TO update_education_event;
Line: 4796

END update_education_event;
Line: 4800

PROCEDURE update_emp_history_event
(p_emp_history_rec   IN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE,
 p_old_emp_history_rec   IN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE
)
IS
 l_list wf_parameter_list_t;
Line: 4809

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.EmploymentHistory.update';
Line: 4811

 SAVEPOINT update_emp_history_event;
Line: 4848

   l_list.DELETE;
Line: 4856

  ROLLBACK TO update_emp_history_event;
Line: 4858

END update_emp_history_event;
Line: 4906

   l_list.DELETE;
Line: 4964

   l_list.DELETE;
Line: 4977

PROCEDURE update_work_class_event
(p_work_class_rec       IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE,
 p_old_work_class_rec   IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE)
IS
 l_list wf_parameter_list_t;
Line: 4985

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.WorkClass.update';
Line: 4987

 SAVEPOINT update_work_class_event;
Line: 5024

   l_list.DELETE;
Line: 5032

  ROLLBACK TO update_work_class_event;
Line: 5034

END update_work_class_event;
Line: 5085

   l_list.DELETE;
Line: 5098

PROCEDURE update_credit_ratings_event
(p_credit_ratings_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE,
 p_old_credit_ratings_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE)
IS
 l_list wf_parameter_list_t;
Line: 5106

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.CreditRating.update';
Line: 5108

 SAVEPOINT update_credit_ratings_event;
Line: 5145

   l_list.DELETE;
Line: 5153

  ROLLBACK TO update_credit_ratings_event;
Line: 5155

END update_credit_ratings_event;
Line: 5203

   l_list.DELETE;
Line: 5216

PROCEDURE update_fin_profile_event
(p_financial_profile_rec IN HZ_PARTY_INFO_PUB.FINANCIAL_PROFILE_REC_TYPE)
IS
 l_list wf_parameter_list_t;
Line: 5223

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialProfile.update';
Line: 5260

   l_list.DELETE;
Line: 5268

  ROLLBACK TO update_fin_profile_event;
Line: 5270

END update_fin_profile_event;
Line: 5317

   l_list.DELETE;
Line: 5329

PROCEDURE update_orig_system_ref_event (
    p_orig_sys_reference_rec	  IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
    p_old_orig_sys_reference_re   IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
  )
IS
 l_list wf_parameter_list_t;
Line: 5338

 l_event_name varchar2(240) := 'oracle.apps.ar.hz.origSystemRef.update';
Line: 5341

  SAVEPOINT update_orig_system_ref_event;
Line: 5378

   l_list.DELETE;
Line: 5386

  ROLLBACK TO update_orig_system_ref_event;
Line: 5388

END update_orig_system_ref_event;