DBA Data[Home] [Help]

APPS.OKL_REBOOK_CM_PVT dependencies on OKL_STREAMS

Line 83: OKL_STREAMS STM,

79: ------------------------------------------------------------
80: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
81: SELECT distinct KHR.ID
82: FROM OKC_K_HEADERS_B KHR,
83: OKL_STREAMS STM,
84: OKL_STRM_TYPE_B STY,
85: OKL_STRM_ELEMENTS SEL
86: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
87: AND KHR.STS_CODE = 'BOOKED'

Line 142: okl_streams stm,

138: ste.amount amount,
139: khr.sts_code sts_code
140: FROM
141: okl_strm_elements ste,
142: okl_streams stm,
143: okl_strm_type_b sty,
144: okc_k_headers_b khr,
145: okl_k_headers khl,
146: okc_k_lines_b kle,

Line 336: u_selv_rec Okl_Streams_Pub.selv_rec_type;

332: r_esdv_rec Okl_Xtd_Sell_Invs_Pub.esdv_rec_type;
333:
334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:

Line 337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;

333:
334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:
341: ------------------------------------------------------------

Line 338: r_selv_rec Okl_Streams_Pub.selv_rec_type;

334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:
341: ------------------------------------------------------------
342: -- Declare local variables used in the program

Line 1060: OKL_STREAMS STM,

1056: ------------------------------------------------------------
1057: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
1058: SELECT distinct KHR.ID
1059: FROM OKC_K_HEADERS_B KHR,
1060: OKL_STREAMS STM,
1061: OKL_STRM_TYPE_B STY,
1062: OKL_STRM_ELEMENTS SEL
1063: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
1064: AND KHR.STS_CODE = 'BOOKED'

Line 1121: okl_streams stm,

1117: ste.amount amount,
1118: khr.sts_code sts_code
1119: FROM
1120: okl_strm_elements ste,
1121: okl_streams stm,
1122: okl_strm_type_b sty,
1123: okc_k_headers_b khr,
1124: okl_k_headers khl,
1125: okc_k_lines_b kle,

Line 1906: u_selv_rec Okl_Streams_Pub.selv_rec_type;

1902: r_esdv_rec Okl_Xtd_Sell_Invs_Pub.esdv_rec_type;
1903:
1904:
1905: -- Stream elements
1906: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1907: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1908: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1909:
1910:

Line 1907: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;

1903:
1904:
1905: -- Stream elements
1906: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1907: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1908: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1909:
1910:
1911: ------------------------------------------------------------

Line 1908: r_selv_rec Okl_Streams_Pub.selv_rec_type;

1904:
1905: -- Stream elements
1906: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1907: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1908: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1909:
1910:
1911: ------------------------------------------------------------
1912: -- Declare local variables used in the program