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_COE_PVT dependencies on OKC_CONDITION_OCCURS

Line 39: -- FUNCTION get_rec for: OKC_CONDITION_OCCURS

35: null;
36: END api_copy;
37:
38: ---------------------------------------------------------------------------
39: -- FUNCTION get_rec for: OKC_CONDITION_OCCURS
40: ---------------------------------------------------------------------------
41: FUNCTION get_rec (
42: p_coe_rec IN coe_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN

Line 56: FROM Okc_Condition_Occurs

52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okc_Condition_Occurs
57: WHERE okc_condition_occurs.id = p_id;
58: l_coe_pk coe_pk_csr%ROWTYPE;
59: l_coe_rec coe_rec_type;
60: BEGIN

Line 57: WHERE okc_condition_occurs.id = p_id;

53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okc_Condition_Occurs
57: WHERE okc_condition_occurs.id = p_id;
58: l_coe_pk coe_pk_csr%ROWTYPE;
59: l_coe_rec coe_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;

Line 87: -- FUNCTION get_rec for: OKC_CONDITION_OCCURS_V

83: BEGIN
84: RETURN(get_rec(p_coe_rec, l_row_notfound));
85: END get_rec;
86: ---------------------------------------------------------------------------
87: -- FUNCTION get_rec for: OKC_CONDITION_OCCURS_V
88: ---------------------------------------------------------------------------
89: FUNCTION get_rec (
90: p_coev_rec IN coev_rec_type,
91: x_no_data_found OUT NOCOPY BOOLEAN

Line 104: FROM Okc_Condition_Occurs_V

100: CREATION_DATE,
101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okc_Condition_Occurs_V
105: WHERE okc_condition_occurs_v.id = p_id;
106: l_okc_coev_pk okc_coev_pk_csr%ROWTYPE;
107: l_coev_rec coev_rec_type;
108: BEGIN

Line 105: WHERE okc_condition_occurs_v.id = p_id;

101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okc_Condition_Occurs_V
105: WHERE okc_condition_occurs_v.id = p_id;
106: l_okc_coev_pk okc_coev_pk_csr%ROWTYPE;
107: l_coev_rec coev_rec_type;
108: BEGIN
109: x_no_data_found := TRUE;

Line 136: -- FUNCTION null_out_defaults for: OKC_CONDITION_OCCURS_V --

132: RETURN(get_rec(p_coev_rec, l_row_notfound));
133: END get_rec;
134:
135: ------------------------------------------------------------
136: -- FUNCTION null_out_defaults for: OKC_CONDITION_OCCURS_V --
137: ------------------------------------------------------------
138: FUNCTION null_out_defaults (
139: p_coev_rec IN coev_rec_type
140: ) RETURN coev_rec_type IS

Line 173: -- Validate_Attributes for:OKC_CONDITION_OCCURS_V --

169: ---------------------------------------------------------------------------
170: -- PROCEDURE Validate_Attributes
171: ---------------------------------------------------------------------------
172: ----------------------------------------------------
173: -- Validate_Attributes for:OKC_CONDITION_OCCURS_V --
174: ----------------------------------------------------
175: /* commenting out nocopy generated code in favor of hand written code
176: FUNCTION Validate_Attributes (
177: p_coev_rec IN coev_rec_type

Line 520: -- Validate_Record for:OKC_CONDITION_OCCURS_V --

516: ---------------------------------------------------------------------------
517: -- PROCEDURE Validate_Record
518: ---------------------------------------------------------------------------
519: ------------------------------------------------
520: -- Validate_Record for:OKC_CONDITION_OCCURS_V --
521: ------------------------------------------------
522: /* commenting out nocopy generated ocde in favor of hand written code
523:
524: FUNCTION Validate_Record (

Line 651: -- validate_row for:OKC_CONDITION_OCCURS_V --

647: ---------------------------------------------------------------------------
648: -- PROCEDURE validate_row
649: ---------------------------------------------------------------------------
650: ---------------------------------------------
651: -- validate_row for:OKC_CONDITION_OCCURS_V --
652: ---------------------------------------------
653: PROCEDURE validate_row(
654: p_api_version IN NUMBER,
655: p_init_msg_list IN VARCHAR2 ,

Line 795: -- insert_row for:OKC_CONDITION_OCCURS --

791: ---------------------------------------------------------------------------
792: -- PROCEDURE insert_row
793: ---------------------------------------------------------------------------
794: -----------------------------------------
795: -- insert_row for:OKC_CONDITION_OCCURS --
796: -----------------------------------------
797: PROCEDURE insert_row(
798: p_init_msg_list IN VARCHAR2 ,
799: x_return_status OUT NOCOPY VARCHAR2,

Line 811: -- Set_Attributes for:OKC_CONDITION_OCCURS --

807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
808: l_coe_rec coe_rec_type := p_coe_rec;
809: l_def_coe_rec coe_rec_type;
810: ---------------------------------------------
811: -- Set_Attributes for:OKC_CONDITION_OCCURS --
812: ---------------------------------------------
813: FUNCTION Set_Attributes (
814: p_coe_rec IN coe_rec_type,
815: x_coe_rec OUT NOCOPY coe_rec_type

Line 846: INSERT INTO OKC_CONDITION_OCCURS(

842:
843: -- bug 2131122, use sysdate for LAST OCCURRENCE regardless of value passed for datetime.
844: l_coe_rec.datetime := sysdate;
845:
846: INSERT INTO OKC_CONDITION_OCCURS(
847: id,
848: cnh_id,
849: datetime,
850: object_version_number,

Line 902: -- insert_row for:OKC_CONDITION_OCCURS_V --

898: '_PVT'
899: );
900: END insert_row;
901: -------------------------------------------
902: -- insert_row for:OKC_CONDITION_OCCURS_V --
903: -------------------------------------------
904: PROCEDURE insert_row(
905: p_api_version IN NUMBER,
906: p_init_msg_list IN VARCHAR2 ,

Line 936: -- Set_Attributes for:OKC_CONDITION_OCCURS_V --

932: l_coev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
933: RETURN(l_coev_rec);
934: END fill_who_columns;
935: -----------------------------------------------
936: -- Set_Attributes for:OKC_CONDITION_OCCURS_V --
937: -----------------------------------------------
938: FUNCTION Set_Attributes (
939: p_coev_rec IN coev_rec_type,
940: x_coev_rec OUT NOCOPY coev_rec_type

Line 1116: -- lock_row for:OKC_CONDITION_OCCURS --

1112: ---------------------------------------------------------------------------
1113: -- PROCEDURE lock_row
1114: ---------------------------------------------------------------------------
1115: ---------------------------------------
1116: -- lock_row for:OKC_CONDITION_OCCURS --
1117: ---------------------------------------
1118: PROCEDURE lock_row(
1119: p_init_msg_list IN VARCHAR2 ,
1120: x_return_status OUT NOCOPY VARCHAR2,

Line 1129: FROM OKC_CONDITION_OCCURS

1125: E_Resource_Busy EXCEPTION;
1126: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1127: CURSOR lock_csr (p_coe_rec IN coe_rec_type) IS
1128: SELECT OBJECT_VERSION_NUMBER
1129: FROM OKC_CONDITION_OCCURS
1130: WHERE ID = p_coe_rec.id
1131: AND OBJECT_VERSION_NUMBER = p_coe_rec.object_version_number
1132: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1133:

Line 1136: FROM OKC_CONDITION_OCCURS

1132: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1133:
1134: CURSOR lchk_csr (p_coe_rec IN coe_rec_type) IS
1135: SELECT OBJECT_VERSION_NUMBER
1136: FROM OKC_CONDITION_OCCURS
1137: WHERE ID = p_coe_rec.id;
1138: l_api_version CONSTANT NUMBER := 1;
1139: l_api_name CONSTANT VARCHAR2(30) := 'OCCURS_lock_row';
1140: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1141: l_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;

1137: WHERE ID = p_coe_rec.id;
1138: l_api_version CONSTANT NUMBER := 1;
1139: l_api_name CONSTANT VARCHAR2(30) := 'OCCURS_lock_row';
1140: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1141: l_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;
1142: lc_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;
1143: l_row_notfound BOOLEAN := FALSE;
1144: lc_row_notfound BOOLEAN := FALSE;
1145: BEGIN

Line 1142: lc_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;

1138: l_api_version CONSTANT NUMBER := 1;
1139: l_api_name CONSTANT VARCHAR2(30) := 'OCCURS_lock_row';
1140: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1141: l_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;
1142: lc_object_version_number OKC_CONDITION_OCCURS.OBJECT_VERSION_NUMBER%TYPE;
1143: l_row_notfound BOOLEAN := FALSE;
1144: lc_row_notfound BOOLEAN := FALSE;
1145: BEGIN
1146: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1222: -- lock_row for:OKC_CONDITION_OCCURS_V --

1218: '_PVT'
1219: );
1220: END lock_row;
1221: -----------------------------------------
1222: -- lock_row for:OKC_CONDITION_OCCURS_V --
1223: -----------------------------------------
1224: PROCEDURE lock_row(
1225: p_api_version IN NUMBER,
1226: p_init_msg_list IN VARCHAR2 ,

Line 1370: -- update_row for:OKC_CONDITION_OCCURS --

1366: ---------------------------------------------------------------------------
1367: -- PROCEDURE update_row
1368: ---------------------------------------------------------------------------
1369: -----------------------------------------
1370: -- update_row for:OKC_CONDITION_OCCURS --
1371: -----------------------------------------
1372: PROCEDURE update_row(
1373: p_init_msg_list IN VARCHAR2 ,
1374: x_return_status OUT NOCOPY VARCHAR2,

Line 1442: -- Set_Attributes for:OKC_CONDITION_OCCURS --

1438: END IF;
1439: RETURN(l_return_status);
1440: END populate_new_record;
1441: ---------------------------------------------
1442: -- Set_Attributes for:OKC_CONDITION_OCCURS --
1443: ---------------------------------------------
1444: FUNCTION Set_Attributes (
1445: p_coe_rec IN coe_rec_type,
1446: x_coe_rec OUT NOCOPY coe_rec_type

Line 1479: UPDATE OKC_CONDITION_OCCURS

1475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1477: RAISE OKC_API.G_EXCEPTION_ERROR;
1478: END IF;
1479: UPDATE OKC_CONDITION_OCCURS
1480: SET CNH_ID = l_def_coe_rec.cnh_id,
1481: DATETIME = l_def_coe_rec.datetime,
1482: OBJECT_VERSION_NUMBER = l_def_coe_rec.object_version_number,
1483: CREATED_BY = l_def_coe_rec.created_by,

Line 1525: -- update_row for:OKC_CONDITION_OCCURS_V --

1521: '_PVT'
1522: );
1523: END update_row;
1524: -------------------------------------------
1525: -- update_row for:OKC_CONDITION_OCCURS_V --
1526: -------------------------------------------
1527: PROCEDURE update_row(
1528: p_api_version IN NUMBER,
1529: p_init_msg_list IN VARCHAR2 ,

Line 1612: -- Set_Attributes for:OKC_CONDITION_OCCURS_V --

1608: END IF;
1609: RETURN(l_return_status);
1610: END populate_new_record;
1611: -----------------------------------------------
1612: -- Set_Attributes for:OKC_CONDITION_OCCURS_V --
1613: -----------------------------------------------
1614: FUNCTION Set_Attributes (
1615: p_coev_rec IN coev_rec_type,
1616: x_coev_rec OUT NOCOPY coev_rec_type

Line 1795: -- delete_row for:OKC_CONDITION_OCCURS --

1791: ---------------------------------------------------------------------------
1792: -- PROCEDURE delete_row
1793: ---------------------------------------------------------------------------
1794: -----------------------------------------
1795: -- delete_row for:OKC_CONDITION_OCCURS --
1796: -----------------------------------------
1797: PROCEDURE delete_row(
1798: p_init_msg_list IN VARCHAR2 ,
1799: x_return_status OUT NOCOPY VARCHAR2,

Line 1819: DELETE FROM OKC_CONDITION_OCCURS

1815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1817: RAISE OKC_API.G_EXCEPTION_ERROR;
1818: END IF;
1819: DELETE FROM OKC_CONDITION_OCCURS
1820: WHERE ID = l_coe_rec.id;
1821:
1822: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1823: EXCEPTION

Line 1856: -- delete_row for:OKC_CONDITION_OCCURS_V --

1852: '_PVT'
1853: );
1854: END delete_row;
1855: -------------------------------------------
1856: -- delete_row for:OKC_CONDITION_OCCURS_V --
1857: -------------------------------------------
1858: PROCEDURE delete_row(
1859: p_api_version IN NUMBER,
1860: p_init_msg_list IN VARCHAR2 ,

Line 2001: -- Procedure for mass insert in OKC_CONDITION_OCCURS _B and TL tables

1997: '_PVT'
1998: );
1999: END delete_row;
2000: ---------------------------------------------------------------
2001: -- Procedure for mass insert in OKC_CONDITION_OCCURS _B and TL tables
2002: ---------------------------------------------------------------
2003: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_coev_tbl coev_tbl_type) IS
2004: l_tabsize NUMBER := p_coev_tbl.COUNT;
2005: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 2039: INTO OKC_CONDITION_OCCURS

2035: END LOOP;
2036:
2037: FORALL i in 1..l_tabsize
2038: INSERT
2039: INTO OKC_CONDITION_OCCURS
2040: (
2041: id,
2042: cnh_id,
2043: datetime,