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_AAL_PVT dependencies on OKC_ACTION_ATT_LOOKUPS

Line 38: -- FUNCTION get_rec for: OKC_ACTION_ATT_LOOKUPS

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

Line 55: FROM Okc_Action_Att_Lookups

51: CREATION_DATE,
52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN
55: FROM Okc_Action_Att_Lookups
56: WHERE okc_action_att_lookups.id = p_id;
57: l_aal_pk aal_pk_csr%ROWTYPE;
58: l_aal_rec aal_rec_type;
59: BEGIN

Line 56: WHERE okc_action_att_lookups.id = p_id;

52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN
55: FROM Okc_Action_Att_Lookups
56: WHERE okc_action_att_lookups.id = p_id;
57: l_aal_pk aal_pk_csr%ROWTYPE;
58: l_aal_rec aal_rec_type;
59: BEGIN
60: x_no_data_found := TRUE;

Line 86: -- FUNCTION get_rec for: OKC_ACTION_ATT_LOOKUPS_V

82: BEGIN
83: RETURN(get_rec(p_aal_rec, l_row_notfound));
84: END get_rec;
85: ---------------------------------------------------------------------------
86: -- FUNCTION get_rec for: OKC_ACTION_ATT_LOOKUPS_V
87: ---------------------------------------------------------------------------
88: FUNCTION get_rec (
89: p_aalv_rec IN aalv_rec_type,
90: x_no_data_found OUT NOCOPY BOOLEAN

Line 103: FROM Okc_Action_Att_Lookups_V

99: CREATION_DATE,
100: LAST_UPDATED_BY,
101: LAST_UPDATE_DATE,
102: LAST_UPDATE_LOGIN
103: FROM Okc_Action_Att_Lookups_V
104: WHERE okc_action_att_lookups_v.id = p_id;
105: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
106: l_aalv_rec aalv_rec_type;
107: BEGIN

Line 104: WHERE okc_action_att_lookups_v.id = p_id;

100: LAST_UPDATED_BY,
101: LAST_UPDATE_DATE,
102: LAST_UPDATE_LOGIN
103: FROM Okc_Action_Att_Lookups_V
104: WHERE okc_action_att_lookups_v.id = p_id;
105: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
106: l_aalv_rec aalv_rec_type;
107: BEGIN
108: x_no_data_found := TRUE;

Line 135: -- FUNCTION null_out_defaults for: OKC_ACTION_ATT_LOOKUPS_V --

131: RETURN(get_rec(p_aalv_rec, l_row_notfound));
132: END get_rec;
133:
134: --------------------------------------------------------------
135: -- FUNCTION null_out_defaults for: OKC_ACTION_ATT_LOOKUPS_V --
136: --------------------------------------------------------------
137: FUNCTION null_out_defaults (
138: p_aalv_rec IN aalv_rec_type
139: ) RETURN aalv_rec_type IS

Line 241: SELECT id FROM OKC_ACTION_ATT_LOOKUPS_V

237: ,p_aalv_rec IN aalv_rec_type)
238: IS
239:
240: CURSOR l_unq_cur(p_object_name VARCHAR2) IS
241: SELECT id FROM OKC_ACTION_ATT_LOOKUPS_V
242: WHERE object_name = p_object_name;
243:
244: l_id NUMBER := OKC_API.G_MISS_NUM;
245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 274: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTION_ATT_LOOKUPS_V'

270: p_msg_name => 'OKC_DUP_OBJECT_NAME');
271: END IF;
272:
273: /*
274: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTION_ATT_LOOKUPS_V'
275: ,p_col_name => 'object_name'
276: ,p_col_value => p_aalv_rec.object_name
277: ,p_id => p_aalv_rec.id
278: ,x_return_status => l_return_status);

Line 366: -- Validate_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

362: ---------------------------------------------------------------------------
363: -- PROCEDURE Validate_Attributes
364: ---------------------------------------------------------------------------
365: ------------------------------------------------------
366: -- Validate_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
367: ------------------------------------------------------
368: /* commenting out nocopy generated code in favor of hand written code
369: FUNCTION Validate_Attributes (
370: p_aalv_rec IN aalv_rec_type

Line 496: -- Validate_Record for:OKC_ACTION_ATT_LOOKUPS_V --

492: ---------------------------------------------------------------------------
493: -- PROCEDURE Validate_Record
494: ---------------------------------------------------------------------------
495: --------------------------------------------------
496: -- Validate_Record for:OKC_ACTION_ATT_LOOKUPS_V --
497: --------------------------------------------------
498: FUNCTION Validate_Record (
499: p_aalv_rec IN aalv_rec_type
500: ) RETURN VARCHAR2 IS

Line 545: -- validate_row for:OKC_ACTION_ATT_LOOKUPS_V --

541: ---------------------------------------------------------------------------
542: -- PROCEDURE validate_row
543: ---------------------------------------------------------------------------
544: -----------------------------------------------
545: -- validate_row for:OKC_ACTION_ATT_LOOKUPS_V --
546: -----------------------------------------------
547: PROCEDURE validate_row(
548: p_api_version IN NUMBER,
549: p_init_msg_list IN VARCHAR2 ,

Line 689: -- insert_row for:OKC_ACTION_ATT_LOOKUPS --

685: ---------------------------------------------------------------------------
686: -- PROCEDURE insert_row
687: ---------------------------------------------------------------------------
688: -------------------------------------------
689: -- insert_row for:OKC_ACTION_ATT_LOOKUPS --
690: -------------------------------------------
691: PROCEDURE insert_row(
692: p_init_msg_list IN VARCHAR2 ,
693: x_return_status OUT NOCOPY VARCHAR2,

Line 705: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS --

701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
702: l_aal_rec aal_rec_type := p_aal_rec;
703: l_def_aal_rec aal_rec_type;
704: -----------------------------------------------
705: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS --
706: -----------------------------------------------
707: FUNCTION Set_Attributes (
708: p_aal_rec IN aal_rec_type,
709: x_aal_rec OUT NOCOPY aal_rec_type

Line 736: INSERT INTO OKC_ACTION_ATT_LOOKUPS(

732: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
734: RAISE OKC_API.G_EXCEPTION_ERROR;
735: END IF;
736: INSERT INTO OKC_ACTION_ATT_LOOKUPS(
737: id,
738: object_name,
739: column_name,
740: object_version_number,

Line 792: -- insert_row for:OKC_ACTION_ATT_LOOKUPS_V --

788: '_PVT'
789: );
790: END insert_row;
791: ---------------------------------------------
792: -- insert_row for:OKC_ACTION_ATT_LOOKUPS_V --
793: ---------------------------------------------
794: PROCEDURE insert_row(
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 ,

Line 826: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

822: l_aalv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
823: RETURN(l_aalv_rec);
824: END fill_who_columns;
825: -------------------------------------------------
826: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
827: -------------------------------------------------
828: FUNCTION Set_Attributes (
829: p_aalv_rec IN aalv_rec_type,
830: x_aalv_rec OUT NOCOPY aalv_rec_type

Line 1006: -- lock_row for:OKC_ACTION_ATT_LOOKUPS --

1002: ---------------------------------------------------------------------------
1003: -- PROCEDURE lock_row
1004: ---------------------------------------------------------------------------
1005: -----------------------------------------
1006: -- lock_row for:OKC_ACTION_ATT_LOOKUPS --
1007: -----------------------------------------
1008: PROCEDURE lock_row(
1009: p_init_msg_list IN VARCHAR2 ,
1010: x_return_status OUT NOCOPY VARCHAR2,

Line 1019: FROM OKC_ACTION_ATT_LOOKUPS

1015: E_Resource_Busy EXCEPTION;
1016: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1017: CURSOR lock_csr (p_aal_rec IN aal_rec_type) IS
1018: SELECT OBJECT_VERSION_NUMBER
1019: FROM OKC_ACTION_ATT_LOOKUPS
1020: WHERE ID = p_aal_rec.id
1021: AND OBJECT_VERSION_NUMBER = p_aal_rec.object_version_number
1022: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1023:

Line 1026: FROM OKC_ACTION_ATT_LOOKUPS

1022: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1023:
1024: CURSOR lchk_csr (p_aal_rec IN aal_rec_type) IS
1025: SELECT OBJECT_VERSION_NUMBER
1026: FROM OKC_ACTION_ATT_LOOKUPS
1027: WHERE ID = p_aal_rec.id;
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'LOOKUPS_lock_row';
1030: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1031: l_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;

1027: WHERE ID = p_aal_rec.id;
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'LOOKUPS_lock_row';
1030: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1031: l_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;
1032: lc_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;
1033: l_row_notfound BOOLEAN := FALSE;
1034: lc_row_notfound BOOLEAN := FALSE;
1035: BEGIN

Line 1032: lc_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;

1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'LOOKUPS_lock_row';
1030: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1031: l_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;
1032: lc_object_version_number OKC_ACTION_ATT_LOOKUPS.OBJECT_VERSION_NUMBER%TYPE;
1033: l_row_notfound BOOLEAN := FALSE;
1034: lc_row_notfound BOOLEAN := FALSE;
1035: BEGIN
1036: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1112: -- lock_row for:OKC_ACTION_ATT_LOOKUPS_V --

1108: '_PVT'
1109: );
1110: END lock_row;
1111: -------------------------------------------
1112: -- lock_row for:OKC_ACTION_ATT_LOOKUPS_V --
1113: -------------------------------------------
1114: PROCEDURE lock_row(
1115: p_api_version IN NUMBER,
1116: p_init_msg_list IN VARCHAR2 ,

Line 1260: -- update_row for:OKC_ACTION_ATT_LOOKUPS --

1256: ---------------------------------------------------------------------------
1257: -- PROCEDURE update_row
1258: ---------------------------------------------------------------------------
1259: -------------------------------------------
1260: -- update_row for:OKC_ACTION_ATT_LOOKUPS --
1261: -------------------------------------------
1262: PROCEDURE update_row(
1263: p_init_msg_list IN VARCHAR2 ,
1264: x_return_status OUT NOCOPY VARCHAR2,

Line 1332: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS --

1328: END IF;
1329: RETURN(l_return_status);
1330: END populate_new_record;
1331: -----------------------------------------------
1332: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS --
1333: -----------------------------------------------
1334: FUNCTION Set_Attributes (
1335: p_aal_rec IN aal_rec_type,
1336: x_aal_rec OUT NOCOPY aal_rec_type

Line 1369: UPDATE OKC_ACTION_ATT_LOOKUPS

1365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1366: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1367: RAISE OKC_API.G_EXCEPTION_ERROR;
1368: END IF;
1369: UPDATE OKC_ACTION_ATT_LOOKUPS
1370: SET OBJECT_NAME = l_def_aal_rec.object_name,
1371: COLUMN_NAME = l_def_aal_rec.column_name,
1372: OBJECT_VERSION_NUMBER = l_def_aal_rec.object_version_number,
1373: CREATED_BY = l_def_aal_rec.created_by,

Line 1415: -- update_row for:OKC_ACTION_ATT_LOOKUPS_V --

1411: '_PVT'
1412: );
1413: END update_row;
1414: ---------------------------------------------
1415: -- update_row for:OKC_ACTION_ATT_LOOKUPS_V --
1416: ---------------------------------------------
1417: PROCEDURE update_row(
1418: p_api_version IN NUMBER,
1419: p_init_msg_list IN VARCHAR2 ,

Line 1502: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --

1498: END IF;
1499: RETURN(l_return_status);
1500: END populate_new_record;
1501: -------------------------------------------------
1502: -- Set_Attributes for:OKC_ACTION_ATT_LOOKUPS_V --
1503: -------------------------------------------------
1504: FUNCTION Set_Attributes (
1505: p_aalv_rec IN aalv_rec_type,
1506: x_aalv_rec OUT NOCOPY aalv_rec_type

Line 1685: -- delete_row for:OKC_ACTION_ATT_LOOKUPS --

1681: ---------------------------------------------------------------------------
1682: -- PROCEDURE delete_row
1683: ---------------------------------------------------------------------------
1684: -------------------------------------------
1685: -- delete_row for:OKC_ACTION_ATT_LOOKUPS --
1686: -------------------------------------------
1687: PROCEDURE delete_row(
1688: p_init_msg_list IN VARCHAR2 ,
1689: x_return_status OUT NOCOPY VARCHAR2,

Line 1709: DELETE FROM OKC_ACTION_ATT_LOOKUPS

1705: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1707: RAISE OKC_API.G_EXCEPTION_ERROR;
1708: END IF;
1709: DELETE FROM OKC_ACTION_ATT_LOOKUPS
1710: WHERE ID = l_aal_rec.id;
1711:
1712: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1713: EXCEPTION

Line 1746: -- delete_row for:OKC_ACTION_ATT_LOOKUPS_V --

1742: '_PVT'
1743: );
1744: END delete_row;
1745: ---------------------------------------------
1746: -- delete_row for:OKC_ACTION_ATT_LOOKUPS_V --
1747: ---------------------------------------------
1748: PROCEDURE delete_row(
1749: p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 ,