DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on OZF_SD_CUSTOMER_PKG

Line 3185: OZF_SD_CUSTOMER_PKG.Insert_Row(

3181: OPEN c_reqest_cust_seq;
3182: FETCH c_reqest_cust_seq INTO l_request_cust_seq;
3183: CLOSE c_reqest_cust_seq;
3184:
3185: OZF_SD_CUSTOMER_PKG.Insert_Row(
3186: p_request_customer_id =>l_request_cust_seq
3187: ,p_request_header_id =>p_request_header_id
3188: ,p_cust_account_id =>p_SDR_cust_tbl(c).cust_account_id
3189: ,p_party_id =>p_SDR_cust_tbl(c).party_id

Line 3220: OZF_SD_CUSTOMER_PKG.Delete_Row(

3216: ,p_cust_usage_value =>p_SDR_cust_tbl(c).cust_usage_value);
3217: ELSE --ninarasi fix for bug 12656359
3218:
3219: IF p_SDR_cust_tbl(c).operation = 'DELETE' THEN
3220: OZF_SD_CUSTOMER_PKG.Delete_Row(
3221: p_request_customer_id =>p_SDR_cust_tbl(c).request_customer_id
3222: ,p_request_header_id =>p_request_header_id);
3223:
3224: ELSE

Line 3225: OZF_SD_CUSTOMER_PKG.Update_Row(

3221: p_request_customer_id =>p_SDR_cust_tbl(c).request_customer_id
3222: ,p_request_header_id =>p_request_header_id);
3223:
3224: ELSE
3225: OZF_SD_CUSTOMER_PKG.Update_Row(
3226: p_request_customer_id =>p_SDR_cust_tbl(c).request_customer_id
3227: ,p_request_header_id =>p_request_header_id
3228: ,p_cust_account_id =>p_SDR_cust_tbl(c).cust_account_id
3229: ,p_party_id =>p_SDR_cust_tbl(c).party_id