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_OAT_PVT dependencies on OKC_OUTCOME_ARGUMENTS

Line 38: -- FUNCTION get_rec for: OKC_OUTCOME_ARGUMENTS

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

Line 44: CURSOR okc_outcome_arguments_pk_csr (p_id IN NUMBER) IS

40: FUNCTION get_rec (
41: p_oat_rec IN oat_rec_type,
42: x_no_data_found OUT NOCOPY BOOLEAN
43: ) RETURN oat_rec_type IS
44: CURSOR okc_outcome_arguments_pk_csr (p_id IN NUMBER) IS
45: SELECT
46: ID,
47: OCE_ID,
48: PDP_ID,

Line 60: FROM Okc_Outcome_Arguments

56: VALUE,
57: LAST_UPDATE_LOGIN,
58: APPLICATION_ID,
59: SEEDED_FLAG
60: FROM Okc_Outcome_Arguments
61: WHERE okc_outcome_arguments.id = p_id;
62: l_okc_outcome_arguments_pk okc_outcome_arguments_pk_csr%ROWTYPE;
63: l_oat_rec oat_rec_type;
64: BEGIN

Line 61: WHERE okc_outcome_arguments.id = p_id;

57: LAST_UPDATE_LOGIN,
58: APPLICATION_ID,
59: SEEDED_FLAG
60: FROM Okc_Outcome_Arguments
61: WHERE okc_outcome_arguments.id = p_id;
62: l_okc_outcome_arguments_pk okc_outcome_arguments_pk_csr%ROWTYPE;
63: l_oat_rec oat_rec_type;
64: BEGIN
65: x_no_data_found := TRUE;

Line 62: l_okc_outcome_arguments_pk okc_outcome_arguments_pk_csr%ROWTYPE;

58: APPLICATION_ID,
59: SEEDED_FLAG
60: FROM Okc_Outcome_Arguments
61: WHERE okc_outcome_arguments.id = p_id;
62: l_okc_outcome_arguments_pk okc_outcome_arguments_pk_csr%ROWTYPE;
63: l_oat_rec oat_rec_type;
64: BEGIN
65: x_no_data_found := TRUE;
66: -- Get current database values

Line 67: OPEN okc_outcome_arguments_pk_csr (p_oat_rec.id);

63: l_oat_rec oat_rec_type;
64: BEGIN
65: x_no_data_found := TRUE;
66: -- Get current database values
67: OPEN okc_outcome_arguments_pk_csr (p_oat_rec.id);
68: FETCH okc_outcome_arguments_pk_csr INTO
69: l_oat_rec.ID,
70: l_oat_rec.OCE_ID,
71: l_oat_rec.PDP_ID,

Line 68: FETCH okc_outcome_arguments_pk_csr INTO

64: BEGIN
65: x_no_data_found := TRUE;
66: -- Get current database values
67: OPEN okc_outcome_arguments_pk_csr (p_oat_rec.id);
68: FETCH okc_outcome_arguments_pk_csr INTO
69: l_oat_rec.ID,
70: l_oat_rec.OCE_ID,
71: l_oat_rec.PDP_ID,
72: l_oat_rec.AAE_ID,

Line 83: x_no_data_found := okc_outcome_arguments_pk_csr%NOTFOUND;

79: l_oat_rec.VALUE,
80: l_oat_rec.LAST_UPDATE_LOGIN,
81: l_oat_rec.APPLICATION_ID,
82: l_oat_rec.SEEDED_FLAG;
83: x_no_data_found := okc_outcome_arguments_pk_csr%NOTFOUND;
84: CLOSE okc_outcome_arguments_pk_csr;
85: RETURN(l_oat_rec);
86: END get_rec;
87:

Line 84: CLOSE okc_outcome_arguments_pk_csr;

80: l_oat_rec.LAST_UPDATE_LOGIN,
81: l_oat_rec.APPLICATION_ID,
82: l_oat_rec.SEEDED_FLAG;
83: x_no_data_found := okc_outcome_arguments_pk_csr%NOTFOUND;
84: CLOSE okc_outcome_arguments_pk_csr;
85: RETURN(l_oat_rec);
86: END get_rec;
87:
88: FUNCTION get_rec (

Line 96: -- FUNCTION get_rec for: OKC_OUTCOME_ARGUMENTS_V

92: BEGIN
93: RETURN(get_rec(p_oat_rec, l_row_notfound));
94: END get_rec;
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKC_OUTCOME_ARGUMENTS_V
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_oatv_rec IN oatv_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN

Line 118: FROM Okc_Outcome_Arguments_V

114: CREATION_DATE,
115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okc_Outcome_Arguments_V
119: WHERE okc_outcome_arguments_v.id = p_id;
120: l_okc_oatv_pk okc_oatv_pk_csr%ROWTYPE;
121: l_oatv_rec oatv_rec_type;
122: BEGIN

Line 119: WHERE okc_outcome_arguments_v.id = p_id;

115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okc_Outcome_Arguments_V
119: WHERE okc_outcome_arguments_v.id = p_id;
120: l_okc_oatv_pk okc_oatv_pk_csr%ROWTYPE;
121: l_oatv_rec oatv_rec_type;
122: BEGIN
123: x_no_data_found := TRUE;

Line 155: -- FUNCTION null_out_defaults for: OKC_OUTCOME_ARGUMENTS_V --

151: RETURN(get_rec(p_oatv_rec, l_row_notfound));
152: END get_rec;
153:
154: -------------------------------------------------------------
155: -- FUNCTION null_out_defaults for: OKC_OUTCOME_ARGUMENTS_V --
156: -------------------------------------------------------------
157: FUNCTION null_out_defaults (
158: p_oatv_rec IN oatv_rec_type
159: ) RETURN oatv_rec_type IS

Line 209: -- Validate_Attributes for:OKC_OUTCOME_ARGUMENTS_V --

205: ---------------------------------------------------------------------------
206: -- PROCEDURE Validate_Attributes
207: ---------------------------------------------------------------------------
208: -----------------------------------------------------
209: -- Validate_Attributes for:OKC_OUTCOME_ARGUMENTS_V --
210: -----------------------------------------------------
211: FUNCTION Validate_Attributes (
212: p_oatv_rec IN oatv_rec_type
213: ) RETURN VARCHAR2 IS

Line 244: -- Validate_Record for:OKC_OUTCOME_ARGUMENTS_V --

240: ---------------------------------------------------------------------------
241: -- PROCEDURE Validate_Record
242: ---------------------------------------------------------------------------
243: -------------------------------------------------
244: -- Validate_Record for:OKC_OUTCOME_ARGUMENTS_V --
245: -------------------------------------------------
246: FUNCTION Validate_Record (
247: p_oatv_rec IN oatv_rec_type
248: ) RETURN VARCHAR2 IS

Line 411: -- Validate_Attributes for:OKC_OUTCOME_ARGUMENTS_V --

407: ---------------------------------------------------------------------------
408: -- PROCEDURE Validate_Attributes
409: ---------------------------------------------------------------------------
410: -----------------------------------------------------
411: -- Validate_Attributes for:OKC_OUTCOME_ARGUMENTS_V --
412: -----------------------------------------------------
413: -- Start of comments
414: -- Procedure Name : validate_object_version_number
415: -- Description : Check if object_version_number is null

Line 677: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',

673: p_msg_name => g_no_parent_record,
674: p_token1 => g_col_name_token,
675: p_token1_value => 'oce_id',
676: p_token2 => g_child_table_token,
677: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
678: p_token3 => g_parent_table_token,
679: p_token3_value => 'OKC_OUTCOMES_V');
680: x_return_status := OKC_API.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 738: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',

734: p_msg_name => g_no_parent_record,
735: p_token1 => g_col_name_token,
736: p_token1_value => 'aae_id',
737: p_token2 => g_child_table_token,
738: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
739: p_token3 => g_parent_table_token,
740: p_token3_value => 'OKC_ACTION_ATTRIBUTES_V');
741: x_return_status := OKC_API.G_RET_STS_ERROR;
742: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 871: -- Validate_Record for:OKC_OUTCOME_ARGUMENTS_V --

867: ---------------------------------------------------------------------------
868: -- PROCEDURE Validate_Record
869: ---------------------------------------------------------------------------
870: -------------------------------------------------
871: -- Validate_Record for:OKC_OUTCOME_ARGUMENTS_V --
872: -------------------------------------------------
873: -- Start of comments
874: -- Procedure Name : validate_aaeid_value
875: -- Description : Check if one of this aae_id or value has value

Line 1222: -- validate_row for:OKC_OUTCOME_ARGUMENTS_V --

1218: ---------------------------------------------------------------------------
1219: -- PROCEDURE validate_row
1220: ---------------------------------------------------------------------------
1221: ----------------------------------------------
1222: -- validate_row for:OKC_OUTCOME_ARGUMENTS_V --
1223: ----------------------------------------------
1224: PROCEDURE validate_row(
1225: p_api_version IN NUMBER,
1226: p_init_msg_list IN VARCHAR2 ,

Line 1366: -- insert_row for:OKC_OUTCOME_ARGUMENTS --

1362: ---------------------------------------------------------------------------
1363: -- PROCEDURE insert_row
1364: ---------------------------------------------------------------------------
1365: ------------------------------------------
1366: -- insert_row for:OKC_OUTCOME_ARGUMENTS --
1367: ------------------------------------------
1368: PROCEDURE insert_row(
1369: p_init_msg_list IN VARCHAR2 ,
1370: x_return_status OUT NOCOPY VARCHAR2,

Line 1382: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS --

1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1379: l_oat_rec oat_rec_type := p_oat_rec;
1380: l_def_oat_rec oat_rec_type;
1381: ----------------------------------------------
1382: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS --
1383: ----------------------------------------------
1384: FUNCTION Set_Attributes (
1385: p_oat_rec IN oat_rec_type,
1386: x_oat_rec OUT NOCOPY oat_rec_type

Line 1413: INSERT INTO OKC_OUTCOME_ARGUMENTS(

1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: INSERT INTO OKC_OUTCOME_ARGUMENTS(
1414: id,
1415: oce_id,
1416: pdp_id,
1417: aae_id,

Line 1479: -- insert_row for:OKC_OUTCOME_ARGUMENTS_V --

1475: '_PVT'
1476: );
1477: END insert_row;
1478: --------------------------------------------
1479: -- insert_row for:OKC_OUTCOME_ARGUMENTS_V --
1480: --------------------------------------------
1481: PROCEDURE insert_row(
1482: p_api_version IN NUMBER,
1483: p_init_msg_list IN VARCHAR2 ,

Line 1514: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS_V --

1510: l_oatv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1511: RETURN(l_oatv_rec);
1512: END fill_who_columns;
1513: ------------------------------------------------
1514: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS_V --
1515: ------------------------------------------------
1516: FUNCTION Set_Attributes (
1517: p_oatv_rec IN oatv_rec_type,
1518: x_oatv_rec OUT NOCOPY oatv_rec_type

Line 1543: SELECT OKC_OUTCOME_ARGUMENTS_S1.nextval INTO l_id FROM dual;

1539: l_oatv_rec := null_out_defaults(p_oatv_rec);
1540: -- Set primary key value
1541: -- If outcome argument is created by seed then use sequence generated id
1542: IF l_oatv_rec.CREATED_BY = 1 THEN
1543: SELECT OKC_OUTCOME_ARGUMENTS_S1.nextval INTO l_id FROM dual;
1544: l_oatv_rec.ID := l_id;
1545: l_oatv_rec.seeded_flag := 'Y';
1546: ELSE
1547: l_oatv_rec.ID := get_seq_id;

Line 1704: -- lock_row for:OKC_OUTCOME_ARGUMENTS --

1700: ---------------------------------------------------------------------------
1701: -- PROCEDURE lock_row
1702: ---------------------------------------------------------------------------
1703: ----------------------------------------
1704: -- lock_row for:OKC_OUTCOME_ARGUMENTS --
1705: ----------------------------------------
1706: PROCEDURE lock_row(
1707: p_init_msg_list IN VARCHAR2 ,
1708: x_return_status OUT NOCOPY VARCHAR2,

Line 1717: FROM OKC_OUTCOME_ARGUMENTS

1713: E_Resource_Busy EXCEPTION;
1714: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1715: CURSOR lock_csr (p_oat_rec IN oat_rec_type) IS
1716: SELECT OBJECT_VERSION_NUMBER
1717: FROM OKC_OUTCOME_ARGUMENTS
1718: WHERE ID = p_oat_rec.id
1719: AND OBJECT_VERSION_NUMBER = p_oat_rec.object_version_number
1720: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1721:

Line 1724: FROM OKC_OUTCOME_ARGUMENTS

1720: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1721:
1722: CURSOR lchk_csr (p_oat_rec IN oat_rec_type) IS
1723: SELECT OBJECT_VERSION_NUMBER
1724: FROM OKC_OUTCOME_ARGUMENTS
1725: WHERE ID = p_oat_rec.id;
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_lock_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1729: l_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;

1725: WHERE ID = p_oat_rec.id;
1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_lock_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1729: l_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1730: lc_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1731: l_row_notfound BOOLEAN := FALSE;
1732: lc_row_notfound BOOLEAN := FALSE;
1733: BEGIN

Line 1730: lc_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;

1726: l_api_version CONSTANT NUMBER := 1;
1727: l_api_name CONSTANT VARCHAR2(30) := 'ARGUMENTS_lock_row';
1728: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1729: l_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1730: lc_object_version_number OKC_OUTCOME_ARGUMENTS.OBJECT_VERSION_NUMBER%TYPE;
1731: l_row_notfound BOOLEAN := FALSE;
1732: lc_row_notfound BOOLEAN := FALSE;
1733: BEGIN
1734: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1810: -- lock_row for:OKC_OUTCOME_ARGUMENTS_V --

1806: '_PVT'
1807: );
1808: END lock_row;
1809: ------------------------------------------
1810: -- lock_row for:OKC_OUTCOME_ARGUMENTS_V --
1811: ------------------------------------------
1812: PROCEDURE lock_row(
1813: p_api_version IN NUMBER,
1814: p_init_msg_list IN VARCHAR2 ,

Line 1958: -- update_row for:OKC_OUTCOME_ARGUMENTS --

1954: ---------------------------------------------------------------------------
1955: -- PROCEDURE update_row
1956: ---------------------------------------------------------------------------
1957: ------------------------------------------
1958: -- update_row for:OKC_OUTCOME_ARGUMENTS --
1959: ------------------------------------------
1960: PROCEDURE update_row(
1961: p_init_msg_list IN VARCHAR2 ,
1962: x_return_status OUT NOCOPY VARCHAR2,

Line 2050: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS --

2046: END IF;
2047: RETURN(l_return_status);
2048: END populate_new_record;
2049: ----------------------------------------------
2050: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS --
2051: ----------------------------------------------
2052: FUNCTION Set_Attributes (
2053: p_oat_rec IN oat_rec_type,
2054: x_oat_rec OUT NOCOPY oat_rec_type

Line 2087: UPDATE OKC_OUTCOME_ARGUMENTS

2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: UPDATE OKC_OUTCOME_ARGUMENTS
2088: SET OCE_ID = l_def_oat_rec.oce_id,
2089: PDP_ID = l_def_oat_rec.pdp_id,
2090: AAE_ID = l_def_oat_rec.aae_id,
2091: DNZ_CHR_ID = l_def_oat_rec.dnz_chr_id,

Line 2138: -- update_row for:OKC_OUTCOME_ARGUMENTS_V --

2134: '_PVT'
2135: );
2136: END update_row;
2137: --------------------------------------------
2138: -- update_row for:OKC_OUTCOME_ARGUMENTS_V --
2139: --------------------------------------------
2140: PROCEDURE update_row(
2141: p_api_version IN NUMBER,
2142: p_init_msg_list IN VARCHAR2 ,

Line 2245: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS_V --

2241: END IF;
2242: RETURN(l_return_status);
2243: END populate_new_record;
2244: ------------------------------------------------
2245: -- Set_Attributes for:OKC_OUTCOME_ARGUMENTS_V --
2246: ------------------------------------------------
2247: FUNCTION Set_Attributes (
2248: p_oatv_rec IN oatv_rec_type,
2249: x_oatv_rec OUT NOCOPY oatv_rec_type

Line 2436: -- delete_row for:OKC_OUTCOME_ARGUMENTS --

2432: ---------------------------------------------------------------------------
2433: -- PROCEDURE delete_row
2434: ---------------------------------------------------------------------------
2435: ------------------------------------------
2436: -- delete_row for:OKC_OUTCOME_ARGUMENTS --
2437: ------------------------------------------
2438: PROCEDURE delete_row(
2439: p_init_msg_list IN VARCHAR2 ,
2440: x_return_status OUT NOCOPY VARCHAR2,

Line 2460: DELETE FROM OKC_OUTCOME_ARGUMENTS

2456: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2457: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2458: RAISE OKC_API.G_EXCEPTION_ERROR;
2459: END IF;
2460: DELETE FROM OKC_OUTCOME_ARGUMENTS
2461: WHERE ID = l_oat_rec.id;
2462:
2463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2464: EXCEPTION

Line 2497: -- delete_row for:OKC_OUTCOME_ARGUMENTS_V --

2493: '_PVT'
2494: );
2495: END delete_row;
2496: --------------------------------------------
2497: -- delete_row for:OKC_OUTCOME_ARGUMENTS_V --
2498: --------------------------------------------
2499: PROCEDURE delete_row(
2500: p_api_version IN NUMBER,
2501: p_init_msg_list IN VARCHAR2 ,

Line 2651: -- Procedure for mass insert in OKC_OUTCOME_ARGUMENTS _B and TL tables

2647: );
2648: END delete_row;
2649:
2650: ---------------------------------------------------------------
2651: -- Procedure for mass insert in OKC_OUTCOME_ARGUMENTS _B and TL tables
2652: ---------------------------------------------------------------
2653: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_oatv_tbl oatv_tbl_type) IS
2654: l_tabsize NUMBER := p_oatv_tbl.COUNT;
2655: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 2699: INTO OKC_OUTCOME_ARGUMENTS

2695: END LOOP;
2696:
2697: FORALL i in 1..l_tabsize
2698: INSERT
2699: INTO OKC_OUTCOME_ARGUMENTS
2700: (
2701: id,
2702: oce_id,
2703: pdp_id,

Line 2760: INSERT INTO okc_outcome_arguments_h

2756:
2757: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2758:
2759: BEGIN
2760: INSERT INTO okc_outcome_arguments_h
2761: (
2762: major_version,
2763: id,
2764: oce_id,

Line 2794: FROM okc_outcome_arguments

2790: value,
2791: last_update_login,
2792: application_id,
2793: seeded_flag
2794: FROM okc_outcome_arguments
2795: WHERE dnz_chr_id = p_chr_id;
2796:
2797: RETURN l_return_status;
2798: EXCEPTION

Line 2826: INSERT INTO okc_outcome_arguments

2822:
2823: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2824:
2825: BEGIN
2826: INSERT INTO okc_outcome_arguments
2827: (
2828: id,
2829: oce_id,
2830: pdp_id,

Line 2858: FROM okc_outcome_arguments_h

2854: value,
2855: last_update_login,
2856: application_id,
2857: seeded_flag
2858: FROM okc_outcome_arguments_h
2859: WHERE dnz_chr_id = p_chr_id
2860: AND major_version = p_major_version;
2861:
2862: RETURN l_return_status;