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_BSD_PVT dependencies on OKS_BILL_SUBLINE_DTLS_V

Line 150: -- FUNCTION get_rec for: OKS_BILL_SUBLINE_DTLS_V

146: BEGIN
147: RETURN(get_rec(p_bsd_rec, l_row_notfound));
148: END get_rec;
149: ---------------------------------------------------------------------------
150: -- FUNCTION get_rec for: OKS_BILL_SUBLINE_DTLS_V
151: ---------------------------------------------------------------------------
152: FUNCTION get_rec (
153: p_bsdv_rec IN bsdv_rec_type,
154: x_no_data_found OUT NOCOPY BOOLEAN

Line 200: FROM Oks_Bill_Subline_Dtls_V

196: CREATION_DATE,
197: LAST_UPDATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATE_LOGIN
200: FROM Oks_Bill_Subline_Dtls_V
201: WHERE oks_bill_subline_dtls_v.id = p_id;
202: l_okc_bsdv_pk okc_bsdv_pk_csr%ROWTYPE;
203: l_bsdv_rec bsdv_rec_type;
204: BEGIN

Line 201: WHERE oks_bill_subline_dtls_v.id = p_id;

197: LAST_UPDATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATE_LOGIN
200: FROM Oks_Bill_Subline_Dtls_V
201: WHERE oks_bill_subline_dtls_v.id = p_id;
202: l_okc_bsdv_pk okc_bsdv_pk_csr%ROWTYPE;
203: l_bsdv_rec bsdv_rec_type;
204: BEGIN
205: x_no_data_found := TRUE;

Line 265: -- FUNCTION null_out_defaults for: OKS_BILL_SUBLINE_DTLS_V --

261: RETURN(get_rec(p_bsdv_rec, l_row_notfound));
262: END get_rec;
263:
264: -------------------------------------------------------------
265: -- FUNCTION null_out_defaults for: OKS_BILL_SUBLINE_DTLS_V --
266: -------------------------------------------------------------
267: FUNCTION null_out_defaults (
268: p_bsdv_rec IN bsdv_rec_type
269: ) RETURN bsdv_rec_type IS

Line 501: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

497: ---------giving prob so commented
498: /*
499: OKC_UTIL.CHECK_LENGTH
500: (
501: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
502: ,p_col_name => 'bsl_id_averaged'
503: ,p_col_value => p_bsl_id_averaged
504: ,x_return_status => l_return_status
505: );

Line 553: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

549: ---------giving prob so commented
550: /*
551: OKC_UTIL.CHECK_LENGTH
552: (
553: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
554: ,p_col_name => 'bsd_id'
555: ,p_col_value => p_bsd_id
556: ,x_return_status => l_return_status
557: );

Line 607: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

603: ---------giving prob so commented
604: /*
605: OKC_UTIL.CHECK_LENGTH
606: (
607: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
608: ,p_col_name => 'bsd_id_applied'
609: ,p_col_value => p_bsd_id_applied
610: ,x_return_status => l_return_status
611: );

Line 813: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

809:
810: /*
811: OKC_UTIL.CHECK_LENGTH
812: (
813: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
814: ,p_col_name => 'unit_of_measure'
815: ,p_col_value => P_unit_of_measure
816: ,x_return_status => l_return_status
817: );

Line 874: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

870:
871: /*
872: OKC_UTIL.CHECK_LENGTH
873: (
874: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
875: ,p_col_name => 'amcv_yn'
876: ,p_col_value => P_amcv_yn
877: ,x_return_status => l_return_status
878: );

Line 932: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

928: -- call column length utility
929: /*
930: OKC_UTIL.CHECK_LENGTH
931: (
932: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
933: ,p_col_name => 'Result'
934: ,p_col_value => P_result
935: ,x_return_status => l_return_status
936: );

Line 991: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

987: -- call column length utility
988: /*
989: OKC_UTIL.CHECK_LENGTH
990: (
991: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
992: ,p_col_name => 'Amount'
993: ,p_col_value => P_amount
994: ,x_return_status => l_return_status
995: );

Line 1076: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1072: -- call column length utility
1073: /*
1074: OKC_UTIL.CHECK_LENGTH
1075: (
1076: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1077: ,p_col_name => 'Fixed'
1078: ,p_col_value => P_fixed
1079: ,x_return_status => l_return_status
1080: );

Line 1127: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1123: -- call column length utility
1124: /*
1125: OKC_UTIL.CHECK_LENGTH
1126: (
1127: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1128: ,p_col_name => 'Actual'
1129: ,p_col_value => P_actual
1130: ,x_return_status => l_return_status
1131: );

Line 1178: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1174: -- call column length utility
1175: /*
1176: OKC_UTIL.CHECK_LENGTH
1177: (
1178: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1179: ,p_col_name => 'default_default'
1180: ,p_col_value => P_default_default
1181: ,x_return_status => l_return_status
1182: );

Line 1227: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1223: -- call column length utility
1224: /*
1225: OKC_UTIL.CHECK_LENGTH
1226: (
1227: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1228: ,p_col_name => 'adjustment_level'
1229: ,p_col_value => P_adjustment_level
1230: ,x_return_status => l_return_status
1231: );

Line 1277: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1273: -- call column length utility
1274: /*
1275: OKC_UTIL.CHECK_LENGTH
1276: (
1277: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1278: ,p_col_name => 'adjustment_minimum'
1279: ,p_col_value => P_adjustment_minimum
1280: ,x_return_status => l_return_status
1281: );

Line 1356: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1352: -- call column length utility
1353: /*
1354: OKC_UTIL.CHECK_LENGTH
1355: (
1356: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1357: ,p_col_name => 'attribute1'
1358: ,p_col_value => p_attribute1
1359: ,x_return_status => l_return_status
1360: );

Line 1406: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1402: -- call column length utility
1403: /*
1404: OKC_UTIL.CHECK_LENGTH
1405: (
1406: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1407: ,p_col_name => 'attribute2'
1408: ,p_col_value => p_attribute2
1409: ,x_return_status => l_return_status
1410: );

Line 1457: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1453: -- call column length utility
1454: /*
1455: OKC_UTIL.CHECK_LENGTH
1456: (
1457: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1458: ,p_col_name => 'attribute3'
1459: ,p_col_value => p_attribute3
1460: ,x_return_status => l_return_status
1461: );

Line 1507: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1503: -- call column length utility
1504: /*
1505: OKC_UTIL.CHECK_LENGTH
1506: (
1507: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1508: ,p_col_name => 'attribute4'
1509: ,p_col_value => p_attribute4
1510: ,x_return_status => l_return_status
1511: );

Line 1558: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1554: -- call column length utility
1555: /*
1556: OKC_UTIL.CHECK_LENGTH
1557: (
1558: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1559: ,p_col_name => 'attribute5'
1560: ,p_col_value => p_attribute5
1561: ,x_return_status => l_return_status
1562: );

Line 1609: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1605: -- call column length utility
1606: /*
1607: OKC_UTIL.CHECK_LENGTH
1608: (
1609: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1610: ,p_col_name => 'attribute6'
1611: ,p_col_value => p_attribute6
1612: ,x_return_status => l_return_status
1613: );

Line 1660: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1656: -- call column length utility
1657: /*
1658: OKC_UTIL.CHECK_LENGTH
1659: (
1660: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1661: ,p_col_name => 'attribute7'
1662: ,p_col_value => p_attribute7
1663: ,x_return_status => l_return_status
1664: );

Line 1712: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1708: -- call column length utility
1709: /*
1710: OKC_UTIL.CHECK_LENGTH
1711: (
1712: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1713: ,p_col_name => 'attribute8'
1714: ,p_col_value => p_attribute8
1715: ,x_return_status => l_return_status
1716: );

Line 1764: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1760: -- call column length utility
1761: /*
1762: OKC_UTIL.CHECK_LENGTH
1763: (
1764: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1765: ,p_col_name => 'attribute9'
1766: ,p_col_value => p_attribute9
1767: ,x_return_status => l_return_status
1768: );

Line 1815: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1811: -- call column length utility
1812: /*
1813: OKC_UTIL.CHECK_LENGTH
1814: (
1815: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1816: ,p_col_name => 'attribute10'
1817: ,p_col_value => p_attribute10
1818: ,x_return_status => l_return_status
1819: );

Line 1868: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1864:
1865: /*
1866: OKC_UTIL.CHECK_LENGTH
1867: (
1868: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1869: ,p_col_name => 'attribute11'
1870: ,p_col_value => p_attribute11
1871: ,x_return_status => l_return_status
1872: );

Line 1921: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1917: -- call column length utility
1918: /*
1919: OKC_UTIL.CHECK_LENGTH
1920: (
1921: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1922: ,p_col_name => 'attribute12'
1923: ,p_col_value => p_attribute12
1924: ,x_return_status => l_return_status
1925: );

Line 1974: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

1970: -- call column length utility
1971: /*
1972: OKC_UTIL.CHECK_LENGTH
1973: (
1974: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
1975: ,p_col_name => 'attribute13'
1976: ,p_col_value => p_attribute13
1977: ,x_return_status => l_return_status
1978: );

Line 2027: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

2023: -- call column length utility
2024: /*
2025: OKC_UTIL.CHECK_LENGTH
2026: (
2027: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
2028: ,p_col_name => 'attribute14'
2029: ,p_col_value => p_attribute14
2030: ,x_return_status => l_return_status
2031: );

Line 2078: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'

2074: -- call column length utility
2075: /*
2076: OKC_UTIL.CHECK_LENGTH
2077: (
2078: p_view_name => 'OKS_BILL_SUBLINE_DTLS_V'
2079: ,p_col_name => 'attribute15'
2080: ,p_col_value => p_attribute15
2081: ,x_return_status => l_return_status
2082: );

Line 2118: -- Validate_Attributes for:OKS_BILL_SUBLINE_DTLS_V --

2114: END validate_attribute15;
2115:
2116:
2117: /* -----------------------------------------------------
2118: -- Validate_Attributes for:OKS_BILL_SUBLINE_DTLS_V --
2119: -----------------------------------------------------
2120:
2121: FUNCTION Validate_Attributes (
2122: p_bsdv_rec IN bsdv_rec_type

Line 2179: OKC_UTIL.ADD_VIEW('OKS_BILL_SUBLINE_DTLS_V',x_return_status);

2175:
2176: Begin
2177: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
2178:
2179: OKC_UTIL.ADD_VIEW('OKS_BILL_SUBLINE_DTLS_V',x_return_status);
2180:
2181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2182: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2183: -- need to leave

Line 2813: -- Validate_Record for:OKS_BILL_SUBLINE_DTLS_V --

2809: ---------------------------------------------------------------------------
2810: -- PROCEDURE Validate_Record
2811: ---------------------------------------------------------------------------
2812: -------------------------------------------------
2813: -- Validate_Record for:OKS_BILL_SUBLINE_DTLS_V --
2814: -------------------------------------------------
2815: FUNCTION Validate_Record (
2816: p_bsdv_rec IN bsdv_rec_type
2817: ) RETURN VARCHAR2 IS

Line 2870: FROM Oks_Bill_Subline_Dtls_V

2866: CREATION_DATE,
2867: LAST_UPDATED_BY,
2868: LAST_UPDATE_DATE,
2869: LAST_UPDATE_LOGIN
2870: FROM Oks_Bill_Subline_Dtls_V
2871: WHERE oks_bill_subline_dtls_v.id = p_id;
2872: l_okc_bsdv_pk okc_bsdv_pk_csr%ROWTYPE;
2873: CURSOR okc_bslv_pk_csr (p_id IN NUMBER) IS
2874: SELECT

Line 2871: WHERE oks_bill_subline_dtls_v.id = p_id;

2867: LAST_UPDATED_BY,
2868: LAST_UPDATE_DATE,
2869: LAST_UPDATE_LOGIN
2870: FROM Oks_Bill_Subline_Dtls_V
2871: WHERE oks_bill_subline_dtls_v.id = p_id;
2872: l_okc_bsdv_pk okc_bsdv_pk_csr%ROWTYPE;
2873: CURSOR okc_bslv_pk_csr (p_id IN NUMBER) IS
2874: SELECT
2875: ID,

Line 3091: -- validate_row for:OKS_BILL_SUBLINE_DTLS_V --

3087: ---------------------------------------------------------------------------
3088: -- PROCEDURE validate_row
3089: ---------------------------------------------------------------------------
3090: ----------------------------------------------
3091: -- validate_row for:OKS_BILL_SUBLINE_DTLS_V --
3092: ----------------------------------------------
3093: PROCEDURE validate_row(
3094: p_api_version IN NUMBER,
3095: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3404: -- insert_row for:OKS_BILL_SUBLINE_DTLS_V --

3400: '_PVT'
3401: );
3402: END insert_row;
3403: --------------------------------------------
3404: -- insert_row for:OKS_BILL_SUBLINE_DTLS_V --
3405: --------------------------------------------
3406: PROCEDURE insert_row(
3407: p_api_version IN NUMBER,
3408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3438: -- Set_Attributes for:OKS_BILL_SUBLINE_DTLS_V --

3434: l_bsdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3435: RETURN(l_bsdv_rec);
3436: END fill_who_columns;
3437: ------------------------------------------------
3438: -- Set_Attributes for:OKS_BILL_SUBLINE_DTLS_V --
3439: ------------------------------------------------
3440: FUNCTION Set_Attributes (
3441: p_bsdv_rec IN bsdv_rec_type,
3442: x_bsdv_rec OUT NOCOPY bsdv_rec_type

Line 3724: -- lock_row for:OKS_BILL_SUBLINE_DTLS_V --

3720: '_PVT'
3721: );
3722: END lock_row;
3723: ------------------------------------------
3724: -- lock_row for:OKS_BILL_SUBLINE_DTLS_V --
3725: ------------------------------------------
3726: PROCEDURE lock_row(
3727: p_api_version IN NUMBER,
3728: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4192: -- update_row for:OKS_BILL_SUBLINE_DTLS_V --

4188: '_PVT'
4189: );
4190: END update_row;
4191: --------------------------------------------
4192: -- update_row for:OKS_BILL_SUBLINE_DTLS_V --
4193: --------------------------------------------
4194: PROCEDURE update_row(
4195: p_api_version IN NUMBER,
4196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4411: -- Set_Attributes for:OKS_BILL_SUBLINE_DTLS_V --

4407: END IF;
4408: RETURN(l_return_status);
4409: END populate_new_record;
4410: ------------------------------------------------
4411: -- Set_Attributes for:OKS_BILL_SUBLINE_DTLS_V --
4412: ------------------------------------------------
4413: FUNCTION Set_Attributes (
4414: p_bsdv_rec IN bsdv_rec_type,
4415: x_bsdv_rec OUT NOCOPY bsdv_rec_type

Line 4655: -- delete_row for:OKS_BILL_SUBLINE_DTLS_V --

4651: '_PVT'
4652: );
4653: END delete_row;
4654: --------------------------------------------
4655: -- delete_row for:OKS_BILL_SUBLINE_DTLS_V --
4656: --------------------------------------------
4657: PROCEDURE delete_row(
4658: p_api_version IN NUMBER,
4659: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,