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_AQM_PVT dependencies on OKC_AQMSGSTACKS

Line 38: -- FUNCTION get_rec for: OKC_AQMSGSTACKS

34: null;
35: END api_copy;
36:
37: ---------------------------------------------------------------------------
38: -- FUNCTION get_rec for: OKC_AQMSGSTACKS
39: ---------------------------------------------------------------------------
40: FUNCTION get_rec (
41: p_aqm_rec IN aqm_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN

Line 57: FROM Okc_Aqmsgstacks

53: CREATION_DATE,
54: LAST_UPDATED_BY,
55: LAST_UPDATE_DATE,
56: LAST_UPDATE_LOGIN
57: FROM Okc_Aqmsgstacks
58: WHERE okc_aqmsgstacks.aqe_id = p_aqe_id
59: AND okc_aqmsgstacks.msg_seq_no = p_msg_seq_no;
60: l_okc_aqm_pk okc_aqm_pk_csr%ROWTYPE;
61: l_aqm_rec aqm_rec_type;

Line 58: WHERE okc_aqmsgstacks.aqe_id = p_aqe_id

54: LAST_UPDATED_BY,
55: LAST_UPDATE_DATE,
56: LAST_UPDATE_LOGIN
57: FROM Okc_Aqmsgstacks
58: WHERE okc_aqmsgstacks.aqe_id = p_aqe_id
59: AND okc_aqmsgstacks.msg_seq_no = p_msg_seq_no;
60: l_okc_aqm_pk okc_aqm_pk_csr%ROWTYPE;
61: l_aqm_rec aqm_rec_type;
62: BEGIN

Line 59: AND okc_aqmsgstacks.msg_seq_no = p_msg_seq_no;

55: LAST_UPDATE_DATE,
56: LAST_UPDATE_LOGIN
57: FROM Okc_Aqmsgstacks
58: WHERE okc_aqmsgstacks.aqe_id = p_aqe_id
59: AND okc_aqmsgstacks.msg_seq_no = p_msg_seq_no;
60: l_okc_aqm_pk okc_aqm_pk_csr%ROWTYPE;
61: l_aqm_rec aqm_rec_type;
62: BEGIN
63: x_no_data_found := TRUE;

Line 91: -- FUNCTION get_rec for: OKC_AQMSGSTACKS_V

87: BEGIN
88: RETURN(get_rec(p_aqm_rec, l_row_notfound));
89: END get_rec;
90: ---------------------------------------------------------------------------
91: -- FUNCTION get_rec for: OKC_AQMSGSTACKS_V
92: ---------------------------------------------------------------------------
93: FUNCTION get_rec (
94: p_aqmv_rec IN aqmv_rec_type,
95: x_no_data_found OUT NOCOPY BOOLEAN

Line 110: FROM Okc_Aqmsgstacks_V

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okc_Aqmsgstacks_V
111: WHERE okc_aqmsgstacks_v.aqe_id = p_aqe_id
112: AND okc_aqmsgstacks_v.msg_seq_no = p_msg_seq_no;
113: l_okc_aqmv_pk okc_aqmv_pk_csr%ROWTYPE;
114: l_aqmv_rec aqmv_rec_type;

Line 111: WHERE okc_aqmsgstacks_v.aqe_id = p_aqe_id

107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okc_Aqmsgstacks_V
111: WHERE okc_aqmsgstacks_v.aqe_id = p_aqe_id
112: AND okc_aqmsgstacks_v.msg_seq_no = p_msg_seq_no;
113: l_okc_aqmv_pk okc_aqmv_pk_csr%ROWTYPE;
114: l_aqmv_rec aqmv_rec_type;
115: BEGIN

Line 112: AND okc_aqmsgstacks_v.msg_seq_no = p_msg_seq_no;

108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okc_Aqmsgstacks_V
111: WHERE okc_aqmsgstacks_v.aqe_id = p_aqe_id
112: AND okc_aqmsgstacks_v.msg_seq_no = p_msg_seq_no;
113: l_okc_aqmv_pk okc_aqmv_pk_csr%ROWTYPE;
114: l_aqmv_rec aqmv_rec_type;
115: BEGIN
116: x_no_data_found := TRUE;

Line 145: -- FUNCTION null_out_defaults for: OKC_AQMSGSTACKS_V --

141: RETURN(get_rec(p_aqmv_rec, l_row_notfound));
142: END get_rec;
143:
144: -------------------------------------------------------
145: -- FUNCTION null_out_defaults for: OKC_AQMSGSTACKS_V --
146: -------------------------------------------------------
147: FUNCTION null_out_defaults (
148: p_aqmv_rec IN aqmv_rec_type
149: ) RETURN aqmv_rec_type IS

Line 182: -- Validate_Attributes for:OKC_AQMSGSTACKS_V --

178: ---------------------------------------------------------------------------
179: -- PROCEDURE Validate_Attributes
180: ---------------------------------------------------------------------------
181: -----------------------------------------------
182: -- Validate_Attributes for:OKC_AQMSGSTACKS_V --
183: -----------------------------------------------
184: -- Start of comments
185: -- Procedure Name : validate_msgseq_no
186: -- Description : Check if message sequence number is null

Line 267: p_token2_value => 'OKC_AQMSGSTACKS_V',

263: p_msg_name => g_no_parent_record,
264: p_token1 => g_col_name_token,
265: p_token1_value => 'aqe_id',
266: p_token2 => g_child_table_token,
267: p_token2_value => 'OKC_AQMSGSTACKS_V',
268: p_token3 => g_parent_table_token,
269: p_token3_value => 'OKC_AQERRORS_V');
270: x_return_status := OKC_API.G_RET_STS_ERROR;
271: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 344: -- Validate_Record for:OKC_AQMSGSTACKS_V --

340: ---------------------------------------------------------------------------
341: -- PROCEDURE Validate_Record
342: ---------------------------------------------------------------------------
343: -------------------------------------------
344: -- Validate_Record for:OKC_AQMSGSTACKS_V --
345: -------------------------------------------
346: FUNCTION Validate_Record (
347: p_aqmv_rec IN aqmv_rec_type
348: ) RETURN VARCHAR2 IS

Line 394: -- validate_row for:OKC_AQMSGSTACKS_V --

390: ---------------------------------------------------------------------------
391: -- PROCEDURE validate_row
392: ---------------------------------------------------------------------------
393: ----------------------------------------
394: -- validate_row for:OKC_AQMSGSTACKS_V --
395: ----------------------------------------
396: PROCEDURE validate_row(
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 ,

Line 539: -- insert_row for:OKC_AQMSGSTACKS --

535: ---------------------------------------------------------------------------
536: -- PROCEDURE insert_row
537: ---------------------------------------------------------------------------
538: ------------------------------------
539: -- insert_row for:OKC_AQMSGSTACKS --
540: ------------------------------------
541: PROCEDURE insert_row(
542: p_init_msg_list IN VARCHAR2 ,
543: x_return_status OUT NOCOPY VARCHAR2,

Line 555: -- Set_Attributes for:OKC_AQMSGSTACKS --

551: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
552: l_aqm_rec aqm_rec_type := p_aqm_rec;
553: l_def_aqm_rec aqm_rec_type;
554: ----------------------------------------
555: -- Set_Attributes for:OKC_AQMSGSTACKS --
556: ----------------------------------------
557: FUNCTION Set_Attributes (
558: p_aqm_rec IN aqm_rec_type,
559: x_aqm_rec OUT NOCOPY aqm_rec_type

Line 586: INSERT INTO OKC_AQMSGSTACKS(

582: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
583: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
584: RAISE OKC_API.G_EXCEPTION_ERROR;
585: END IF;
586: INSERT INTO OKC_AQMSGSTACKS(
587: aqe_id,
588: msg_seq_no,
589: message_name,
590: message_number,

Line 644: -- insert_row for:OKC_AQMSGSTACKS_V --

640: '_PVT'
641: );
642: END insert_row;
643: --------------------------------------
644: -- insert_row for:OKC_AQMSGSTACKS_V --
645: --------------------------------------
646: PROCEDURE insert_row(
647: p_api_version IN NUMBER,
648: p_init_msg_list IN VARCHAR2 ,

Line 678: -- Set_Attributes for:OKC_AQMSGSTACKS_V --

674: l_aqmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
675: RETURN(l_aqmv_rec);
676: END fill_who_columns;
677: ------------------------------------------
678: -- Set_Attributes for:OKC_AQMSGSTACKS_V --
679: ------------------------------------------
680: FUNCTION Set_Attributes (
681: p_aqmv_rec IN aqmv_rec_type,
682: x_aqmv_rec OUT NOCOPY aqmv_rec_type

Line 856: -- lock_row for:OKC_AQMSGSTACKS --

852: ---------------------------------------------------------------------------
853: -- PROCEDURE lock_row
854: ---------------------------------------------------------------------------
855: ----------------------------------
856: -- lock_row for:OKC_AQMSGSTACKS --
857: ----------------------------------
858: PROCEDURE lock_row(
859: p_init_msg_list IN VARCHAR2 ,
860: x_return_status OUT NOCOPY VARCHAR2,

Line 869: FROM OKC_AQMSGSTACKS

865: E_Resource_Busy EXCEPTION;
866: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
867: CURSOR lock_csr (p_aqm_rec IN aqm_rec_type) IS
868: SELECT *
869: FROM OKC_AQMSGSTACKS
870: WHERE AQE_ID = p_aqm_rec.aqe_id
871: AND MSG_SEQ_NO = p_aqm_rec.msg_seq_no
872: FOR UPDATE NOWAIT;
873:

Line 983: -- lock_row for:OKC_AQMSGSTACKS_V --

979: '_PVT'
980: );
981: END lock_row;
982: ------------------------------------
983: -- lock_row for:OKC_AQMSGSTACKS_V --
984: ------------------------------------
985: PROCEDURE lock_row(
986: p_api_version IN NUMBER,
987: p_init_msg_list IN VARCHAR2 ,

Line 1131: -- update_row for:OKC_AQMSGSTACKS --

1127: ---------------------------------------------------------------------------
1128: -- PROCEDURE update_row
1129: ---------------------------------------------------------------------------
1130: ------------------------------------
1131: -- update_row for:OKC_AQMSGSTACKS --
1132: ------------------------------------
1133: PROCEDURE update_row(
1134: p_init_msg_list IN VARCHAR2 ,
1135: x_return_status OUT NOCOPY VARCHAR2,

Line 1207: -- Set_Attributes for:OKC_AQMSGSTACKS --

1203: END IF;
1204: RETURN(l_return_status);
1205: END populate_new_record;
1206: ----------------------------------------
1207: -- Set_Attributes for:OKC_AQMSGSTACKS --
1208: ----------------------------------------
1209: FUNCTION Set_Attributes (
1210: p_aqm_rec IN aqm_rec_type,
1211: x_aqm_rec OUT NOCOPY aqm_rec_type

Line 1244: UPDATE OKC_AQMSGSTACKS

1240: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1242: RAISE OKC_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: UPDATE OKC_AQMSGSTACKS
1245: SET MESSAGE_NAME = l_def_aqm_rec.message_name,
1246: MESSAGE_NUMBER = l_def_aqm_rec.message_number,
1247: MESSAGE_TEXT = l_def_aqm_rec.message_text,
1248: CREATED_BY = l_def_aqm_rec.created_by,

Line 1291: -- update_row for:OKC_AQMSGSTACKS_V --

1287: '_PVT'
1288: );
1289: END update_row;
1290: --------------------------------------
1291: -- update_row for:OKC_AQMSGSTACKS_V --
1292: --------------------------------------
1293: PROCEDURE update_row(
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 ,

Line 1382: -- Set_Attributes for:OKC_AQMSGSTACKS_V --

1378: END IF;
1379: RETURN(l_return_status);
1380: END populate_new_record;
1381: ------------------------------------------
1382: -- Set_Attributes for:OKC_AQMSGSTACKS_V --
1383: ------------------------------------------
1384: FUNCTION Set_Attributes (
1385: p_aqmv_rec IN aqmv_rec_type,
1386: x_aqmv_rec OUT NOCOPY aqmv_rec_type

Line 1565: -- delete_row for:OKC_AQMSGSTACKS --

1561: ---------------------------------------------------------------------------
1562: -- PROCEDURE delete_row
1563: ---------------------------------------------------------------------------
1564: ------------------------------------
1565: -- delete_row for:OKC_AQMSGSTACKS --
1566: ------------------------------------
1567: PROCEDURE delete_row(
1568: p_init_msg_list IN VARCHAR2 ,
1569: x_return_status OUT NOCOPY VARCHAR2,

Line 1589: DELETE FROM OKC_AQMSGSTACKS

1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1586: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_ERROR;
1588: END IF;
1589: DELETE FROM OKC_AQMSGSTACKS
1590: WHERE AQE_ID = l_aqm_rec.aqe_id AND
1591: MSG_SEQ_NO = l_aqm_rec.msg_seq_no;
1592:
1593: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1627: -- delete_row for:OKC_AQMSGSTACKS_V --

1623: '_PVT'
1624: );
1625: END delete_row;
1626: --------------------------------------
1627: -- delete_row for:OKC_AQMSGSTACKS_V --
1628: --------------------------------------
1629: PROCEDURE delete_row(
1630: p_api_version IN NUMBER,
1631: p_init_msg_list IN VARCHAR2 ,