APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 262: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row

258: *
259: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
260: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
261: * HZ_CUSTOMER_PROFILES_PKG.Insert_Row
262: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
263: *
264: * ARGUMENTS
265: * IN:
266: * p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer

Line 323: FROM HZ_CUST_PROF_CLASS_AMTS

319: l_default_profile_class_id NUMBER :=0;
320:
321: CURSOR c_profile_class_amts IS
322: SELECT PROFILE_CLASS_AMOUNT_ID
323: FROM HZ_CUST_PROF_CLASS_AMTS
324: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
325:
326: cursor c_acct_use_profile_dtls IS
327: select cons_bill_level, cons_inv_type

Line 805: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',

801: END IF;
802:
803: -- Debug info.
804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
806: p_prefix=>l_debug_prefix,
807: p_msg_level=>fnd_log.level_procedure);
808: END IF;
809:

Line 811: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

807: p_msg_level=>fnd_log.level_procedure);
808: END IF;
809:
810: -- Call table-handler.
811: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
812: X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
813: X_PROFILE_CLASS_ID => l_profile_class_id,
814: X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
815: X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,

Line 896: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',

892: );
893:
894: -- Debug info.
895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
896: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
897: p_prefix=>l_debug_prefix,
898: p_msg_level=>fnd_log.level_procedure);
899: END IF;
900:

Line 963: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row

959: *
960: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
961: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
962: * HZ_CUSTOMER_PROFILES_PKG.Update_Row
963: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
964: *
965: * ARGUMENTS
966: * IN/OUT:
967: * p_customer_profile_rec Customer profile record. One customer account

Line 1016: FROM HZ_CUST_PROF_CLASS_AMTS

1012: l_credit_hold VARCHAR2(30); -- Bug 4115750
1013:
1014: CURSOR c_profile_class_amts IS
1015: SELECT PROFILE_CLASS_AMOUNT_ID
1016: FROM HZ_CUST_PROF_CLASS_AMTS
1017: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
1018:
1019: v_action VARCHAR2(10);
1020: v_entity_code VARCHAR2(1);

Line 1521: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',

1517: END IF;
1518:
1519: -- Debug info.
1520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1521: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
1522: p_prefix=>l_debug_prefix,
1523: p_msg_level=>fnd_log.level_procedure);
1524: END IF;
1525:

Line 1527: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

1523: p_msg_level=>fnd_log.level_procedure);
1524: END IF;
1525:
1526: -- Call table-handler
1527: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
1528: X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
1529: X_PROFILE_CLASS_ID => l_profile_class_id,
1530: X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
1531: X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,

Line 1612: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',

1608: );
1609:
1610: -- Debug info.
1611: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1612: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
1613: p_prefix=>l_debug_prefix,
1614: p_msg_level=>fnd_log.level_procedure);
1615: END IF;
1616: