APPS.OZF_SD_CUSTOMER_PKG dependencies on OZF_SD_CUSTOMER_DETAILS

Line 41: INSERT INTO OZF_SD_CUSTOMER_DETAILS(

37: p_end_customer_flag VARCHAR2,
38: p_cust_usage_value VARCHAR2)
39: IS
40: BEGIN
41: INSERT INTO OZF_SD_CUSTOMER_DETAILS(
42: request_customer_id,
43: request_header_id,
44: cust_account_id,
45: party_id,

Line 142: UPDATE OZF_SD_CUSTOMER_DETAILS

138: p_cust_usage_value VARCHAR2)
139: IS
140: BEGIN
141:
142: UPDATE OZF_SD_CUSTOMER_DETAILS
143: SET request_header_id = p_request_header_id,
144: cust_account_id = p_cust_account_id,
145: party_id = p_party_id,
146: site_use_id = p_site_use_id,

Line 186: DELETE FROM OZF_SD_CUSTOMER_DETAILS

182: IS
183: BEGIN
184: --AMITAMKU, fix for Bug-13981597
185: /*
186: DELETE FROM OZF_SD_CUSTOMER_DETAILS
187: WHERE request_customer_id=p_request_customer_id AND request_header_id = p_request_header_id;
188: */
189: UPDATE OZF_SD_CUSTOMER_DETAILS
190: SET operation_flag = 'D'

Line 189: UPDATE OZF_SD_CUSTOMER_DETAILS

185: /*
186: DELETE FROM OZF_SD_CUSTOMER_DETAILS
187: WHERE request_customer_id=p_request_customer_id AND request_header_id = p_request_header_id;
188: */
189: UPDATE OZF_SD_CUSTOMER_DETAILS
190: SET operation_flag = 'D'
191: WHERE request_customer_id=p_request_customer_id
192: AND request_header_id = p_request_header_id;
193: --AMITAMKU, End of fix for Bug-13981597