[Home] [Help]
395: px_cust_profile_rec.profile_class_id :=p_cust_profile_obj.profile_class_id;
396: px_cust_profile_rec.site_use_id :=p_site_use_id;
397: px_cust_profile_rec.credit_rating :=p_cust_profile_obj.credit_rating;
398: px_cust_profile_rec.risk_code :=p_cust_profile_obj.risk_code;
399: px_cust_profile_rec.standard_terms :=p_cust_profile_obj.standard_terms;
400: px_cust_profile_rec.override_terms :=p_cust_profile_obj.override_terms;
401: px_cust_profile_rec.dunning_letter_set_id :=p_cust_profile_obj.dunning_letter_set_id;
402: px_cust_profile_rec.interest_period_days :=p_cust_profile_obj.interest_period_days;
403: px_cust_profile_rec.payment_grace_days :=p_cust_profile_obj.payment_grace_days;
588: ) IS
589: l_debug_prefix VARCHAR2(30) := '';
590: l_cp_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
591: BEGIN
592: -- Standard start of API savepoint
593: SAVEPOINT create_cp_pvt;
594:
595: -- initialize API return status to success.
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
776: SELECT cp.cust_account_profile_id, cp.object_version_number, cp.cust_account_id, cp.site_use_id
777: FROM HZ_CUSTOMER_PROFILES cp
778: WHERE cp.cust_account_profile_id = l_cp_id;
779: BEGIN
780: -- Standard start of API savepoint
781: SAVEPOINT update_cp_pvt;
782:
783: -- initialize API return status to success.
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
977: l_debug_prefix VARCHAR2(30) := '';
978: l_cpa_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
979: l_cpa_id NUMBER;
980: BEGIN
981: -- Standard start of API savepoint
982: SAVEPOINT create_cpa_pvt;
983:
984: -- initialize API return status to success.
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: l_cpa_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
1157: l_cpa_id NUMBER;
1158: l_cpa_ovn NUMBER;
1159: BEGIN
1160: -- Standard start of API savepoint
1161: SAVEPOINT save_cpa_pvt;
1162:
1163: -- initialize API return status to success.
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: l_rca_id NUMBER;
1370: l_rca_os VARCHAR2(30);
1371: l_rca_osr VARCHAR2(255);
1372: BEGIN
1373: -- Standard start of API savepoint
1374: SAVEPOINT create_car_pvt;
1375:
1376: -- initialize API return status to success.
1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1567: l_rca_os VARCHAR2(30);
1568: l_rca_osr VARCHAR2(255);
1569: l_ovn NUMBER;
1570: BEGIN
1571: -- Standard start of API savepoint
1572: SAVEPOINT save_car_pvt;
1573:
1574: -- initialize API return status to success.
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1787: l_pmtinstrument_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_Rec_Type;
1788: l_assign_id NUMBER;
1789: l_response IBY_FNDCPT_COMMON_PUB.Result_Rec_Type;
1790: BEGIN
1791: -- Standard start of API savepoint
1792: SAVEPOINT save_bau_pvt;
1793:
1794: -- initialize API return status to success.
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1966: l_debug_prefix VARCHAR2(30) := '';
1967: l_payment_method_rec HZ_PAYMENT_METHOD_PUB.PAYMENT_METHOD_REC_TYPE;
1968: l_pm_id NUMBER;
1969: BEGIN
1970: -- Standard start of API savepoint
1971: SAVEPOINT create_pm_pvt;
1972:
1973: -- initialize API return status to success.
1974: x_return_status := FND_API.G_RET_STS_SUCCESS;
2138: l_payment_method_rec HZ_PAYMENT_METHOD_PUB.PAYMENT_METHOD_REC_TYPE;
2139: l_lud DATE;
2140: l_pm_id NUMBER;
2141: BEGIN
2142: -- Standard start of API savepoint
2143: SAVEPOINT save_pm_pvt;
2144:
2145: -- initialize API return status to success.
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2533: x_msg_data OUT NOCOPY VARCHAR2
2534: ) IS
2535: l_debug_prefix VARCHAR2(30) := '';
2536: BEGIN
2537: -- Standard start of API savepoint
2538: SAVEPOINT create_pms_v2_pvt;
2539:
2540: -- initialize API return status to success.
2541: x_return_status := FND_API.G_RET_STS_SUCCESS;
2671: x_msg_data OUT NOCOPY VARCHAR2
2672: ) IS
2673: l_debug_prefix VARCHAR2(30) := '';
2674: BEGIN
2675: -- Standard start of API savepoint
2676: SAVEPOINT save_pm_v2_pvt;
2677:
2678: -- initialize API return status to success.
2679: x_return_status := FND_API.G_RET_STS_SUCCESS;