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_BSL_PVT dependencies on OKS_BILL_SUB_LINES_V

Line 128: -- FUNCTION get_rec for: OKS_BILL_SUB_LINES_V

124: BEGIN
125: RETURN(get_rec(p_bsl_rec, l_row_notfound));
126: END get_rec;
127: ---------------------------------------------------------------------------
128: -- FUNCTION get_rec for: OKS_BILL_SUB_LINES_V
129: ---------------------------------------------------------------------------
130: FUNCTION get_rec (
131: p_bslv_rec IN bslv_rec_type,
132: x_no_data_found OUT NOCOPY BOOLEAN

Line 167: FROM Oks_Bill_Sub_Lines_V

163: CREATION_DATE,
164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Oks_Bill_Sub_Lines_V
168: WHERE oks_bill_sub_lines_v.id = p_id;
169: l_oks_bslv_pk oks_bslv_pk_csr%ROWTYPE;
170: l_bslv_rec bslv_rec_type;
171: BEGIN

Line 168: WHERE oks_bill_sub_lines_v.id = p_id;

164: LAST_UPDATED_BY,
165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: FROM Oks_Bill_Sub_Lines_V
168: WHERE oks_bill_sub_lines_v.id = p_id;
169: l_oks_bslv_pk oks_bslv_pk_csr%ROWTYPE;
170: l_bslv_rec bslv_rec_type;
171: BEGIN
172: x_no_data_found := TRUE;

Line 221: -- FUNCTION null_out_defaults for: OKS_BILL_SUB_LINES_V --

217: RETURN(get_rec(p_bslv_rec, l_row_notfound));
218: END get_rec;
219:
220: ----------------------------------------------------------
221: -- FUNCTION null_out_defaults for: OKS_BILL_SUB_LINES_V --
222: ----------------------------------------------------------
223: FUNCTION null_out_defaults (
224: p_bslv_rec IN bslv_rec_type
225: ) RETURN bslv_rec_type IS

Line 480: p_view_name => 'OKS_BILL_SUB_LINES_V'

476: -- call column length utility
477: /*
478: OKC_UTIL.CHECK_LENGTH
479: (
480: p_view_name => 'OKS_BILL_SUB_LINES_V'
481: ,p_col_name => 'Average'
482: ,p_col_value => P_average
483: ,x_return_status => l_return_status
484: );

Line 531: p_view_name => 'OKS_BILL_SUB_LINES_V'

527: -- call column length utility
528: /*
529: OKC_UTIL.CHECK_LENGTH
530: (
531: p_view_name => 'OKS_BILL_SUB_LINES_V'
532: ,p_col_name => 'Amount'
533: ,p_col_value => P_amount
534: ,x_return_status => l_return_status
535: );

Line 694: p_view_name => 'OKS_BILL_SUB_LINES_V'

690: -- call column length utility
691: /*
692: OKC_UTIL.CHECK_LENGTH
693: (
694: p_view_name => 'OKS_BILL_SUB_LINES_V'
695: ,p_col_name => 'attribute1'
696: ,p_col_value => p_attribute1
697: ,x_return_status => l_return_status
698: );

Line 743: p_view_name => 'OKS_BILL_SUB_LINES_V'

739:
740: -- call column length utility
741: /*OKC_UTIL.CHECK_LENGTH
742: (
743: p_view_name => 'OKS_BILL_SUB_LINES_V'
744: ,p_col_name => 'attribute2'
745: ,p_col_value => p_attribute2
746: ,x_return_status => l_return_status
747: );

Line 793: p_view_name => 'OKS_BILL_SUB_LINES_V'

789: -- call column length utility
790: /*
791: OKC_UTIL.CHECK_LENGTH
792: (
793: p_view_name => 'OKS_BILL_SUB_LINES_V'
794: ,p_col_name => 'attribute3'
795: ,p_col_value => p_attribute3
796: ,x_return_status => l_return_status
797: );

Line 843: p_view_name => 'OKS_BILL_SUB_LINES_V'

839: -- call column length utility
840: /*
841: OKC_UTIL.CHECK_LENGTH
842: (
843: p_view_name => 'OKS_BILL_SUB_LINES_V'
844: ,p_col_name => 'attribute4'
845: ,p_col_value => p_attribute4
846: ,x_return_status => l_return_status
847: );

Line 894: p_view_name => 'OKS_BILL_SUB_LINES_V'

890: -- call column length utility
891: /*
892: OKC_UTIL.CHECK_LENGTH
893: (
894: p_view_name => 'OKS_BILL_SUB_LINES_V'
895: ,p_col_name => 'attribute5'
896: ,p_col_value => p_attribute5
897: ,x_return_status => l_return_status
898: );

Line 945: p_view_name => 'OKS_BILL_SUB_LINES_V'

941: -- call column length utility
942: /*
943: OKC_UTIL.CHECK_LENGTH
944: (
945: p_view_name => 'OKS_BILL_SUB_LINES_V'
946: ,p_col_name => 'attribute6'
947: ,p_col_value => p_attribute6
948: ,x_return_status => l_return_status
949: );

Line 996: p_view_name => 'OKS_BILL_SUB_LINES_V'

992: -- call column length utility
993: /*
994: OKC_UTIL.CHECK_LENGTH
995: (
996: p_view_name => 'OKS_BILL_SUB_LINES_V'
997: ,p_col_name => 'attribute7'
998: ,p_col_value => p_attribute7
999: ,x_return_status => l_return_status
1000: );

Line 1048: p_view_name => 'OKS_BILL_SUB_LINES_V'

1044: -- call column length utility
1045: /*
1046: OKC_UTIL.CHECK_LENGTH
1047: (
1048: p_view_name => 'OKS_BILL_SUB_LINES_V'
1049: ,p_col_name => 'attribute8'
1050: ,p_col_value => p_attribute8
1051: ,x_return_status => l_return_status
1052: );

Line 1100: p_view_name => 'OKS_BILL_SUB_LINES_V'

1096: -- call column length utility
1097: /*
1098: OKC_UTIL.CHECK_LENGTH
1099: (
1100: p_view_name => 'OKS_BILL_SUB_LINES_V'
1101: ,p_col_name => 'attribute9'
1102: ,p_col_value => p_attribute9
1103: ,x_return_status => l_return_status
1104: );

Line 1151: p_view_name => 'OKS_BILL_SUB_LINES_V'

1147: -- call column length utility
1148: /*
1149: OKC_UTIL.CHECK_LENGTH
1150: (
1151: p_view_name => 'OKS_BILL_SUB_LINES_V'
1152: ,p_col_name => 'attribute10'
1153: ,p_col_value => p_attribute10
1154: ,x_return_status => l_return_status
1155: );

Line 1204: p_view_name => 'OKS_BILL_SUB_LINES_V'

1200:
1201: /*
1202: OKC_UTIL.CHECK_LENGTH
1203: (
1204: p_view_name => 'OKS_BILL_SUB_LINES_V'
1205: ,p_col_name => 'attribute11'
1206: ,p_col_value => p_attribute11
1207: ,x_return_status => l_return_status
1208: );

Line 1258: p_view_name => 'OKS_BILL_SUB_LINES_V'

1254: -- call column length utility
1255: /*
1256: OKC_UTIL.CHECK_LENGTH
1257: (
1258: p_view_name => 'OKS_BILL_SUB_LINES_V'
1259: ,p_col_name => 'attribute12'
1260: ,p_col_value => p_attribute12
1261: ,x_return_status => l_return_status
1262: );

Line 1311: p_view_name => 'OKS_BILL_SUB_LINES_V'

1307: -- call column length utility
1308: /*
1309: OKC_UTIL.CHECK_LENGTH
1310: (
1311: p_view_name => 'OKS_BILL_SUB_LINES_V'
1312: ,p_col_name => 'attribute13'
1313: ,p_col_value => p_attribute13
1314: ,x_return_status => l_return_status
1315: );

Line 1364: p_view_name => 'OKS_BILL_SUB_LINES_V'

1360: -- call column length utility
1361: /*
1362: OKC_UTIL.CHECK_LENGTH
1363: (
1364: p_view_name => 'OKS_BILL_SUB_LINES_V'
1365: ,p_col_name => 'attribute14'
1366: ,p_col_value => p_attribute14
1367: ,x_return_status => l_return_status
1368: );

Line 1415: p_view_name => 'OKS_BILL_SUB_LINES_V'

1411: -- call column length utility
1412: /*
1413: OKC_UTIL.CHECK_LENGTH
1414: (
1415: p_view_name => 'OKS_BILL_SUB_LINES_V'
1416: ,p_col_name => 'attribute15'
1417: ,p_col_value => p_attribute15
1418: ,x_return_status => l_return_status
1419: );

Line 1454: -- Validate_Attributes for:OKS_BILL_SUB_LINES_V --

1450: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1451: END validate_attribute15;
1452:
1453: --------------------------------------------------
1454: -- Validate_Attributes for:OKS_BILL_SUB_LINES_V --
1455: --------------------------------------------------
1456: /*
1457: FUNCTION Validate_Attributes (
1458: p_bslv_rec IN bslv_rec_type

Line 1502: OKC_UTIL.ADD_VIEW('OKS_BILL_SUB_LINES_V',x_return_status);

1498:
1499: Begin
1500: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1501:
1502: OKC_UTIL.ADD_VIEW('OKS_BILL_SUB_LINES_V',x_return_status);
1503:
1504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1505: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1506: -- need to leave

Line 1950: -- Validate_Record for:OKS_BILL_SUB_LINES_V --

1946: ---------------------------------------------------------------------------
1947: -- PROCEDURE Validate_Record
1948: ---------------------------------------------------------------------------
1949: ----------------------------------------------
1950: -- Validate_Record for:OKS_BILL_SUB_LINES_V --
1951: ----------------------------------------------
1952: FUNCTION Validate_Record (
1953: p_bslv_rec IN bslv_rec_type
1954: ) RETURN VARCHAR2 IS

Line 2171: -- validate_row for:OKS_BILL_SUB_LINES_V --

2167: ---------------------------------------------------------------------------
2168: -- PROCEDURE validate_row
2169: ---------------------------------------------------------------------------
2170: -------------------------------------------
2171: -- validate_row for:OKS_BILL_SUB_LINES_V --
2172: -------------------------------------------
2173: PROCEDURE validate_row(
2174: p_api_version IN NUMBER,
2175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2462: -- insert_row for:OKS_BILL_SUB_LINES_V --

2458: '_PVT'
2459: );
2460: END insert_row;
2461: -----------------------------------------
2462: -- insert_row for:OKS_BILL_SUB_LINES_V --
2463: -----------------------------------------
2464: PROCEDURE insert_row(
2465: p_api_version IN NUMBER,
2466: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2496: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --

2492: l_bslv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2493: RETURN(l_bslv_rec);
2494: END fill_who_columns;
2495: ---------------------------------------------
2496: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --
2497: ---------------------------------------------
2498: FUNCTION Set_Attributes (
2499: p_bslv_rec IN bslv_rec_type,
2500: x_bslv_rec OUT NOCOPY bslv_rec_type

Line 2782: -- lock_row for:OKS_BILL_SUB_LINES_V --

2778: '_PVT'
2779: );
2780: END lock_row;
2781: ---------------------------------------
2782: -- lock_row for:OKS_BILL_SUB_LINES_V --
2783: ---------------------------------------
2784: PROCEDURE lock_row(
2785: p_api_version IN NUMBER,
2786: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3195: -- update_row for:OKS_BILL_SUB_LINES_V --

3191: '_PVT'
3192: );
3193: END update_row;
3194: -----------------------------------------
3195: -- update_row for:OKS_BILL_SUB_LINES_V --
3196: -----------------------------------------
3197: PROCEDURE update_row(
3198: p_api_version IN NUMBER,
3199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3370: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --

3366: END IF;
3367: RETURN(l_return_status);
3368: END populate_new_record;
3369: ---------------------------------------------
3370: -- Set_Attributes for:OKS_BILL_SUB_LINES_V --
3371: ---------------------------------------------
3372: FUNCTION Set_Attributes (
3373: p_bslv_rec IN bslv_rec_type,
3374: x_bslv_rec OUT NOCOPY bslv_rec_type

Line 3614: -- delete_row for:OKS_BILL_SUB_LINES_V --

3610: '_PVT'
3611: );
3612: END delete_row;
3613: -----------------------------------------
3614: -- delete_row for:OKS_BILL_SUB_LINES_V --
3615: -----------------------------------------
3616: PROCEDURE delete_row(
3617: p_api_version IN NUMBER,
3618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,