APPS.OKC_AQM_PVT dependencies on OKC_AQMSGSTACKS_V

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 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 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 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 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 ,