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 498: FROM hz_cust_profile_classes

494: X_CHARGE_BEGIN_DATE DATE DEFAULT NULL,
495: X_AUTOMATCH_SET_ID NUMBER DEFAULT NULL)
496: IS
497: CURSOR C IS SELECT rowid
498: FROM hz_cust_profile_classes
499: WHERE profile_class_id = X_Customer_Profile_Class_Id;
500:
501: BEGIN
502: IF X_CUSTOMER_PROFILE_CLASS_ID IS NULL THEN

Line 503: select hz_cust_profile_classes_s.nextval

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

Line 514: INSERT INTO HZ_CUST_PROFILE_CLASSES(

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

Line 1046: FROM HZ_CUST_PROFILE_CLASSES

1042: X_AUTOMATCH_SET_ID NUMBER)
1043: IS
1044: CURSOR C IS
1045: SELECT *
1046: FROM HZ_CUST_PROFILE_CLASSES
1047: WHERE rowid = X_Row_Id
1048: FOR UPDATE of Profile_Class_Id NOWAIT;
1049: Recinfo C%ROWTYPE;
1050: BEGIN

Line 1659: UPDATE HZ_CUST_PROFILE_CLASSES

1655: -- Class Id
1656: check_unique ( c_profile_class_name => x_customer_profile_class_id,
1657: c_rowid => x_row_id );
1658:
1659: UPDATE HZ_CUST_PROFILE_CLASSES
1660: SET
1661: profile_class_id = X_Customer_Profile_Class_Id,
1662: last_updated_by = X_Last_Updated_By,
1663: last_update_date = X_Last_Update_Date,

Line 1775: DELETE FROM HZ_CUST_PROFILE_CLASSES

1771:
1772:
1773: PROCEDURE Delete_Row(X_Row_Id VARCHAR2) IS
1774: BEGIN
1775: DELETE FROM HZ_CUST_PROFILE_CLASSES
1776: WHERE rowid = X_Row_Id;
1777:
1778: if (SQL%NOTFOUND) then
1779: Raise NO_DATA_FOUND;

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

1790: IS
1791: number_in_update number;
1792: min_negative_id number;
1793: BEGIN
1794: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES
1795: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1796: SELECT count(*), min(profile_class_id) - 1
1797: INTO number_in_update, x_negative_id
1798: FROM hz_cust_profile_classes

Line 1798: FROM hz_cust_profile_classes

1794: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROFILE_CLASSES
1795: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
1796: SELECT count(*), min(profile_class_id) - 1
1797: INTO number_in_update, x_negative_id
1798: FROM hz_cust_profile_classes
1799: WHERE profile_class_id BETWEEN
1800: (X_Customer_Profile_Class_Id) * (-100) -99
1801: AND (X_Customer_Profile_Class_Id) * (-100) -2;
1802:

Line 1820: from hz_cust_profile_classes

1816: X_Negative_Id Number,
1817: X_Update_Options Varchar2) is
1818: cursor C is
1819: select *
1820: from hz_cust_profile_classes
1821: where profile_class_id = x_customer_profile_class_id
1822: FOR UPDATE of Profile_Class_Id NOWAIT;
1823: Classinfo C%ROWTYPE;
1824: dummy_rowid varchar2(20);