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.OE_CUSTOMER_INFO_PVT dependencies on OE_ORDER_PUB

Line 93: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE,

89: */
90:
91: Procedure get_customer_info_ids
92: (
93: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE,
94: p_operation_code IN VARCHAR2,
95: p_sold_to_customer_ref IN VARCHAR2,
96: p_ship_to_customer_ref IN VARCHAR2,
97: p_bill_to_customer_ref IN VARCHAR2,

Line 165: l_sold_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

161: l_bill_cont_found boolean := FALSE;
162: l_deliver_cont_found boolean := FALSE;
163:
164:
165: l_sold_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
166: l_ship_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
167: l_bill_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
168: l_deliver_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
169:

Line 166: l_ship_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

162: l_deliver_cont_found boolean := FALSE;
163:
164:
165: l_sold_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
166: l_ship_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
167: l_bill_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
168: l_deliver_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
169:
170: l_sold_to_cust_index NUMBER;

Line 167: l_bill_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

163:
164:
165: l_sold_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
166: l_ship_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
167: l_bill_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
168: l_deliver_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
169:
170: l_sold_to_cust_index NUMBER;
171: l_ship_to_cust_index NUMBER;

Line 168: l_deliver_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

164:
165: l_sold_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
166: l_ship_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
167: l_bill_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
168: l_deliver_to_customer_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
169:
170: l_sold_to_cust_index NUMBER;
171: l_ship_to_cust_index NUMBER;
172: l_bill_to_cust_index NUMBER;

Line 1459: Procedure Create_account (p_header_customer_info_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

1455: /* This procedure will call the wraper procedure oe_oe_inline_address.create_account which
1456: inturn calls TCA apis to create a customer account. Email and phone contact points for the party will
1457: also be created if passed*/
1458:
1459: Procedure Create_account (p_header_customer_info_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
1460: x_party_id OUT NOCOPY NUMBER,
1461: x_cust_account_id OUT NOCOPY NUMBER,
1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,

Line 1466: l_customer_info_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2
1465: ) IS
1466: l_customer_info_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
1467: l_party_id NUMBER := NULL;
1468: l_party_type VARCHAR2(100) := NULL;
1469: l_organization_name VARCHAR2(360) ;
1470: l_customer_first_name varchar2(100);

Line 1837: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

1833: /* This procedure will create a party site for the passed party_id and the location details*/
1834:
1835: Procedure Create_Party_Site
1836: ( p_party_id IN NUMBER,
1837: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
1838: x_location_id OUT NOCOPY NUMBER,
1839: x_party_site_id OUT NOCOPY NUMBER,
1840: x_return_status OUT NOCOPY VARCHAR2,
1841: x_msg_count OUT NOCOPY NUMBER,

Line 2000: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

1996:
1997: Procedure Create_Cust_Account_Site
1998: ( p_party_site_id IN NUMBER,
1999: p_cust_account_id IN NUMBER,
2000: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
2001: x_cust_account_site_id OUT NOCOPY NUMBER,
2002: x_return_status OUT NOCOPY VARCHAR2,
2003: x_msg_count OUT NOCOPY NUMBER,
2004: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 2169: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

2165: /* This procuedre will get all the party sites for the passed party and check whether the site being created
2166: is already there .If found it returns the existing party_site_id */
2167:
2168: Procedure Check_Party_Site_Exists( p_party_id IN NUMBER,
2169: p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,
2170: x_party_site_id OUT NOCOPY NUMBER
2171: ) IS
2172: CURSOR party_location
2173: IS

Line 2340: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE

2336:
2337:
2338: /* This procedure is called from Get_Customer_Info_ids to create customer sites and different usages */
2339: Procedure Create_Addresses (
2340: p_customer_info_tbl IN OUT NOCOPY OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE
2341: , p_operation_code IN VARCHAR2
2342: , p_sold_to_customer_id IN NUMBER
2343: , p_ship_to_customer_id IN NUMBER
2344: , p_bill_to_customer_id IN NUMBER

Line 2359: l_addr_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

2355: , x_msg_data OUT NOCOPY VARCHAR2
2356: ) IS
2357:
2358:
2359: l_addr_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
2360:
2361: l_ship_addr_rec_index NUMBER;
2362: l_bill_addr_rec_index NUMBER;
2363: l_deliver_addr_rec_index NUMBER;

Line 2684: Procedure Check_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2680:
2681: END Create_Addresses;
2682:
2683:
2684: Procedure Check_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2685: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
2686: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2687: BEGIN
2688:

Line 2790: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2786: WHEN OTHERS THEN
2787: NULL;
2788: END Check_Customer_Fields;
2789:
2790: Procedure Validate_Customer_Fields (p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2791: ,x_return_status OUT NOCOPY VARCHAR2 )IS
2792: x_party_id NUMBER;
2793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2794:

Line 2811: Procedure Check_Duplicate_Customer ( p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2807: NULL;
2808: END Validate_Customer_Fields;
2809:
2810:
2811: Procedure Check_Duplicate_Customer ( p_customer_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2812: , p_type IN VARCHAR2
2813: , x_customer_id OUT NOCOPY VARCHAR2
2814: ) IS
2815: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2867: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2863:
2864:
2865:
2866:
2867: Procedure Check_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2868: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
2869: BEGIN
2870: NULL;
2871: EXCEPTION

Line 2877: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2873: NULL;
2874: END Check_Address_Fields;
2875:
2876:
2877: Procedure Validate_Address_Fields (p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2878: ,x_return_status OUT NOCOPY VARCHAR2 )IS
2879: BEGIN
2880:
2881: NULL;

Line 2888: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2884: NULL;
2885: END Validate_Address_Fields;
2886:
2887:
2888: Procedure Check_Duplicate_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2889: , p_sold_to_org_id IN NUMBER
2890: , p_site_customer_id IN NUMBER
2891: , p_site_usage IN VARCHAR2
2892: , x_site_usage_id OUT NOCOPY NUMBER

Line 2979: Procedure Value_To_Id_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

2975: WHEN OTHERS THEN
2976: x_site_usage_id := FND_API.G_MISS_NUM;
2977: END Check_Duplicate_Address;
2978:
2979: Procedure Value_To_Id_Address ( p_address_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
2980: , p_sold_to_org_id IN NUMBER
2981: , p_site_customer_id IN NUMBER
2982: , p_site_usage IN VARCHAR2
2983: , x_site_usage_id OUT NOCOPY NUMBER

Line 3054: Procedure Check_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3050: WHEN OTHERS THEN
3051: x_site_usage_id := FND_API.G_MISS_NUM;
3052: END Value_To_Id_Address;
3053:
3054: Procedure Check_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3055: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
3056: BEGIN
3057:
3058: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3078: Procedure Validate_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3074: NULL;
3075: END Check_Contact_Fields;
3076:
3077:
3078: Procedure Validate_Contact_Fields (p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3079: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
3080: BEGIN
3081:
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3121: Procedure Update_Location ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3117: /* This procedure is used to update a address location.This will be called from create_address procedure if
3118: bot ID and Value are passed for address related fields and OE_GLOBALS.G_UPDATE_ON_ID is TRUE
3119: */
3120:
3121: Procedure Update_Location ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3122: , p_site_use_id IN NUMBER
3123: , p_site_usage_code IN VARCHAR2
3124: , x_return_status OUT NOCOPY VARCHAR2
3125: , x_msg_count OUT NOCOPY NUMBER

Line 3259: Procedure Update_Customer ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3255: /* This procedure will be called from Create_Account procedure if both ID and Value is passed
3256: for customer fields and OE_GLOBALS.G_UPDATE_ON_ID is TRUE. This API can update Customer_name,
3257: Account_Description,Account_number,Email contact point,Phone contact point*/
3258:
3259: Procedure Update_Customer ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3260: , x_return_status OUT NOCOPY VARCHAR2 ) IS
3261: x_version_number NUMBER;
3262: l_cust_acct_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;
3263: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 3421: Procedure Create_Contact ( p_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE

3417: END Update_Customer;
3418:
3419: /* This procedure is called from Get_Customer_Info_Ids procedure to create contacts */
3420:
3421: Procedure Create_Contact ( p_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE
3422: , p_operation_code IN VARCHAR2
3423: , p_customer_id IN NUMBER
3424: , p_customer_rec_index IN NUMBER
3425: , p_usage_code IN VARCHAR2

Line 3435: l_contact_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;

3431: , x_msg_count OUT NOCOPY NUMBER
3432: , x_msg_data OUT NOCOPY VARCHAR2
3433: ) IS
3434: l_contact_rec_index NUMBER;
3435: l_contact_rec OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE;
3436: x_contact_id NUMBER;
3437: out_cont_name VARCHAR2(1000);
3438: x_sold_to_cont_index NUMBER;
3439: x_ship_to_cont_index NUMBER;

Line 3653: Function IS_BOTH_ID_VAL_PASSED ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

3649: END Create_Contact;
3650:
3651:
3652:
3653: Function IS_BOTH_ID_VAL_PASSED ( p_customer_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
3654: RETURN BOOLEAN
3655: IS
3656: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3657: BEGIN

Line 3679: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

3675: RETURN FALSE;
3676: END IS_BOTH_ID_VAL_PASSED;
3677:
3678:
3679: Function IS_BOTH_ID_VAL_PASSED ( p_address_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
3680: RETURN BOOLEAN
3681: IS
3682: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3683: BEGIN

Line 3709: Function IS_BOTH_ID_VAL_PASSED ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)

3705: END IS_BOTH_ID_VAL_PASSED;
3706:
3707:
3708:
3709: Function IS_BOTH_ID_VAL_PASSED ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE)
3710: RETURN BOOLEAN
3711: IS
3712: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3713: BEGIN

Line 3792: Procedure Value_To_Id_contact( p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3788: END IS_VALID_ID;
3789:
3790:
3791:
3792: Procedure Value_To_Id_contact( p_contact_record IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3793: , p_customer_id IN NUMBER
3794: , p_site_usage_code IN VARCHAR2
3795: , p_site_usage_id OUT NOCOPY NUMBER
3796: , x_contact_id OUT NOCOPY NUMBER

Line 3870: PROCEDURE Update_Contact ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE

3866:
3867: /* Updates the contact information like person name,title,email,phone .Called from create_contact procedure
3868: if both ID and value are passed in contact record and OE_GLOBALS.G_UPDATE_ON_ID is TRUE*/
3869:
3870: PROCEDURE Update_Contact ( p_contact_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE
3871: , x_return_status OUT NOCOPY VARCHAR2
3872: , x_msg_count OUT NOCOPY NUMBER
3873: , x_msg_data OUT NOCOPY VARCHAR2
3874: )