APPS.OKL_INTERNAL_TO_EXTERNAL_PUB dependencies on OKL_EXT_SELL_INVS_V

Line 101: FROM okl_ext_sell_invs_v

97:
98:
99: CURSOR xsi_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
100: SELECT count(*)
101: FROM okl_ext_sell_invs_v
102: WHERE trx_status_code = p_sts AND
103: request_id = p_req_id ;
104:
105: CURSOR xsi_cnt_err_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS

Line 107: FROM okl_ext_sell_invs_v

103: request_id = p_req_id ;
104:
105: CURSOR xsi_cnt_err_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
106: SELECT count(*)
107: FROM okl_ext_sell_invs_v
108: WHERE trx_status_code = p_sts AND
109: request_id = p_req_id ;
110:
111: l_succ_cnt NUMBER;

Line 117: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;

113:
114: -- ------------------------------------------------
115: -- Bind variables to address issues in bug 3761940
116: -- ------------------------------------------------
117: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
118: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
119:
120: BEGIN
121:

Line 118: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;

114: -- ------------------------------------------------
115: -- Bind variables to address issues in bug 3761940
116: -- ------------------------------------------------
117: submitted_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
118: error_sts okl_ext_sell_invs_v.trx_status_code%TYPE;
119:
120: BEGIN
121:
122: internal_to_external(p_api_version => l_api_vesrions,