APPS.ARH_CPC_PKG dependencies on HZ_CUST_PROFILE_CLASSES

Line 160: from hz_cust_profile_classes

156: select 1
157: into profile_class_count
158: from dual
159: where not exists ( select 1
160: from hz_cust_profile_classes
161: where name = c_profile_class_name
162: and profile_class_id >= 0
163: and ( ( c_rowid is null ) or ( rowid <> c_rowid ) )
164: );

Line 495: FROM hz_cust_profile_classes

491: X_MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 DEFAULT NULL,
492: X_CHARGE_BEGIN_DATE DATE DEFAULT NULL)
493: IS
494: CURSOR C IS SELECT rowid
495: FROM hz_cust_profile_classes
496: WHERE profile_class_id = X_Customer_Profile_Class_Id;
497:
498: BEGIN
499: IF X_CUSTOMER_PROFILE_CLASS_ID IS NULL THEN

Line 500: select hz_cust_profile_classes_s.nextval

496: WHERE profile_class_id = X_Customer_Profile_Class_Id;
497:
498: BEGIN
499: IF X_CUSTOMER_PROFILE_CLASS_ID IS NULL THEN
500: select hz_cust_profile_classes_s.nextval
501: into x_customer_profile_class_id
502: from dual;
503: END IF;
504:

Line 511: INSERT INTO HZ_CUST_PROFILE_CLASSES(

507: check_unique
508: ( c_profile_class_name => x_customer_profile_class_id,
509: c_rowid => x_row_id );
510:
511: INSERT INTO HZ_CUST_PROFILE_CLASSES(
512: profile_class_id,
513: last_updated_by,
514: last_update_date,
515: last_update_login,

Line 1038: FROM HZ_CUST_PROFILE_CLASSES

1034: X_CHARGE_BEGIN_DATE DATE)
1035: IS
1036: CURSOR C IS
1037: SELECT *
1038: FROM HZ_CUST_PROFILE_CLASSES
1039: WHERE rowid = X_Row_Id
1040: FOR UPDATE of Profile_Class_Id NOWAIT;
1041: Recinfo C%ROWTYPE;
1042: BEGIN

Line 1645: UPDATE HZ_CUST_PROFILE_CLASSES

1641: -- Class Id
1642: check_unique ( c_profile_class_name => x_customer_profile_class_id,
1643: c_rowid => x_row_id );
1644:
1645: UPDATE HZ_CUST_PROFILE_CLASSES
1646: SET
1647: profile_class_id = X_Customer_Profile_Class_Id,
1648: last_updated_by = X_Last_Updated_By,
1649: last_update_date = X_Last_Update_Date,

Line 1760: DELETE FROM HZ_CUST_PROFILE_CLASSES

1756:
1757:
1758: PROCEDURE Delete_Row(X_Row_Id VARCHAR2) IS
1759: BEGIN
1760: DELETE FROM HZ_CUST_PROFILE_CLASSES
1761: WHERE rowid = X_Row_Id;
1762:
1763: if (SQL%NOTFOUND) then
1764: Raise NO_DATA_FOUND;

Line 1779: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES

1775: IS
1776: number_in_update number;
1777: min_negative_id number;
1778: BEGIN
1779: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES
1780: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1781: SELECT count(*), min(profile_class_id) - 1
1782: INTO number_in_update, x_negative_id
1783: FROM hz_cust_profile_classes

Line 1783: FROM hz_cust_profile_classes

1779: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES
1780: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1781: SELECT count(*), min(profile_class_id) - 1
1782: INTO number_in_update, x_negative_id
1783: FROM hz_cust_profile_classes
1784: WHERE profile_class_id BETWEEN
1785: (X_Customer_Profile_Class_Id) * (-100) -99
1786: AND (X_Customer_Profile_Class_Id) * (-100) -2;
1787:

Line 1805: from hz_cust_profile_classes

1801: X_Negative_Id Number,
1802: X_Update_Options Varchar2) is
1803: cursor C is
1804: select *
1805: from hz_cust_profile_classes
1806: where profile_class_id = x_customer_profile_class_id
1807: FOR UPDATE of Profile_Class_Id NOWAIT;
1808: Classinfo C%ROWTYPE;
1809: dummy_rowid varchar2(20);