APPS.OKL_REBOOK_CM_PVT dependencies on OKL_STRM_ELEMENTS

Line 85: OKL_STRM_ELEMENTS SEL

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'
88: AND KHR.ID = STM.KHR_ID
89: AND STM.sty_id = STY.id

Line 141: okl_strm_elements ste,

137: sty.taxable_default_yn taxable_default_yn,
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,

Line 400: l_ste_amount okl_strm_elements.amount%type;

396: l_max_commit_cnt NUMBER := 500;
397:
398:
399: -- For currecy precision rounded amount
400: l_ste_amount okl_strm_elements.amount%type;
401: l_curr_code okc_k_headers_b.currency_code%TYPE;
402: ------------------------------------------------------------
403: -- For errors in Stream Elements Table
404: ------------------------------------------------------------

Line 426: amount okl_strm_elements.amount%type,

422: xsi_id NUMBER,
423: bill_date DATE,
424: contract_number okc_k_headers_b.contract_number%type,
425: stream_purpose okl_strm_type_v.stream_type_purpose%type,
426: amount okl_strm_elements.amount%type,
427: error_message Varchar2(2000)
428: );
429:
430:

Line 684: UPDATE okl_strm_elements

680: END LOOP;
681:
682:
683: ELSE
684: UPDATE okl_strm_elements
685: SET date_billed = SYSDATE
686: WHERE id = adj_streams_rec.sel_id;
687: END IF;
688: END IF;

Line 881: -- UPDATE okl_strm_elements

877: END IF; -- More Credit remaining than needed
878:
879:
880: --IF (x_return_status = 'S' ) THEN
881: -- UPDATE okl_strm_elements
882: -- SET date_billed = SYSDATE
883: -- WHERE id = adj_streams_rec.sel_id;
884: --END IF;
885: IF (x_return_status <> 'S' ) THEN

Line 908: UPDATE okl_strm_elements

904: SET trx_status_code = 'ERROR'
905: WHERE id = err_tbl(i).tai_id;
906: END LOOP;
907: ELSE
908: UPDATE okl_strm_elements
909: SET date_billed = SYSDATE
910: WHERE id = adj_streams_rec.sel_id;
911: END IF;
912:

Line 941: UPDATE okl_strm_elements

937: SET trx_status_code = 'ERROR'
938: WHERE id = err_tbl(i).tai_id;
939: END LOOP;
940: ELSE
941: UPDATE okl_strm_elements
942: SET date_billed = SYSDATE
943: WHERE id = adj_streams_rec.sel_id;
944: END IF;
945: END IF;

Line 1053: OKL_STRM_ELEMENTS SEL

1049: SELECT distinct KHR.ID
1050: FROM OKC_K_HEADERS_B KHR,
1051: OKL_STREAMS STM,
1052: OKL_STRM_TYPE_B STY,
1053: OKL_STRM_ELEMENTS SEL
1054: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
1055: AND KHR.STS_CODE = 'BOOKED'
1056: AND KHR.ID = STM.KHR_ID
1057: AND STM.sty_id = STY.id

Line 1111: okl_strm_elements ste,

1107: sty.taxable_default_yn taxable_default_yn,
1108: ste.amount amount,
1109: khr.sts_code sts_code
1110: FROM
1111: okl_strm_elements ste,
1112: okl_streams stm,
1113: okl_strm_type_b sty,
1114: okc_k_headers_b khr,
1115: okl_k_headers khl,

Line 1343: UPDATE okl_strm_elements

1339: SET trx_status_code = 'ERROR'
1340: WHERE id = lx_taiv_rec.id;
1341: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1342: ELSE
1343: UPDATE okl_strm_elements
1344: SET date_billed = SYSDATE
1345: WHERE id = adj_streams_rec.sel_id;
1346: END IF;
1347:

Line 1445: UPDATE okl_strm_elements

1441: SET trx_status_code = 'ERROR'
1442: WHERE id = lx_taiv_rec.id;
1443: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1444: ELSE
1445: UPDATE okl_strm_elements
1446: SET date_billed = SYSDATE
1447: WHERE id = adj_streams_rec.sel_id;
1448: END IF;
1449:

Line 1957: l_ste_amount okl_strm_elements.amount%type;

1953: l_max_commit_cnt NUMBER := 500;
1954:
1955:
1956: -- For currecy precision rounded amount
1957: l_ste_amount okl_strm_elements.amount%type;
1958: l_curr_code okc_k_headers_b.currency_code%TYPE;
1959: ------------------------------------------------------------
1960: -- For errors in Stream Elements Table
1961: ------------------------------------------------------------

Line 1985: amount okl_strm_elements.amount%type,

1981: xsi_id NUMBER,
1982: bill_date DATE,
1983: contract_number okc_k_headers_b.contract_number%type,
1984: stream_name okl_strm_type_v.name%type,
1985: amount okl_strm_elements.amount%type,
1986: error_message Varchar2(2000)
1987: );
1988:
1989:

Line 2413: -- UPDATE okl_strm_elements

2409: END IF; -- More Credit remaining than needed
2410:
2411:
2412: --IF (x_return_status = 'S' ) THEN
2413: -- UPDATE okl_strm_elements
2414: -- SET date_billed = SYSDATE
2415: -- WHERE id = adj_streams_rec.sel_id;
2416: --END IF;
2417: IF (x_return_status <> 'S' ) THEN