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 3024: from csp_rs_cust_relations

3020:
3021: CURSOR l_customer_id_csr IS
3022: select rs_cust_relation_id,
3023: customer_id
3024: from csp_rs_cust_relations
3025: where resource_type = l_resource_type
3026: and resource_id = l_resource_id;
3027:
3028: CURSOR l_party_id_csr IS

Line 3361: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS

3357: end if;
3358: close c_check_hz_party_rule;
3359: end if;
3360:
3361: -- Retrieve customer_id from CSP_RS_CUST_RELATIONS
3362: -- If found, no need to create new customer account for this resource
3363: OPEN l_customer_id_csr;
3364: FETCH l_customer_id_csr INTO l_rs_cust_relation_id,l_customer_id;
3365: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;

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

3762: FND_MESSAGE.SET_TOKEN ('TEXT', x_msg_data);
3763: FND_MSG_PUB.ADD;*/
3764: RAISE EXCP_USER_DEFINED;
3765: ELSE
3766: -- Create/update resource customer relationship in csp_rs_cust_relations.
3767: do_rs_cust_relations(l_resource_type, l_resource_id, l_customer_id);
3768: END IF;
3769: END IF;
3770:

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

4286: -- Return location_id and customer_id.
4287: p_location_id := l_inv_location_id;
4288: p_customer_id := l_customer_id;
4289:
4290: -- -- Create or update resource/customer relationship record in csp_rs_cust_relations
4291: -- do_rs_cust_relations(l_resource_type, l_resource_id, l_resource_name, l_customer_id);
4292: csp_ship_to_address_pvt.g_inv_loc_id := l_inv_location_id;
4293: IF l_process_type = 'INSERT' THEN
4294: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','A',x_return_status);