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 774: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',

770: END IF;
771:
772: -- Debug info.
773: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
774: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
775: p_prefix=>l_debug_prefix,
776: p_msg_level=>fnd_log.level_procedure);
777: END IF;
778:

Line 780: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

776: p_msg_level=>fnd_log.level_procedure);
777: END IF;
778:
779: -- Call table-handler.
780: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
781: X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
782: X_PROFILE_CLASS_ID => l_profile_class_id,
783: X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
784: X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,

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

861: );
862:
863: -- Debug info.
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
866: p_prefix=>l_debug_prefix,
867: p_msg_level=>fnd_log.level_procedure);
868: END IF;
869:

Line 932: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row

928: *
929: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
930: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
931: * HZ_CUSTOMER_PROFILES_PKG.Update_Row
932: * HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
933: *
934: * ARGUMENTS
935: * IN/OUT:
936: * p_customer_profile_rec Customer profile record. One customer account

Line 985: FROM HZ_CUST_PROF_CLASS_AMTS

981: l_credit_hold VARCHAR2(30); -- Bug 4115750
982:
983: CURSOR c_profile_class_amts IS
984: SELECT PROFILE_CLASS_AMOUNT_ID
985: FROM HZ_CUST_PROF_CLASS_AMTS
986: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
987:
988: v_action VARCHAR2(10);
989: v_entity_code VARCHAR2(1);

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

1454: END IF;
1455:
1456: -- Debug info.
1457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
1459: p_prefix=>l_debug_prefix,
1460: p_msg_level=>fnd_log.level_procedure);
1461: END IF;
1462:

Line 1464: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

1460: p_msg_level=>fnd_log.level_procedure);
1461: END IF;
1462:
1463: -- Call table-handler
1464: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
1465: X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
1466: X_PROFILE_CLASS_ID => l_profile_class_id,
1467: X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
1468: X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,

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

1545: );
1546:
1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;
1553: