DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKX_CUST_SITE_USES_V

Line 1166: x_bill_to_address_rec OUT NOCOPY okx_cust_site_uses_v%ROWTYPE,

1162:
1163: PROCEDURE get_bill_to_address (
1164: p_contract_id IN NUMBER,
1165: p_message_yn IN BOOLEAN,
1166: x_bill_to_address_rec OUT NOCOPY okx_cust_site_uses_v%ROWTYPE,
1167: x_return_status OUT NOCOPY VARCHAR2) IS
1168:
1169: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
1170: -- Get Bill to Values for LESSEE

Line 1189: FROM okx_cust_site_uses_v cst

1185: -- Removed cp_id2 from parameters and from WHERE
1186: -- Select bill_to record
1187: CURSOR l_bill_to_address_csr (cp_id1 NUMBER) IS
1188: SELECT *
1189: FROM okx_cust_site_uses_v cst
1190: WHERE cst.id1 = cp_id1;
1191: -- AND cst.id2 = cp_id2;
1192:
1193: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1195: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;

1191: -- AND cst.id2 = cp_id2;
1192:
1193: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1194: l_rulv_rec okl_rule_pub.rulv_rec_type;
1195: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1196:
1197: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
1198: l_bto_values_rec l_bto_values_csr%ROWTYPE;
1199: l_party_name VARCHAR2(320);