eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZP_CPROF_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 1055: hz_cust_profile_amts_s.nextval,

1051:
1052:
1053: CURSOR c_prof_class_amts IS
1054: SELECT
1055: hz_cust_profile_amts_s.nextval,
1056: x_customer_profile_id,
1057: currency_code,
1058: trx_credit_limit,
1059: overall_credit_limit,

Line 1210: -- can insert rows into hz_cust_profile_amts.

1206: CLOSE c_prof_class;
1207: --
1208: -- If the customer_profile_id/customers_id is null we need to
1209: -- generate one so we
1210: -- can insert rows into hz_cust_profile_amts.
1211: -- Customer_id wil be null when inserting a profile .
1212: -- and not null if they are updating an existing profile.
1213: --
1214: --

Line 1242: FROM HZ_CUST_PROFILE_AMTS

1238: BEGIN
1239: IF x_site_use_id IS NOT NULL THEN
1240: SELECT DISTINCT cust_account_profile_id
1241: INTO old_customer_profile_id
1242: FROM HZ_CUST_PROFILE_AMTS
1243: WHERE cust_account_id = x_customer_id
1244: AND site_use_id = x_site_use_id;
1245: END IF;
1246: EXCEPTION

Line 1257: DELETE FROM hz_cust_profile_amts

1253: * Use old_customer_profile_id for Site Level Profile
1254: * Use x_customer_profile_id for Account Level Profile ****/
1255:
1256: IF p_keep_replace = 'REPLACE' THEN
1257: DELETE FROM hz_cust_profile_amts
1258: WHERE cust_account_profile_id =
1259: NVL(old_customer_profile_id,x_customer_profile_id);
1260: ELSE
1261: DELETE FROM hz_cust_profile_amts

Line 1261: DELETE FROM hz_cust_profile_amts

1257: DELETE FROM hz_cust_profile_amts
1258: WHERE cust_account_profile_id =
1259: NVL(old_customer_profile_id,x_customer_profile_id);
1260: ELSE
1261: DELETE FROM hz_cust_profile_amts
1262: WHERE cust_account_profile_id =
1263: NVL(old_customer_profile_id,x_customer_profile_id)
1264: AND currency_code in ( select currency_code
1265: from hz_cust_prof_class_amts

Line 1293: DELETE FROM hz_cust_profile_amts

1289:
1290: /********** Commented out the following piece of code *******/
1291: /********** Bug Fix Begin#3 : 3107081 *************************
1292: IF p_keep_replace = 'REPLACE' THEN
1293: DELETE FROM hz_cust_profile_amts
1294: WHERE cust_account_profile_id = x_customer_profile_id;
1295:
1296: ELSE
1297: DELETE FROM hz_cust_profile_amts

Line 1297: DELETE FROM hz_cust_profile_amts

1293: DELETE FROM hz_cust_profile_amts
1294: WHERE cust_account_profile_id = x_customer_profile_id;
1295:
1296: ELSE
1297: DELETE FROM hz_cust_profile_amts
1298: WHERE cust_account_profile_id = x_customer_profile_id
1299: AND currency_code in ( select currency_code
1300: from hz_cust_prof_class_amts
1301: where profile_class_id = x_customer_profile_class_id

Line 1579: hz_cust_profile_amts_s.nextval,

1575:
1576:
1577: CURSOR c_prof_class_amts IS
1578: SELECT
1579: hz_cust_profile_amts_s.nextval,
1580: x_customer_profile_id,
1581: currency_code,
1582: trx_credit_limit,
1583: overall_credit_limit,

Line 1737: -- can insert rows into hz_cust_profile_amts.

1733: CLOSE c_prof_class;
1734: --
1735: -- If the customer_profile_id/customers_id is null we need to
1736: -- generate one so we
1737: -- can insert rows into hz_cust_profile_amts.
1738: -- Customer_id wil be null when inserting a profile .
1739: -- and not null if they are updating an existing profile.
1740: --
1741: --

Line 1771: FROM HZ_CUST_PROFILE_AMTS

1767: BEGIN
1768: IF x_site_use_id IS NOT NULL THEN
1769: SELECT DISTINCT cust_account_profile_id
1770: INTO old_customer_profile_id
1771: FROM HZ_CUST_PROFILE_AMTS
1772: WHERE cust_account_id = x_customer_id
1773: AND site_use_id = x_site_use_id;
1774: END IF;
1775: EXCEPTION

Line 1785: DELETE FROM hz_cust_profile_amts

1781: * Use old_customer_profile_id for Site Level Profile
1782: * Use x_customer_profile_id for Account Level Profile ****/
1783:
1784: IF p_keep_replace = 'REPLACE' THEN
1785: DELETE FROM hz_cust_profile_amts
1786: WHERE cust_account_profile_id =
1787: NVL(old_customer_profile_id,x_customer_profile_id);
1788: ELSE
1789: DELETE FROM hz_cust_profile_amts

Line 1789: DELETE FROM hz_cust_profile_amts

1785: DELETE FROM hz_cust_profile_amts
1786: WHERE cust_account_profile_id =
1787: NVL(old_customer_profile_id,x_customer_profile_id);
1788: ELSE
1789: DELETE FROM hz_cust_profile_amts
1790: WHERE cust_account_profile_id =
1791: NVL(old_customer_profile_id,x_customer_profile_id)
1792: AND currency_code in ( select currency_code
1793: from hz_cust_prof_class_amts

Line 1819: DELETE FROM hz_cust_profile_amts

1815:
1816: /********** Commented out the following piece of code *******/
1817: /********** Bug Fix Begin#6 : 3107081 *************************
1818: IF p_keep_replace = 'REPLACE' THEN
1819: DELETE FROM hz_cust_profile_amts
1820: WHERE cust_account_profile_id = x_customer_profile_id;
1821:
1822: ELSE
1823: DELETE FROM hz_cust_profile_amts

Line 1823: DELETE FROM hz_cust_profile_amts

1819: DELETE FROM hz_cust_profile_amts
1820: WHERE cust_account_profile_id = x_customer_profile_id;
1821:
1822: ELSE
1823: DELETE FROM hz_cust_profile_amts
1824: WHERE cust_account_profile_id = x_customer_profile_id
1825: AND currency_code in ( select currency_code
1826: from hz_cust_prof_class_amts
1827: where profile_class_id = x_customer_profile_class_id

Line 2232: FROM hz_cust_profile_amts

2228: CURSOR cu_version_prof_amt IS
2229: SELECT ROWID,
2230: OBJECT_VERSION_NUMBER,
2231: LAST_UPDATE_DATE
2232: FROM hz_cust_profile_amts
2233: WHERE cust_acct_profile_amt_id = p_cust_acct_profile_amt_id;
2234:
2235: l_rec Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type;
2236: l_cust_acct_profile_amt_id NUMBER;

Line 2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');

2330: arp_standard.debug('Last_update_date:'||to_char(l_last_update_date));
2331:
2332: IF cu_version_prof_amt%NOTFOUND THEN
2333: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');
2335: FND_MESSAGE.SET_TOKEN('ID',p_cust_acct_profile_amt_id);
2336: FND_MSG_PUB.ADD;
2337: RAISE l_exception;
2338: END IF;

Line 2408: | Delete a record from Hz_Cust_Profile_Amts |

2404: | PARAMETERS : |
2405: | NUMBER Customer_profile_amt_id |
2406: | |
2407: | DESCRIPTION : |
2408: | Delete a record from Hz_Cust_Profile_Amts |
2409: | |
2410: | HISTORY : |
2411: | 12-DEC-2002 H. Yu Created |
2412: +---------------------------------------------------------------*/

Line 2424: DELETE FROM hz_cust_profile_amts

2420: arp_standard.debug('delete_profile_amount(+)');
2421:
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423:
2424: DELETE FROM hz_cust_profile_amts
2425: WHERE cust_acct_profile_amt_id = p_cust_acct_profile_amt_id;
2426:
2427: IF (SQL%NOTFOUND) THEN
2428: Raise NO_DATA_FOUND;