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_AAE_PVT dependencies on OKC_ACTION_ATTRIBUTES_B

Line 53: FROM OKC_ACTION_ATTRIBUTES_B B

49:
50: DELETE FROM OKC_ACTION_ATTRIBUTES_TL T
51: WHERE NOT EXISTS (
52: SELECT NULL
53: FROM OKC_ACTION_ATTRIBUTES_B B
54: WHERE B.ID = T.ID
55: );
56:
57: UPDATE OKC_ACTION_ATTRIBUTES_TL T SET (

Line 118: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_B

114:
115: END add_language;
116:
117: ---------------------------------------------------------------------------
118: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_B
119: ---------------------------------------------------------------------------
120: FUNCTION get_rec (
121: p_aae_rec IN aae_rec_type,
122: x_no_data_found OUT NOCOPY BOOLEAN

Line 124: CURSOR okc_action_attributes_b_pk_csr (p_id IN NUMBER) IS

120: FUNCTION get_rec (
121: p_aae_rec IN aae_rec_type,
122: x_no_data_found OUT NOCOPY BOOLEAN
123: ) RETURN aae_rec_type IS
124: CURSOR okc_action_attributes_b_pk_csr (p_id IN NUMBER) IS
125: SELECT
126: ID,
127: AAL_ID,
128: ACN_ID,

Line 165: FROM Okc_Action_Attributes_B

161: ATTRIBUTE12,
162: ATTRIBUTE13,
163: ATTRIBUTE14,
164: ATTRIBUTE15
165: FROM Okc_Action_Attributes_B
166: WHERE okc_action_attributes_b.id = p_id;
167: l_okc_action_attributes_b_pk okc_action_attributes_b_pk_csr%ROWTYPE;
168: l_aae_rec aae_rec_type;
169: BEGIN

Line 166: WHERE okc_action_attributes_b.id = p_id;

162: ATTRIBUTE13,
163: ATTRIBUTE14,
164: ATTRIBUTE15
165: FROM Okc_Action_Attributes_B
166: WHERE okc_action_attributes_b.id = p_id;
167: l_okc_action_attributes_b_pk okc_action_attributes_b_pk_csr%ROWTYPE;
168: l_aae_rec aae_rec_type;
169: BEGIN
170: x_no_data_found := TRUE;

Line 167: l_okc_action_attributes_b_pk okc_action_attributes_b_pk_csr%ROWTYPE;

163: ATTRIBUTE14,
164: ATTRIBUTE15
165: FROM Okc_Action_Attributes_B
166: WHERE okc_action_attributes_b.id = p_id;
167: l_okc_action_attributes_b_pk okc_action_attributes_b_pk_csr%ROWTYPE;
168: l_aae_rec aae_rec_type;
169: BEGIN
170: x_no_data_found := TRUE;
171: -- Get current database values

Line 172: OPEN okc_action_attributes_b_pk_csr (p_aae_rec.id);

168: l_aae_rec aae_rec_type;
169: BEGIN
170: x_no_data_found := TRUE;
171: -- Get current database values
172: OPEN okc_action_attributes_b_pk_csr (p_aae_rec.id);
173: FETCH okc_action_attributes_b_pk_csr INTO
174: l_aae_rec.ID,
175: l_aae_rec.AAL_ID,
176: l_aae_rec.ACN_ID,

Line 173: FETCH okc_action_attributes_b_pk_csr INTO

169: BEGIN
170: x_no_data_found := TRUE;
171: -- Get current database values
172: OPEN okc_action_attributes_b_pk_csr (p_aae_rec.id);
173: FETCH okc_action_attributes_b_pk_csr INTO
174: l_aae_rec.ID,
175: l_aae_rec.AAL_ID,
176: l_aae_rec.ACN_ID,
177: l_aae_rec.ELEMENT_NAME,

Line 213: x_no_data_found := okc_action_attributes_b_pk_csr%NOTFOUND;

209: l_aae_rec.ATTRIBUTE12,
210: l_aae_rec.ATTRIBUTE13,
211: l_aae_rec.ATTRIBUTE14,
212: l_aae_rec.ATTRIBUTE15;
213: x_no_data_found := okc_action_attributes_b_pk_csr%NOTFOUND;
214: CLOSE okc_action_attributes_b_pk_csr;
215: RETURN(l_aae_rec);
216: END get_rec;
217:

Line 214: CLOSE okc_action_attributes_b_pk_csr;

210: l_aae_rec.ATTRIBUTE13,
211: l_aae_rec.ATTRIBUTE14,
212: l_aae_rec.ATTRIBUTE15;
213: x_no_data_found := okc_action_attributes_b_pk_csr%NOTFOUND;
214: CLOSE okc_action_attributes_b_pk_csr;
215: RETURN(l_aae_rec);
216: END get_rec;
217:
218: FUNCTION get_rec (

Line 2045: FROM okc_action_attributes_b

2041: l_row_found Boolean := False;
2042: CURSOR c1(p_acn_id okc_action_attributes_v.acn_id%TYPE,
2043: p_element_name okc_Action_attributes_v.element_name%TYPE) is
2044: SELECT 1
2045: FROM okc_action_attributes_b
2046: WHERE acn_id = p_acn_id
2047: AND element_name = p_element_name
2048: AND id <> nvl(p_aaev_rec.id,-9999);
2049:

Line 2614: -- insert_row for:OKC_ACTION_ATTRIBUTES_B --

2610: ---------------------------------------------------------------------------
2611: -- PROCEDURE insert_row
2612: ---------------------------------------------------------------------------
2613: --------------------------------------------
2614: -- insert_row for:OKC_ACTION_ATTRIBUTES_B --
2615: --------------------------------------------
2616: PROCEDURE insert_row(
2617: p_init_msg_list IN VARCHAR2 ,
2618: x_return_status OUT NOCOPY VARCHAR2,

Line 2630: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_B --

2626: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2627: l_aae_rec aae_rec_type := p_aae_rec;
2628: l_def_aae_rec aae_rec_type;
2629: ------------------------------------------------
2630: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_B --
2631: ------------------------------------------------
2632: FUNCTION Set_Attributes (
2633: p_aae_rec IN aae_rec_type,
2634: x_aae_rec OUT NOCOPY aae_rec_type

Line 2661: INSERT INTO OKC_ACTION_ATTRIBUTES_B(

2657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2658: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2659: RAISE OKC_API.G_EXCEPTION_ERROR;
2660: END IF;
2661: INSERT INTO OKC_ACTION_ATTRIBUTES_B(
2662: id,
2663: aal_id,
2664: acn_id,
2665: element_name,

Line 3135: -- lock_row for:OKC_ACTION_ATTRIBUTES_B --

3131: ---------------------------------------------------------------------------
3132: -- PROCEDURE lock_row
3133: ---------------------------------------------------------------------------
3134: ------------------------------------------
3135: -- lock_row for:OKC_ACTION_ATTRIBUTES_B --
3136: ------------------------------------------
3137: PROCEDURE lock_row(
3138: p_init_msg_list IN VARCHAR2 ,
3139: x_return_status OUT NOCOPY VARCHAR2,

Line 3148: FROM OKC_ACTION_ATTRIBUTES_B

3144: E_Resource_Busy EXCEPTION;
3145: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3146: CURSOR lock_csr (p_aae_rec IN aae_rec_type) IS
3147: SELECT OBJECT_VERSION_NUMBER
3148: FROM OKC_ACTION_ATTRIBUTES_B
3149: WHERE ID = p_aae_rec.id
3150: AND OBJECT_VERSION_NUMBER = p_aae_rec.object_version_number
3151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3152:

Line 3155: FROM OKC_ACTION_ATTRIBUTES_B

3151: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3152:
3153: CURSOR lchk_csr (p_aae_rec IN aae_rec_type) IS
3154: SELECT OBJECT_VERSION_NUMBER
3155: FROM OKC_ACTION_ATTRIBUTES_B
3156: WHERE ID = p_aae_rec.id;
3157: l_api_version CONSTANT NUMBER := 1;
3158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3160: l_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;

3156: WHERE ID = p_aae_rec.id;
3157: l_api_version CONSTANT NUMBER := 1;
3158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3160: l_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;
3161: lc_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;
3162: l_row_notfound BOOLEAN := FALSE;
3163: lc_row_notfound BOOLEAN := FALSE;
3164: BEGIN

Line 3161: lc_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;

3157: l_api_version CONSTANT NUMBER := 1;
3158: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3160: l_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;
3161: lc_object_version_number OKC_ACTION_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE;
3162: l_row_notfound BOOLEAN := FALSE;
3163: lc_row_notfound BOOLEAN := FALSE;
3164: BEGIN
3165: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3488: -- update_row for:OKC_ACTION_ATTRIBUTES_B --

3484: ---------------------------------------------------------------------------
3485: -- PROCEDURE update_row
3486: ---------------------------------------------------------------------------
3487: --------------------------------------------
3488: -- update_row for:OKC_ACTION_ATTRIBUTES_B --
3489: --------------------------------------------
3490: PROCEDURE update_row(
3491: p_init_msg_list IN VARCHAR2 ,
3492: x_return_status OUT NOCOPY VARCHAR2,

Line 3680: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_B --

3676: END IF;
3677: RETURN(l_return_status);
3678: END populate_new_record;
3679: ------------------------------------------------
3680: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_B --
3681: ------------------------------------------------
3682: FUNCTION Set_Attributes (
3683: p_aae_rec IN aae_rec_type,
3684: x_aae_rec OUT NOCOPY aae_rec_type

Line 3717: UPDATE OKC_ACTION_ATTRIBUTES_B

3713: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3714: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3715: RAISE OKC_API.G_EXCEPTION_ERROR;
3716: END IF;
3717: UPDATE OKC_ACTION_ATTRIBUTES_B
3718: SET AAL_ID = l_def_aae_rec.aal_id,
3719: ACN_ID = l_def_aae_rec.acn_id,
3720: ELEMENT_NAME = l_def_aae_rec.element_name,
3721: DATA_TYPE = l_def_aae_rec.data_type,

Line 4397: -- delete_row for:OKC_ACTION_ATTRIBUTES_B --

4393: ---------------------------------------------------------------------------
4394: -- PROCEDURE delete_row
4395: ---------------------------------------------------------------------------
4396: --------------------------------------------
4397: -- delete_row for:OKC_ACTION_ATTRIBUTES_B --
4398: --------------------------------------------
4399: PROCEDURE delete_row(
4400: p_init_msg_list IN VARCHAR2 ,
4401: x_return_status OUT NOCOPY VARCHAR2,

Line 4421: DELETE FROM OKC_ACTION_ATTRIBUTES_B

4417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4418: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4419: RAISE OKC_API.G_EXCEPTION_ERROR;
4420: END IF;
4421: DELETE FROM OKC_ACTION_ATTRIBUTES_B
4422: WHERE ID = l_aae_rec.id;
4423:
4424: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4425: EXCEPTION