eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_IB_UTIL_PVT

Line 6765: oks_ib_util_pvt.check_renewed_sublines (l_source_line_id);

6761: SET date_renewed = p_txn_date
6762: WHERE ID = l_source_line_id;
6763:
6764: l_line_date_renewed :=
6765: oks_ib_util_pvt.check_renewed_sublines (l_source_line_id);
6766:
6767: UPDATE okc_k_lines_b
6768: SET date_renewed = l_line_date_renewed
6769: WHERE ID = (SELECT cle_id

Line 6775: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);

6771: WHERE ID = l_source_line_id)
6772: AND date_renewed IS NULL;
6773:
6774: l_hdr_date_renewed :=
6775: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);
6776:
6777: UPDATE okc_k_headers_all_b
6778: SET date_renewed = l_hdr_date_renewed
6779: WHERE ID = (SELECT dnz_chr_id

Line 8913: oks_ib_util_pvt.get_credit_option

8909: ELSIF p_kdtl_tbl (l_ctr).raise_credit IS NULL
8910: THEN
8911: -- Get the credit option from gcd
8912: l_credit_amount :=
8913: oks_ib_util_pvt.get_credit_option
8914: (p_party_id => p_kdtl_tbl
8915: (l_ctr).party_id,
8916: p_org_id => p_kdtl_tbl
8917: (l_ctr).hdr_org_id,

Line 8997: oks_ib_util_pvt.check_termcancel_lines

8993: END IF;
8994:
8995: l_inst_dtls_tbl (1).subline_date_terminated := TRUNC (l_retdt);
8996: -- If all the sublines are terminated terminate the top line
8997: oks_ib_util_pvt.check_termcancel_lines
8998: (p_kdtl_tbl (l_ctr).service_line_id,
8999: 'SL',
9000: 'T',
9001: date_terminated

Line 9036: oks_ib_util_pvt.check_termcancel_lines

9032: END IF;
9033:
9034: date_terminated := NULL;
9035: -- If all the toplines are terminated, terminate the header
9036: oks_ib_util_pvt.check_termcancel_lines
9037: (p_kdtl_tbl (l_ctr).hdr_id,
9038: 'TL',
9039: 'T',
9040: date_terminated

Line 9137: oks_ib_util_pvt.check_termcancel_lines

9133: END IF;
9134:
9135: l_inst_dtls_tbl (1).date_cancelled := TRUNC (l_retdt);
9136: date_cancelled := NULL;
9137: oks_ib_util_pvt.check_termcancel_lines
9138: (p_kdtl_tbl (l_ctr).service_line_id,
9139: 'SL',
9140: 'C',
9141: date_cancelled

Line 9187: oks_ib_util_pvt.check_termcancel_lines

9183: END IF;
9184: END IF;
9185:
9186: date_cancelled := NULL;
9187: oks_ib_util_pvt.check_termcancel_lines
9188: (p_kdtl_tbl (l_ctr).hdr_id,
9189: 'TL',
9190: 'C',
9191: date_cancelled

Line 11299: oks_ib_util_pvt.get_credit_option

11295: ELSE
11296: l_suppress_credit := 'Y';
11297: END IF;*/
11298: l_credit_amount :=
11299: oks_ib_util_pvt.get_credit_option
11300: (p_kdtl_tbl (l_ctr).party_id,
11301: p_kdtl_tbl (l_ctr).hdr_org_id,
11302: p_kdtl_tbl (l_ctr).transfer_date
11303: );

Line 11374: oks_ib_util_pvt.check_termcancel_lines

11370:
11371: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
11372: TRUNC (l_trfdt);
11373: date_terminated := NULL;
11374: oks_ib_util_pvt.check_termcancel_lines
11375: (p_kdtl_tbl (l_ctr).service_line_id,
11376: 'SL',
11377: 'T',
11378: date_terminated

Line 11425: oks_ib_util_pvt.check_termcancel_lines

11421: END IF;
11422: END IF;
11423:
11424: date_terminated := NULL;
11425: oks_ib_util_pvt.check_termcancel_lines
11426: (p_kdtl_tbl (l_ctr).hdr_id,
11427: 'TL',
11428: 'T',
11429: date_terminated

Line 11535: oks_ib_util_pvt.check_termcancel_lines

11531:
11532: l_inst_dtls_tbl (l_ptr).date_cancelled :=
11533: TRUNC (l_trfdt);
11534: date_cancelled := NULL;
11535: oks_ib_util_pvt.check_termcancel_lines
11536: (p_kdtl_tbl (l_ctr).service_line_id,
11537: 'SL',
11538: 'C',
11539: date_cancelled

Line 11587: oks_ib_util_pvt.check_termcancel_lines

11583: END IF;
11584: END IF;
11585:
11586: date_cancelled := NULL;
11587: oks_ib_util_pvt.check_termcancel_lines
11588: (p_kdtl_tbl (l_ctr).hdr_id,
11589: 'TL',
11590: 'C',
11591: date_cancelled

Line 11807: oks_ib_util_pvt.get_credit_option

11803: ELSE
11804: l_suppress_credit := 'Y';
11805: END IF;*/
11806: l_credit_amount :=
11807: oks_ib_util_pvt.get_credit_option
11808: (p_kdtl_tbl (l_ctr).party_id,
11809: p_kdtl_tbl (l_ctr).hdr_org_id,
11810: p_kdtl_tbl (l_ctr).transfer_date
11811: );

Line 11882: oks_ib_util_pvt.check_termcancel_lines

11878:
11879: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
11880: TRUNC (l_trfdt);
11881: date_terminated := NULL;
11882: oks_ib_util_pvt.check_termcancel_lines
11883: (p_kdtl_tbl (l_ctr).service_line_id,
11884: 'SL',
11885: 'T',
11886: date_terminated

Line 11935: oks_ib_util_pvt.check_termcancel_lines

11931: END IF;
11932: END IF;
11933:
11934: date_terminated := NULL;
11935: oks_ib_util_pvt.check_termcancel_lines
11936: (p_kdtl_tbl (l_ctr).hdr_id,
11937: 'TL',
11938: 'T',
11939: date_terminated

Line 12037: oks_ib_util_pvt.check_termcancel_lines

12033:
12034: l_inst_dtls_tbl (l_ptr).date_cancelled :=
12035: TRUNC (l_trfdt);
12036: date_cancelled := NULL;
12037: oks_ib_util_pvt.check_termcancel_lines
12038: (p_kdtl_tbl (l_ctr).service_line_id,
12039: 'SL',
12040: 'C',
12041: date_cancelled

Line 12089: oks_ib_util_pvt.check_termcancel_lines

12085: END IF;
12086: END IF;
12087:
12088: date_cancelled := NULL;
12089: oks_ib_util_pvt.check_termcancel_lines
12090: (p_kdtl_tbl (l_ctr).hdr_id,
12091: 'TL',
12092: 'C',
12093: date_cancelled

Line 14342: oks_ib_util_pvt.get_credit_option

14338: ELSE
14339: l_suppress_credit := 'Y';
14340: END IF;*/
14341: l_credit_amount :=
14342: oks_ib_util_pvt.get_credit_option
14343: (p_kdtl_tbl (l_ctr).party_id,
14344: p_kdtl_tbl (l_ctr).hdr_org_id,
14345: p_kdtl_tbl (l_ctr).termination_date
14346: );

Line 14411: oks_ib_util_pvt.check_termcancel_lines

14407: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
14408: TRUNC (l_trmdt);
14409: ---Terminate top line if all the sublines are terminated due to Instance termination
14410: date_terminated := NULL;
14411: oks_ib_util_pvt.check_termcancel_lines
14412: (p_kdtl_tbl (l_ctr).service_line_id,
14413: 'SL',
14414: 'T',
14415: date_terminated

Line 14461: oks_ib_util_pvt.check_termcancel_lines

14457: END IF;
14458: END IF;
14459:
14460: date_terminated := NULL;
14461: oks_ib_util_pvt.check_termcancel_lines
14462: (p_kdtl_tbl (l_ctr).hdr_id,
14463: 'TL',
14464: 'T',
14465: date_terminated

Line 14558: oks_ib_util_pvt.check_termcancel_lines

14554: END IF;
14555:
14556: l_inst_dtls_tbl (l_ptr).date_cancelled := TRUNC (l_trmdt);
14557: date_cancelled := NULL;
14558: oks_ib_util_pvt.check_termcancel_lines
14559: (p_kdtl_tbl (l_ctr).service_line_id,
14560: 'SL',
14561: 'C',
14562: date_cancelled

Line 14608: oks_ib_util_pvt.check_termcancel_lines

14604: END IF;
14605: END IF;
14606:
14607: date_cancelled := NULL;
14608: oks_ib_util_pvt.check_termcancel_lines
14609: (p_kdtl_tbl (l_ctr).hdr_id,
14610: 'TL',
14611: 'C',
14612: date_cancelled