DBA Data[Home] [Help]

APPS.HZP_CPROF_PKG dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 274: prof_rec hz_customer_profile_v2pub.customer_profile_rec_type;

270: IS
271: -- suse_rec hz_customer_accounts_pub.acct_site_uses_rec_type;
272: -- prof_rec hz_customer_accounts_pub.cust_profile_rec_type;
273: suse_rec hz_cust_account_site_v2pub.cust_site_use_rec_type;
274: prof_rec hz_customer_profile_v2pub.customer_profile_rec_type;
275:
276: i_site_use_id NUMBER;
277: tmp_var VARCHAR2(2000);
278: i NUMBER;

Line 421: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

417: x_msg_data => x_msg_data
418: );
419: */
420: prof_rec.created_by_module := 'TCA_FORM_WRAPPER';
421: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
422: p_customer_profile_rec => prof_rec,
423: p_create_profile_amt => fnd_api.g_false,
424: x_cust_account_profile_id => l_cust_account_profile_id,
425: x_return_status => x_return_status,

Line 455: x_cust_prof_rec HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type;

451: IS
452: --
453: --
454: l_customer_profile_id number;
455: x_cust_prof_rec HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type;
456: --
457: CURSOR cu_class IS
458: SELECT *
459: FROM hz_cust_profile_classes

Line 552: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (

548: x_cust_prof_rec.last_credit_review_date := x_last_credit_review_date;
549: x_cust_prof_rec.party_id := x_party_id;
550: --}
551:
552: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
553: p_customer_profile_rec => x_cust_prof_rec,
554: x_cust_account_profile_id => l_customer_profile_id,
555: x_return_status => x_return_status,
556: x_msg_count => x_msg_count,

Line 686: l_cp_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

682: x_return_status VARCHAR2(10);
683: tmp_var VARCHAR2(2000);
684: i number;
685: tmp_var1 VARCHAR2(2000);
686: l_cp_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
687: Exc_g EXCEPTION;
688: BEGIN
689: l_object_version := x_object_version;
690:

Line 833: HZ_CUSTOMER_PROFILE_V2PUB.update_customer_profile (

829: l_cp_rec.next_credit_review_date := INIT_SWITCH( X_next_credit_review_date);
830: l_cp_rec.last_credit_review_date := INIT_SWITCH( X_last_credit_review_date);
831: --}
832:
833: HZ_CUSTOMER_PROFILE_V2PUB.update_customer_profile (
834: p_customer_profile_rec => l_cp_rec,
835: p_object_version_number => l_object_version,
836: x_return_status => x_return_status,
837: x_msg_count => x_msg_count,

Line 977: prof_amt_rec hz_customer_profile_v2pub.cust_profile_amt_rec_type;

973: ) is
974:
975: --
976: -- prof_amt_rec hz_customer_accounts_pub.cust_prof_amt_rec_type;
977: prof_amt_rec hz_customer_profile_v2pub.cust_profile_amt_rec_type;
978: x_cust_acct_profile_amt_id NUMBER;
979: old_customer_profile_id NUMBER; --Bug Fix#1: 3107081
980: tmp_var VARCHAR2(2000);
981: i NUMBER;

Line 1362: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (

1358: prof_amt_rec.jgzz_attribute15;
1359: EXIT WHEN c_prof_class_amts%NOTFOUND;
1360:
1361: prof_amt_rec.created_by_module := 'TCA_FORM_WRAPPER';
1362: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
1363: p_check_foreign_key => FND_API.G_FALSE,
1364: p_cust_profile_amt_rec => prof_amt_rec,
1365: x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id,
1366: x_return_status => x_return_status,

Line 1493: prof_amt_rec hz_customer_profile_v2pub.cust_profile_amt_rec_type;

1489: p_keep_replace IN VARCHAR2 DEFAULT 'KEEP'
1490: --}
1491: )
1492: IS
1493: prof_amt_rec hz_customer_profile_v2pub.cust_profile_amt_rec_type;
1494: x_cust_acct_profile_amt_id NUMBER;
1495: old_customer_profile_id NUMBER; --Bug Fix#4: 3107081
1496: tmp_var VARCHAR2(2000);
1497: i NUMBER;

Line 1889: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (

1885: prof_amt_rec.jgzz_attribute15;
1886: EXIT WHEN c_prof_class_amts%NOTFOUND;
1887:
1888: prof_amt_rec.created_by_module := 'TCA_FORM_WRAPPER';
1889: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
1890: p_check_foreign_key => FND_API.G_FALSE,
1891: p_cust_profile_amt_rec => prof_amt_rec,
1892: x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id,
1893: x_return_status => x_return_status,

Line 1940: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |

1936: | PROCEDURE : CREATE_PROFILE_AMOUNT |
1937: | |
1938: | PARAMETERS : |
1939: | Arguments in the record type |
1940: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
1941: | |
1942: | DESCRIPTION : |
1943: | From the arguments entered contruct the recors type and call |
1944: | Hz_Customer_Profile_V2pub.create_cust_profile_amt |

Line 1944: | Hz_Customer_Profile_V2pub.create_cust_profile_amt |

1940: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
1941: | |
1942: | DESCRIPTION : |
1943: | From the arguments entered contruct the recors type and call |
1944: | Hz_Customer_Profile_V2pub.create_cust_profile_amt |
1945: | |
1946: | HISTORY : |
1947: | 12-DEC-2002 H. Yu Created |
1948: +---------------------------------------------------------------*/

Line 2025: l_rec Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type;

2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2 )
2024: IS
2025: l_rec Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type;
2026: l_cust_acct_profile_amt_id NUMBER;
2027: tmp_var VARCHAR2(2000);
2028: i NUMBER;
2029: tmp_var1 VARCHAR2(2000);

Line 2106: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (

2102: l_rec.global_attribute_category := p_global_attribute_category;
2103: l_rec.created_by_module := p_created_by_module;
2104: l_rec.application_id := p_application_id;
2105:
2106: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
2107: p_cust_profile_amt_rec => l_rec,
2108: x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id,
2109: x_return_status => x_return_status,
2110: x_msg_count => x_msg_count,

Line 2143: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |

2139: | PROCEDURE : UPDATE_PROFILE_AMOUNT |
2140: | |
2141: | PARAMETERS : |
2142: | Arguments in the record type |
2143: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
2144: | |
2145: | DESCRIPTION : |
2146: | From the arguments entered contruct the recors type and call |
2147: | Hz_Customer_Profile_V2pub.update_cust_profile_amt |

Line 2147: | Hz_Customer_Profile_V2pub.update_cust_profile_amt |

2143: | Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type |
2144: | |
2145: | DESCRIPTION : |
2146: | From the arguments entered contruct the recors type and call |
2147: | Hz_Customer_Profile_V2pub.update_cust_profile_amt |
2148: | |
2149: | HISTORY : |
2150: | 12-DEC-2002 H. Yu Created |
2151: +---------------------------------------------------------------*/

Line 2235: l_rec Hz_Customer_Profile_V2pub.Cust_Profile_Amt_Rec_Type;

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;
2237: tmp_var VARCHAR2(2000);
2238: i NUMBER;
2239: tmp_var1 VARCHAR2(2000);

Line 2348: HZ_CUSTOMER_PROFILE_V2PUB.update_cust_profile_amt

2344: arp_standard.debug('x_return_status :'||x_return_status);
2345:
2346: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2347:
2348: HZ_CUSTOMER_PROFILE_V2PUB.update_cust_profile_amt
2349: ( p_cust_profile_amt_rec => l_rec,
2350: p_object_version_number => l_object_version,
2351: x_return_status => x_return_status,
2352: x_msg_count => x_msg_count,