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_AVL_PVT dependencies on OKS_SERV_AVAILS_V

Line 126: -- FUNCTION get_rec for: OKS_SERV_AVAILS_V

122: BEGIN
123: RETURN(get_rec(p_sav_rec, l_row_notfound));
124: END get_rec;
125: ---------------------------------------------------------------------------
126: -- FUNCTION get_rec for: OKS_SERV_AVAILS_V
127: ---------------------------------------------------------------------------
128: FUNCTION get_rec (
129: p_savv_rec IN savv_rec_type,
130: x_no_data_found OUT NOCOPY BOOLEAN

Line 164: FROM Oks_Serv_Avails_V

160: ATTRIBUTE12,
161: ATTRIBUTE13,
162: ATTRIBUTE14,
163: ATTRIBUTE15
164: FROM Oks_Serv_Avails_V
165: WHERE oks_serv_avails_v.id = p_id;
166: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
167: l_savv_rec savv_rec_type;
168: BEGIN

Line 165: WHERE oks_serv_avails_v.id = p_id;

161: ATTRIBUTE13,
162: ATTRIBUTE14,
163: ATTRIBUTE15
164: FROM Oks_Serv_Avails_V
165: WHERE oks_serv_avails_v.id = p_id;
166: l_oks_savv_pk oks_savv_pk_csr%ROWTYPE;
167: l_savv_rec savv_rec_type;
168: BEGIN
169: x_no_data_found := TRUE;

Line 217: -- FUNCTION null_out_defaults for: OKS_SERV_AVAILS_V --

213: RETURN(get_rec(p_savv_rec, l_row_notfound));
214: END get_rec;
215:
216: -------------------------------------------------------
217: -- FUNCTION null_out_defaults for: OKS_SERV_AVAILS_V --
218: -------------------------------------------------------
219: FUNCTION null_out_defaults (
220: p_savv_rec IN savv_rec_type
221: ) RETURN savv_rec_type IS

Line 377: p_view_name => 'OKS_SERV_AVAILS_V'

373:
374: -- call column length utility
375: OKC_UTIL.CHECK_LENGTH
376: (
377: p_view_name => 'OKS_SERV_AVAILS_V'
378: ,p_col_name => 'object1_id1'
379: ,p_col_value => P_object1_id1
380: ,x_return_status => l_return_status
381: );

Line 439: p_view_name => 'OKS_SERV_AVAILS_V'

435:
436: -- call column length utility
437: OKC_UTIL.CHECK_LENGTH
438: (
439: p_view_name => 'OKS_SERV_AVAILS_V'
440: ,p_col_name => 'object1_id2'
441: ,p_col_value => P_object1_id2
442: ,x_return_status => l_return_status
443: );

Line 499: p_view_name => 'OKS_SERV_AVAILS_V'

495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: End If;
497: OKC_UTIL.CHECK_LENGTH
498: (
499: p_view_name => 'OKS_SERV_AVAILS_V'
500: ,p_col_name => 'object_version_number'
501: ,p_col_value => P_object_version_number
502: ,x_return_status => l_return_status
503: );

Line 557: p_view_name => 'OKS_SERV_AVAILS_V'

553: End If;
554: -- call column length utility
555: OKC_UTIL.CHECK_LENGTH
556: (
557: p_view_name => 'OKS_SERV_AVAILS_V'
558: ,p_col_name => 'general_yn'
559: ,p_col_value => P_general_yn
560: ,x_return_status => l_return_status
561: );

Line 619: p_view_name => 'OKS_SERV_AVAILS_V'

615: End If;
616: -- call column length utility
617: OKC_UTIL.CHECK_LENGTH
618: (
619: p_view_name => 'OKS_SERV_AVAILS_V'
620: ,p_col_name => 'except_object_type'
621: ,p_col_value => P_except_object_type
622: ,x_return_status => l_return_status
623: );

Line 702: p_view_name => 'OKS_SERV_AVAILS_V'

698:
699: -- call column length utility
700: OKC_UTIL.CHECK_LENGTH
701: (
702: p_view_name => 'OKS_SERV_AVAILS_V'
703: ,p_col_name => 'attribute_category'
704: ,p_col_value => p_attribute_category
705: ,x_return_status => l_return_status
706: );

Line 748: p_view_name => 'OKS_SERV_AVAILS_V'

744: x_return_status := OKC_API.G_RET_STS_SUCCESS;
745: -- call column length utility
746: OKC_UTIL.CHECK_LENGTH
747: (
748: p_view_name => 'OKS_SERV_AVAILS_V'
749: ,p_col_name => 'attribute1'
750: ,p_col_value => p_attribute1
751: ,x_return_status => l_return_status
752: );

Line 794: p_view_name => 'OKS_SERV_AVAILS_V'

790:
791: -- call column length utility
792: OKC_UTIL.CHECK_LENGTH
793: (
794: p_view_name => 'OKS_SERV_AVAILS_V'
795: ,p_col_name => 'attribute2'
796: ,p_col_value => p_attribute2
797: ,x_return_status => l_return_status
798: );

Line 841: p_view_name => 'OKS_SERV_AVAILS_V'

837: x_return_status := OKC_API.G_RET_STS_SUCCESS;
838: -- call column length utility
839: OKC_UTIL.CHECK_LENGTH
840: (
841: p_view_name => 'OKS_SERV_AVAILS_V'
842: ,p_col_name => 'attribute3'
843: ,p_col_value => p_attribute3
844: ,x_return_status => l_return_status
845: );

Line 887: p_view_name => 'OKS_SERV_AVAILS_V'

883:
884: -- call column length utility
885: OKC_UTIL.CHECK_LENGTH
886: (
887: p_view_name => 'OKS_SERV_AVAILS_V'
888: ,p_col_name => 'attribute4'
889: ,p_col_value => p_attribute4
890: ,x_return_status => l_return_status
891: );

Line 934: p_view_name => 'OKS_SERV_AVAILS_V'

930: x_return_status := OKC_API.G_RET_STS_SUCCESS;
931: -- call column length utility
932: OKC_UTIL.CHECK_LENGTH
933: (
934: p_view_name => 'OKS_SERV_AVAILS_V'
935: ,p_col_name => 'attribute5'
936: ,p_col_value => p_attribute5
937: ,x_return_status => l_return_status
938: );

Line 980: p_view_name => 'OKS_SERV_AVAILS_V'

976: x_return_status := OKC_API.G_RET_STS_SUCCESS;
977: -- call column length utility
978: OKC_UTIL.CHECK_LENGTH
979: (
980: p_view_name => 'OKS_SERV_AVAILS_V'
981: ,p_col_name => 'attribute6'
982: ,p_col_value => p_attribute6
983: ,x_return_status => l_return_status
984: );

Line 1026: p_view_name => 'OKS_SERV_AVAILS_V'

1022:
1023: -- call column length utility
1024: OKC_UTIL.CHECK_LENGTH
1025: (
1026: p_view_name => 'OKS_SERV_AVAILS_V'
1027: ,p_col_name => 'attribute7'
1028: ,p_col_value => p_attribute7
1029: ,x_return_status => l_return_status
1030: );

Line 1073: p_view_name => 'OKS_SERV_AVAILS_V'

1069: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1070: -- call column length utility
1071: OKC_UTIL.CHECK_LENGTH
1072: (
1073: p_view_name => 'OKS_SERV_AVAILS_V'
1074: ,p_col_name => 'attribute8'
1075: ,p_col_value => p_attribute8
1076: ,x_return_status => l_return_status
1077: );

Line 1119: p_view_name => 'OKS_SERV_AVAILS_V'

1115:
1116: -- call column length utility
1117: OKC_UTIL.CHECK_LENGTH
1118: (
1119: p_view_name => 'OKS_SERV_AVAILS_V'
1120: ,p_col_name => 'attribute9'
1121: ,p_col_value => p_attribute9
1122: ,x_return_status => l_return_status
1123: );

Line 1166: p_view_name => 'OKS_SERV_AVAILS_V'

1162: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1163: -- call column length utility
1164: OKC_UTIL.CHECK_LENGTH
1165: (
1166: p_view_name => 'OKS_SERV_AVAILS_V'
1167: ,p_col_name => 'attribute10'
1168: ,p_col_value => p_attribute10
1169: ,x_return_status => l_return_status
1170: );

Line 1212: p_view_name => 'OKS_SERV_AVAILS_V'

1208: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1209: -- call column length utility
1210: OKC_UTIL.CHECK_LENGTH
1211: (
1212: p_view_name => 'OKS_SERV_AVAILS_V'
1213: ,p_col_name => 'attribute11'
1214: ,p_col_value => p_attribute11
1215: ,x_return_status => l_return_status
1216: );

Line 1256: p_view_name => 'OKS_SERV_AVAILS_V'

1252: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1253: -- call column length utility
1254: OKC_UTIL.CHECK_LENGTH
1255: (
1256: p_view_name => 'OKS_SERV_AVAILS_V'
1257: ,p_col_name => 'attribute12'
1258: ,p_col_value => p_attribute12
1259: ,x_return_status => l_return_status
1260: );

Line 1302: p_view_name => 'OKS_SERV_AVAILS_V'

1298: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1299: -- call column length utility
1300: OKC_UTIL.CHECK_LENGTH
1301: (
1302: p_view_name => 'OKS_SERV_AVAILS_V'
1303: ,p_col_name => 'attribute13'
1304: ,p_col_value => p_attribute13
1305: ,x_return_status => l_return_status
1306: );

Line 1348: p_view_name => 'OKS_SERV_AVAILS_V'

1344:
1345: -- call column length utility
1346: OKC_UTIL.CHECK_LENGTH
1347: (
1348: p_view_name => 'OKS_SERV_AVAILS_V'
1349: ,p_col_name => 'attribute14'
1350: ,p_col_value => p_attribute14
1351: ,x_return_status => l_return_status
1352: );

Line 1395: p_view_name => 'OKS_SERV_AVAILS_V'

1391: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1392: -- call column length utility
1393: OKC_UTIL.CHECK_LENGTH
1394: (
1395: p_view_name => 'OKS_SERV_AVAILS_V'
1396: ,p_col_name => 'attribute15'
1397: ,p_col_value => p_attribute15
1398: ,x_return_status => l_return_status
1399: );

Line 1434: -- Validate_Attributes for:OKS_SERV_AVAILS_V --

1430: END validate_attribute15;
1431:
1432:
1433: -----------------------------------------------
1434: -- Validate_Attributes for:OKS_SERV_AVAILS_V --
1435: -----------------------------------------------
1436: FUNCTION Validate_Attributes (
1437: p_savv_rec IN savv_rec_type
1438: )

Line 1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);

1442:
1443: Begin
1444: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1445:
1446: OKC_UTIL.ADD_VIEW('OKS_SERV_AVAILS_V',x_return_status);
1447:
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1449: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: -- need to leave

Line 1889: -- Validate_Attributes for:OKS_SERV_AVAILS_V --

1885:
1886:
1887: /*
1888: -----------------------------------------------
1889: -- Validate_Attributes for:OKS_SERV_AVAILS_V --
1890: -----------------------------------------------
1891: FUNCTION Validate_Attributes (
1892: p_savv_rec IN savv_rec_type
1893: ) RETURN VARCHAR2 IS

Line 1925: -- Validate_Record for:OKS_SERV_AVAILS_V --

1921: ---------------------------------------------------------------------------
1922: -- PROCEDURE Validate_Record
1923: ---------------------------------------------------------------------------
1924: -------------------------------------------
1925: -- Validate_Record for:OKS_SERV_AVAILS_V --
1926: -------------------------------------------
1927: FUNCTION Validate_Record (
1928: p_savv_rec IN savv_rec_type
1929: ) RETURN VARCHAR2 IS

Line 2015: -- validate_row for:OKS_SERV_AVAILS_V --

2011: ---------------------------------------------------------------------------
2012: -- PROCEDURE validate_row
2013: ---------------------------------------------------------------------------
2014: ----------------------------------------
2015: -- validate_row for:OKS_SERV_AVAILS_V --
2016: ----------------------------------------
2017: PROCEDURE validate_row(
2018: p_api_version IN NUMBER,
2019: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2316: -- insert_row for:OKS_SERV_AVAILS_V --

2312: '_PVT'
2313: );
2314: END insert_row;
2315: --------------------------------------
2316: -- insert_row for:OKS_SERV_AVAILS_V --
2317: --------------------------------------
2318: PROCEDURE insert_row(
2319: p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2350: -- Set_Attributes for:OKS_SERV_AVAILS_V --

2346: l_savv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2347: RETURN(l_savv_rec);
2348: END fill_who_columns;
2349: ------------------------------------------
2350: -- Set_Attributes for:OKS_SERV_AVAILS_V --
2351: ------------------------------------------
2352: FUNCTION Set_Attributes (
2353: p_savv_rec IN savv_rec_type,
2354: x_savv_rec OUT NOCOPY savv_rec_type

Line 2647: -- lock_row for:OKS_SERV_AVAILS_V --

2643: '_PVT'
2644: );
2645: END lock_row;
2646: ------------------------------------
2647: -- lock_row for:OKS_SERV_AVAILS_V --
2648: ------------------------------------
2649: PROCEDURE lock_row(
2650: p_api_version IN NUMBER,
2651: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3056: -- update_row for:OKS_SERV_AVAILS_V --

3052: '_PVT'
3053: );
3054: END update_row;
3055: --------------------------------------
3056: -- update_row for:OKS_SERV_AVAILS_V --
3057: --------------------------------------
3058: PROCEDURE update_row(
3059: p_api_version IN NUMBER,
3060: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3227: -- Set_Attributes for:OKS_SERV_AVAILS_V --

3223: END IF;
3224: RETURN(l_return_status);
3225: END populate_new_record;
3226: ------------------------------------------
3227: -- Set_Attributes for:OKS_SERV_AVAILS_V --
3228: ------------------------------------------
3229:
3230: FUNCTION Set_Attributes (
3231: p_savv_rec IN savv_rec_type,

Line 3472: -- delete_row for:OKS_SERV_AVAILS_V --

3468: '_PVT'
3469: );
3470: END delete_row;
3471: --------------------------------------
3472: -- delete_row for:OKS_SERV_AVAILS_V --
3473: --------------------------------------
3474: PROCEDURE delete_row(
3475: p_api_version IN NUMBER,
3476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,