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 6597: oks_ib_util_pvt.check_renewed_sublines (l_source_line_id);

6593: SET date_renewed = p_txn_date
6594: WHERE ID = l_source_line_id;
6595:
6596: l_line_date_renewed :=
6597: oks_ib_util_pvt.check_renewed_sublines (l_source_line_id);
6598:
6599: UPDATE okc_k_lines_b
6600: SET date_renewed = l_line_date_renewed
6601: WHERE ID = (SELECT cle_id

Line 6607: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);

6603: WHERE ID = l_source_line_id)
6604: AND date_renewed IS NULL;
6605:
6606: l_hdr_date_renewed :=
6607: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);
6608:
6609: UPDATE okc_k_headers_all_b
6610: SET date_renewed = l_hdr_date_renewed
6611: WHERE ID = (SELECT dnz_chr_id

Line 8682: oks_ib_util_pvt.get_credit_option

8678: ELSIF p_kdtl_tbl (l_ctr).raise_credit IS NULL
8679: THEN
8680: -- Get the credit option from gcd
8681: l_credit_amount :=
8682: oks_ib_util_pvt.get_credit_option
8683: (p_party_id => p_kdtl_tbl
8684: (l_ctr).party_id,
8685: p_org_id => p_kdtl_tbl
8686: (l_ctr).hdr_org_id,

Line 8766: oks_ib_util_pvt.check_termcancel_lines

8762: END IF;
8763:
8764: l_inst_dtls_tbl (1).subline_date_terminated := TRUNC (l_retdt);
8765: -- If all the sublines are terminated terminate the top line
8766: oks_ib_util_pvt.check_termcancel_lines
8767: (p_kdtl_tbl (l_ctr).service_line_id,
8768: 'SL',
8769: 'T',
8770: date_terminated

Line 8805: oks_ib_util_pvt.check_termcancel_lines

8801: END IF;
8802:
8803: date_terminated := NULL;
8804: -- If all the toplines are terminated, terminate the header
8805: oks_ib_util_pvt.check_termcancel_lines
8806: (p_kdtl_tbl (l_ctr).hdr_id,
8807: 'TL',
8808: 'T',
8809: date_terminated

Line 8906: oks_ib_util_pvt.check_termcancel_lines

8902: END IF;
8903:
8904: l_inst_dtls_tbl (1).date_cancelled := TRUNC (l_retdt);
8905: date_cancelled := NULL;
8906: oks_ib_util_pvt.check_termcancel_lines
8907: (p_kdtl_tbl (l_ctr).service_line_id,
8908: 'SL',
8909: 'C',
8910: date_cancelled

Line 8956: oks_ib_util_pvt.check_termcancel_lines

8952: END IF;
8953: END IF;
8954:
8955: date_cancelled := NULL;
8956: oks_ib_util_pvt.check_termcancel_lines
8957: (p_kdtl_tbl (l_ctr).hdr_id,
8958: 'TL',
8959: 'C',
8960: date_cancelled

Line 11051: oks_ib_util_pvt.get_credit_option

11047: ELSE
11048: l_suppress_credit := 'Y';
11049: END IF;*/
11050: l_credit_amount :=
11051: oks_ib_util_pvt.get_credit_option
11052: (p_kdtl_tbl (l_ctr).party_id,
11053: p_kdtl_tbl (l_ctr).hdr_org_id,
11054: p_kdtl_tbl (l_ctr).transfer_date
11055: );

Line 11126: oks_ib_util_pvt.check_termcancel_lines

11122:
11123: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
11124: TRUNC (l_trfdt);
11125: date_terminated := NULL;
11126: oks_ib_util_pvt.check_termcancel_lines
11127: (p_kdtl_tbl (l_ctr).service_line_id,
11128: 'SL',
11129: 'T',
11130: date_terminated

Line 11177: oks_ib_util_pvt.check_termcancel_lines

11173: END IF;
11174: END IF;
11175:
11176: date_terminated := NULL;
11177: oks_ib_util_pvt.check_termcancel_lines
11178: (p_kdtl_tbl (l_ctr).hdr_id,
11179: 'TL',
11180: 'T',
11181: date_terminated

Line 11287: oks_ib_util_pvt.check_termcancel_lines

11283:
11284: l_inst_dtls_tbl (l_ptr).date_cancelled :=
11285: TRUNC (l_trfdt);
11286: date_cancelled := NULL;
11287: oks_ib_util_pvt.check_termcancel_lines
11288: (p_kdtl_tbl (l_ctr).service_line_id,
11289: 'SL',
11290: 'C',
11291: date_cancelled

Line 11339: oks_ib_util_pvt.check_termcancel_lines

11335: END IF;
11336: END IF;
11337:
11338: date_cancelled := NULL;
11339: oks_ib_util_pvt.check_termcancel_lines
11340: (p_kdtl_tbl (l_ctr).hdr_id,
11341: 'TL',
11342: 'C',
11343: date_cancelled

Line 11559: oks_ib_util_pvt.get_credit_option

11555: ELSE
11556: l_suppress_credit := 'Y';
11557: END IF;*/
11558: l_credit_amount :=
11559: oks_ib_util_pvt.get_credit_option
11560: (p_kdtl_tbl (l_ctr).party_id,
11561: p_kdtl_tbl (l_ctr).hdr_org_id,
11562: p_kdtl_tbl (l_ctr).transfer_date
11563: );

Line 11634: oks_ib_util_pvt.check_termcancel_lines

11630:
11631: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
11632: TRUNC (l_trfdt);
11633: date_terminated := NULL;
11634: oks_ib_util_pvt.check_termcancel_lines
11635: (p_kdtl_tbl (l_ctr).service_line_id,
11636: 'SL',
11637: 'T',
11638: date_terminated

Line 11687: oks_ib_util_pvt.check_termcancel_lines

11683: END IF;
11684: END IF;
11685:
11686: date_terminated := NULL;
11687: oks_ib_util_pvt.check_termcancel_lines
11688: (p_kdtl_tbl (l_ctr).hdr_id,
11689: 'TL',
11690: 'T',
11691: date_terminated

Line 11789: oks_ib_util_pvt.check_termcancel_lines

11785:
11786: l_inst_dtls_tbl (l_ptr).date_cancelled :=
11787: TRUNC (l_trfdt);
11788: date_cancelled := NULL;
11789: oks_ib_util_pvt.check_termcancel_lines
11790: (p_kdtl_tbl (l_ctr).service_line_id,
11791: 'SL',
11792: 'C',
11793: date_cancelled

Line 11841: oks_ib_util_pvt.check_termcancel_lines

11837: END IF;
11838: END IF;
11839:
11840: date_cancelled := NULL;
11841: oks_ib_util_pvt.check_termcancel_lines
11842: (p_kdtl_tbl (l_ctr).hdr_id,
11843: 'TL',
11844: 'C',
11845: date_cancelled

Line 14057: oks_ib_util_pvt.get_credit_option

14053: ELSE
14054: l_suppress_credit := 'Y';
14055: END IF;*/
14056: l_credit_amount :=
14057: oks_ib_util_pvt.get_credit_option
14058: (p_kdtl_tbl (l_ctr).party_id,
14059: p_kdtl_tbl (l_ctr).hdr_org_id,
14060: p_kdtl_tbl (l_ctr).termination_date
14061: );

Line 14126: oks_ib_util_pvt.check_termcancel_lines

14122: l_inst_dtls_tbl (l_ptr).subline_date_terminated :=
14123: TRUNC (l_trmdt);
14124: ---Terminate top line if all the sublines are terminated due to Instance termination
14125: date_terminated := NULL;
14126: oks_ib_util_pvt.check_termcancel_lines
14127: (p_kdtl_tbl (l_ctr).service_line_id,
14128: 'SL',
14129: 'T',
14130: date_terminated

Line 14176: oks_ib_util_pvt.check_termcancel_lines

14172: END IF;
14173: END IF;
14174:
14175: date_terminated := NULL;
14176: oks_ib_util_pvt.check_termcancel_lines
14177: (p_kdtl_tbl (l_ctr).hdr_id,
14178: 'TL',
14179: 'T',
14180: date_terminated

Line 14273: oks_ib_util_pvt.check_termcancel_lines

14269: END IF;
14270:
14271: l_inst_dtls_tbl (l_ptr).date_cancelled := TRUNC (l_trmdt);
14272: date_cancelled := NULL;
14273: oks_ib_util_pvt.check_termcancel_lines
14274: (p_kdtl_tbl (l_ctr).service_line_id,
14275: 'SL',
14276: 'C',
14277: date_cancelled

Line 14323: oks_ib_util_pvt.check_termcancel_lines

14319: END IF;
14320: END IF;
14321:
14322: date_cancelled := NULL;
14323: oks_ib_util_pvt.check_termcancel_lines
14324: (p_kdtl_tbl (l_ctr).hdr_id,
14325: 'TL',
14326: 'C',
14327: date_cancelled