APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on CSP_RS_CUST_RELATIONS

Line 31: -- in table csp_rs_cust_relations.

27: --------------------------------------------------------------------------------
28: --
29: -- Procedure Name : do_create_rs_cust_relation
30: -- Purpose : Create a relationship between a resource and a customer
31: -- in table csp_rs_cust_relations.
32: --
33: PROCEDURE do_rs_cust_relations
34: (p_resource_type IN VARCHAR2
35: ,p_resource_id IN NUMBER

Line 38: l_rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE := NULL;

34: (p_resource_type IN VARCHAR2
35: ,p_resource_id IN NUMBER
36: ,p_customer_id IN NUMBER) IS
37:
38: l_rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE := NULL;
39: l_resource_type csp_rs_cust_relations.resource_type%TYPE;
40: l_resource_id csp_rs_cust_relations.resource_id%TYPE;
41: l_customer_id csp_rs_cust_relations.customer_id%TYPE;
42: l_CREATED_BY number;

Line 39: l_resource_type csp_rs_cust_relations.resource_type%TYPE;

35: ,p_resource_id IN NUMBER
36: ,p_customer_id IN NUMBER) IS
37:
38: l_rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE := NULL;
39: l_resource_type csp_rs_cust_relations.resource_type%TYPE;
40: l_resource_id csp_rs_cust_relations.resource_id%TYPE;
41: l_customer_id csp_rs_cust_relations.customer_id%TYPE;
42: l_CREATED_BY number;
43: l_CREATION_DATE date;

Line 40: l_resource_id csp_rs_cust_relations.resource_id%TYPE;

36: ,p_customer_id IN NUMBER) IS
37:
38: l_rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE := NULL;
39: l_resource_type csp_rs_cust_relations.resource_type%TYPE;
40: l_resource_id csp_rs_cust_relations.resource_id%TYPE;
41: l_customer_id csp_rs_cust_relations.customer_id%TYPE;
42: l_CREATED_BY number;
43: l_CREATION_DATE date;
44: l_ATTRIBUTE_CATEGORY varchar2(30);

Line 41: l_customer_id csp_rs_cust_relations.customer_id%TYPE;

37:
38: l_rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE := NULL;
39: l_resource_type csp_rs_cust_relations.resource_type%TYPE;
40: l_resource_id csp_rs_cust_relations.resource_id%TYPE;
41: l_customer_id csp_rs_cust_relations.customer_id%TYPE;
42: l_CREATED_BY number;
43: l_CREATION_DATE date;
44: l_ATTRIBUTE_CATEGORY varchar2(30);
45: l_ATTRIBUTE1 varchar2(150);

Line 82: from csp_rs_cust_relations

78: attribute12,
79: attribute13,
80: attribute14,
81: attribute15
82: from csp_rs_cust_relations
83: where resource_type = p_resource_type and resource_id = p_resource_id;
84:
85: BEGIN
86: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;

Line 111: csp_rs_cust_relations_pkg.update_row(

107: l_attribute15;
108: IF l_rs_relation_csr%FOUND THEN
109: CLOSE l_rs_relation_csr;
110: IF l_customer_id IS NULL THEN
111: csp_rs_cust_relations_pkg.update_row(
112: p_RS_CUST_RELATION_ID => l_rs_cust_relation_id,
113: p_RESOURCE_TYPE => p_resource_type,
114: p_RESOURCE_ID => p_resource_id,
115: p_CUSTOMER_ID => p_customer_id,

Line 140: csp_rs_cust_relations_pkg.insert_row(

136: p_ATTRIBUTE15 => l_attribute15);
137: END IF;
138: ELSE
139: CLOSE l_rs_relation_csr;
140: csp_rs_cust_relations_pkg.insert_row(
141: px_RS_CUST_RELATION_ID => l_rs_cust_relation_id,
142: p_RESOURCE_TYPE => p_resource_type,
143: p_RESOURCE_ID => p_resource_id,
144: p_CUSTOMER_ID => p_customer_id,

Line 2516: from csp_rs_cust_relations

2512:
2513: CURSOR l_customer_id_csr IS
2514: select rs_cust_relation_id,
2515: customer_id
2516: from csp_rs_cust_relations
2517: where resource_type = l_resource_type
2518: and resource_id = l_resource_id;
2519:
2520: CURSOR l_party_id_csr IS

Line 2806: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS

2802: open c_party_id;
2803: fetch c_party_id into l_party_id;
2804: close c_party_id;
2805:
2806: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS
2807: -- If found, no need to create new customer account for this resource
2808: OPEN l_customer_id_csr;
2809: FETCH l_customer_id_csr INTO l_rs_cust_relation_id,l_customer_id;
2810: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;

Line 3211: -- Create/update resource customer relationship in csp_rs_cust_relations.

3207: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3208: FND_MSG_PUB.ADD;*/
3209: RAISE EXCP_USER_DEFINED;
3210: ELSE
3211: -- Create/update resource customer relationship in csp_rs_cust_relations.
3212: do_rs_cust_relations(l_resource_type, l_resource_id, l_customer_id);
3213: END IF;
3214: END IF;
3215:

Line 3708: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations

3704: -- Return location_id and customer_id.
3705: p_location_id := l_inv_location_id;
3706: p_customer_id := l_customer_id;
3707:
3708: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
3709: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
3710: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
3711: IF l_process_type = 'INSERT' THEN
3712: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);