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.

[Home] [Help]

APPS.OKS_KHR_PVT dependencies on OKS_K_HEADERS_V

Line 94: -- FUNCTION get_rec for: OKS_K_HEADERS_V

90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_K_HEADERS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_khrv_rec IN khrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 190: FROM Oks_K_Headers_V

186: EXEMPT_REASON_CODE,
187: APPROVAL_TYPE_USED,
188: RENEWAL_COMMENT,
189: CC_EMAIL_ADDRESS
190: FROM Oks_K_Headers_V
191: WHERE oks_k_headers_v.id = p_id;
192: l_oks_khrv_pk oks_khrv_pk_csr%ROWTYPE;
193: l_khrv_rec khrv_rec_type;
194: BEGIN

Line 191: WHERE oks_k_headers_v.id = p_id;

187: APPROVAL_TYPE_USED,
188: RENEWAL_COMMENT,
189: CC_EMAIL_ADDRESS
190: FROM Oks_K_Headers_V
191: WHERE oks_k_headers_v.id = p_id;
192: l_oks_khrv_pk oks_khrv_pk_csr%ROWTYPE;
193: l_khrv_rec khrv_rec_type;
194: BEGIN
195: x_no_data_found := TRUE;

Line 546: -- FUNCTION null_out_defaults for: OKS_K_HEADERS_V

542: BEGIN
543: RETURN(get_rec(p_khr_rec, l_row_not_found));
544: END get_rec;
545: ---------------------------------------------------------------------------
546: -- FUNCTION null_out_defaults for: OKS_K_HEADERS_V
547: ---------------------------------------------------------------------------
548: FUNCTION null_out_defaults (
549: p_khrv_rec IN khrv_rec_type
550: ) RETURN khrv_rec_type IS

Line 906: -- Validate_Attributes for:OKS_K_HEADERS_V --

902: ---------------------------------------------------------------------------
903: -- FUNCTION Validate_Attributes
904: ---------------------------------------------------------------------------
905: ---------------------------------------------
906: -- Validate_Attributes for:OKS_K_HEADERS_V --
907: ---------------------------------------------
908: FUNCTION Validate_Attributes (
909: p_khrv_rec IN khrv_rec_type
910: ) RETURN VARCHAR2 IS

Line 962: -- Validate Record for:OKS_K_HEADERS_V --

958: ---------------------------------------------------------------------------
959: -- PROCEDURE Validate_Record
960: ---------------------------------------------------------------------------
961: -----------------------------------------
962: -- Validate Record for:OKS_K_HEADERS_V --
963: -----------------------------------------
964: FUNCTION Validate_Record (
965: p_khrv_rec IN khrv_rec_type,
966: p_db_khrv_rec IN khrv_rec_type

Line 1217: -- validate_row for:OKS_K_HEADERS_V --

1213: ---------------------------------------------------------------------------
1214: -- PROCEDURE validate_row
1215: ---------------------------------------------------------------------------
1216: --------------------------------------
1217: -- validate_row for:OKS_K_HEADERS_V --
1218: --------------------------------------
1219: PROCEDURE validate_row(
1220: p_api_version IN NUMBER,
1221: p_init_msg_list IN VARCHAR2,

Line 1294: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --

1290: '_PVT'
1291: );
1292: END validate_row;
1293: -------------------------------------------------
1294: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --
1295: -------------------------------------------------
1296: PROCEDURE validate_row(
1297: p_api_version IN NUMBER,
1298: p_init_msg_list IN VARCHAR2,

Line 1390: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --

1386: );
1387: END validate_row;
1388:
1389: -------------------------------------------------
1390: -- PL/SQL TBL validate_row for:OKS_K_HEADERS_V --
1391: -------------------------------------------------
1392: PROCEDURE validate_row(
1393: p_api_version IN NUMBER,
1394: p_init_msg_list IN VARCHAR2,

Line 1821: -- insert_row for :OKS_K_HEADERS_V --

1817: '_PVT'
1818: );
1819: END insert_row;
1820: -------------------------------------
1821: -- insert_row for :OKS_K_HEADERS_V --
1822: -------------------------------------
1823: PROCEDURE insert_row(
1824: p_api_version IN NUMBER,
1825: p_init_msg_list IN VARCHAR2,

Line 1857: -- Set_Attributes for:OKS_K_HEADERS_V --

1853: l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1854: RETURN(l_khrv_rec);
1855: END fill_who_columns;
1856: ----------------------------------------
1857: -- Set_Attributes for:OKS_K_HEADERS_V --
1858: ----------------------------------------
1859: FUNCTION Set_Attributes (
1860: p_khrv_rec IN khrv_rec_type,
1861: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 2242: -- lock_row for: OKS_K_HEADERS_V --

2238: '_PVT'
2239: );
2240: END lock_row;
2241: -----------------------------------
2242: -- lock_row for: OKS_K_HEADERS_V --
2243: -----------------------------------
2244: PROCEDURE lock_row(
2245: p_api_version IN NUMBER,
2246: p_init_msg_list IN VARCHAR2,

Line 3162: -- update_row for:OKS_K_HEADERS_V --

3158: '_PVT'
3159: );
3160: END update_row;
3161: ------------------------------------
3162: -- update_row for:OKS_K_HEADERS_V --
3163: ------------------------------------
3164: PROCEDURE update_row(
3165: p_api_version IN NUMBER,
3166: p_init_msg_list IN VARCHAR2,

Line 3564: -- Set_Attributes for:OKS_K_HEADERS_V --

3560: END IF;
3561: RETURN(l_return_status);
3562: END populate_new_record;
3563: ----------------------------------------
3564: -- Set_Attributes for:OKS_K_HEADERS_V --
3565: ----------------------------------------
3566: FUNCTION Set_Attributes (
3567: p_khrv_rec IN khrv_rec_type,
3568: x_khrv_rec OUT NOCOPY khrv_rec_type

Line 3958: -- delete_row for:OKS_K_HEADERS_V --

3954: '_PVT'
3955: );
3956: END delete_row;
3957: ------------------------------------
3958: -- delete_row for:OKS_K_HEADERS_V --
3959: ------------------------------------
3960: PROCEDURE delete_row(
3961: p_api_version IN NUMBER,
3962: p_init_msg_list IN VARCHAR2,

Line 4040: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --

4036: '_PVT'
4037: );
4038: END delete_row;
4039: -----------------------------------------------
4040: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --
4041: -----------------------------------------------
4042: PROCEDURE delete_row(
4043: p_api_version IN NUMBER,
4044: p_init_msg_list IN VARCHAR2,

Line 4136: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --

4132: );
4133: END delete_row;
4134:
4135: -----------------------------------------------
4136: -- PL/SQL TBL delete_row for:OKS_K_HEADERS_V --
4137: -----------------------------------------------
4138: PROCEDURE delete_row(
4139: p_api_version IN NUMBER,
4140: p_init_msg_list IN VARCHAR2,