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.OKC_AST_PVT dependencies on OKC_ASSENTS_V

Line 16: OKC_ASSENTS_V

12: cursor seed_c is
13: select
14: nvl(max(id), 11000) + 1
15: from
16: OKC_ASSENTS_V
17: where
18: id >= 11000 AND id < 50000;
19: BEGIN
20: if fnd_global.user_id = 1 then

Line 141: -- FUNCTION get_rec for: OKC_ASSENTS_V

137: BEGIN
138: RETURN(get_rec(p_ast_rec, l_row_notfound));
139: END get_rec;
140: ---------------------------------------------------------------------------
141: -- FUNCTION get_rec for: OKC_ASSENTS_V
142: ---------------------------------------------------------------------------
143: FUNCTION get_rec (
144: p_astv_rec IN astv_rec_type,
145: x_no_data_found OUT NOCOPY BOOLEAN

Line 177: FROM Okc_Assents_V

173: CREATION_DATE,
174: LAST_UPDATED_BY,
175: LAST_UPDATE_DATE,
176: LAST_UPDATE_LOGIN
177: FROM Okc_Assents_V
178: WHERE okc_assents_v.id = p_id;
179: l_okc_astv_pk okc_astv_pk_csr%ROWTYPE;
180: l_astv_rec astv_rec_type;
181: BEGIN

Line 178: WHERE okc_assents_v.id = p_id;

174: LAST_UPDATED_BY,
175: LAST_UPDATE_DATE,
176: LAST_UPDATE_LOGIN
177: FROM Okc_Assents_V
178: WHERE okc_assents_v.id = p_id;
179: l_okc_astv_pk okc_astv_pk_csr%ROWTYPE;
180: l_astv_rec astv_rec_type;
181: BEGIN
182: x_no_data_found := TRUE;

Line 228: -- FUNCTION null_out_defaults for: OKC_ASSENTS_V --

224: RETURN(get_rec(p_astv_rec, l_row_notfound));
225: END get_rec;
226:
227: ---------------------------------------------------
228: -- FUNCTION null_out_defaults for: OKC_ASSENTS_V --
229: ---------------------------------------------------
230: FUNCTION null_out_defaults (
231: p_astv_rec IN astv_rec_type
232: ) RETURN astv_rec_type IS

Line 503: -- Validate_Attributes for:OKC_ASSENTS_V --

499: ---------------------------------------------------------------------------
500: -- PROCEDURE Validate_Attributes
501: ---------------------------------------------------------------------------
502: -------------------------------------------
503: -- Validate_Attributes for:OKC_ASSENTS_V --
504: -------------------------------------------
505: FUNCTION Validate_Attributes (
506: p_astv_rec IN astv_rec_type
507: ) RETURN VARCHAR2 IS

Line 605: -- Validate_Record for:OKC_ASSENTS_V --

601: ---------------------------------------------------------------------------
602: -- PROCEDURE Validate_Record
603: ---------------------------------------------------------------------------
604: ---------------------------------------
605: -- Validate_Record for:OKC_ASSENTS_V --
606: ---------------------------------------
607: FUNCTION Validate_Record (
608: p_astv_rec IN astv_rec_type
609: ) RETURN VARCHAR2 IS

Line 688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,

684: unique_key_error EXCEPTION;
685: l_dummy VARCHAR2(1);
686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS

Line 689: p_scs_code IN okc_assents_v.scs_code%TYPE,

685: l_dummy VARCHAR2(1);
686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'

Line 690: p_sts_code IN okc_assents_v.sts_code%TYPE,

686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V

Line 691: p_opn_code IN okc_assents_v.opn_code%TYPE,

687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code

Line 692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS

688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code
696: AND sts_code = p_sts_code

Line 694: FROM Okc_Assents_V

690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code
696: AND sts_code = p_sts_code
697: AND opn_code = p_opn_code
698: AND ste_code = p_ste_code

Line 825: -- validate_row for:OKC_ASSENTS_V --

821: ---------------------------------------------------------------------------
822: -- PROCEDURE validate_row
823: ---------------------------------------------------------------------------
824: ------------------------------------
825: -- validate_row for:OKC_ASSENTS_V --
826: ------------------------------------
827: PROCEDURE validate_row(
828: p_api_version IN NUMBER,
829: p_init_msg_list IN VARCHAR2 ,

Line 1110: -- insert_row for:OKC_ASSENTS_V --

1106: '_PVT'
1107: );
1108: END insert_row;
1109: ----------------------------------
1110: -- insert_row for:OKC_ASSENTS_V --
1111: ----------------------------------
1112: PROCEDURE insert_row(
1113: p_api_version IN NUMBER,
1114: p_init_msg_list IN VARCHAR2 ,

Line 1144: -- Set_Attributes for:OKC_ASSENTS_V --

1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1141: RETURN(l_astv_rec);
1142: END fill_who_columns;
1143: --------------------------------------
1144: -- Set_Attributes for:OKC_ASSENTS_V --
1145: --------------------------------------
1146: FUNCTION Set_Attributes (
1147: p_astv_rec IN astv_rec_type,
1148: x_astv_rec OUT NOCOPY astv_rec_type

Line 1430: -- lock_row for:OKC_ASSENTS_V --

1426: '_PVT'
1427: );
1428: END lock_row;
1429: --------------------------------
1430: -- lock_row for:OKC_ASSENTS_V --
1431: --------------------------------
1432: PROCEDURE lock_row(
1433: p_api_version IN NUMBER,
1434: p_init_msg_list IN VARCHAR2 ,

Line 1828: -- update_row for:OKC_ASSENTS_V --

1824: '_PVT'
1825: );
1826: END update_row;
1827: ----------------------------------
1828: -- update_row for:OKC_ASSENTS_V --
1829: ----------------------------------
1830: PROCEDURE update_row(
1831: p_api_version IN NUMBER,
1832: p_init_msg_list IN VARCHAR2 ,

Line 1991: -- Set_Attributes for:OKC_ASSENTS_V --

1987: END IF;
1988: RETURN(l_return_status);
1989: END populate_new_record;
1990: --------------------------------------
1991: -- Set_Attributes for:OKC_ASSENTS_V --
1992: --------------------------------------
1993: FUNCTION Set_Attributes (
1994: p_astv_rec IN astv_rec_type,
1995: x_astv_rec OUT NOCOPY astv_rec_type

Line 2235: -- delete_row for:OKC_ASSENTS_V --

2231: '_PVT'
2232: );
2233: END delete_row;
2234: ----------------------------------
2235: -- delete_row for:OKC_ASSENTS_V --
2236: ----------------------------------
2237: PROCEDURE delete_row(
2238: p_api_version IN NUMBER,
2239: p_init_msg_list IN VARCHAR2 ,

Line 2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is

2406: from okc_k_headers_all_b
2407: --END NPALEPU
2408: where id = p_header_id;
2409: --
2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2411: select 'x'
2412: from okc_assents
2413: where scs_code = l_scs_code
2414: and sts_code = l_sts_code

Line 2559: cursor c1(p_allowed_yn okc_assents_v.allowed_yn%TYPE) is

2555: l_dummy varchar2(1);
2556: l_row_notfound BOOLEAN;
2557: l_return_status Varchar2(1);
2558: l_lse_id okc_k_lines_v.lse_id%TYPE;
2559: cursor c1(p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2560: select 'x'
2561: from okc_k_lines_b L,
2562: --NPALEPU for Bug # 4597099 on 13-AUG-2005
2563: /* okc_k_headers_b K, */