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.OKL_ALS_PVT dependencies on OKL_AG_SOURCE_MAPS

Line 26: FROM OKL_AG_SOURCE_MAPS

22:
23: CURSOR l_unique_csr
24: IS
25: SELECT '1'
26: FROM OKL_AG_SOURCE_MAPS
27: WHERE ae_line_type = p_alsv_rec.ae_line_type
28: AND source = p_alsv_rec.source
29: AND ID <> p_alsv_rec.id;
30:

Line 90: -- FUNCTION get_rec for: OKL_AG_SOURCE_MAPS

86: NULL;
87: END api_copy;
88:
89: ---------------------------------------------------------------------------
90: -- FUNCTION get_rec for: OKL_AG_SOURCE_MAPS
91: ---------------------------------------------------------------------------
92: FUNCTION get_rec (
93: p_ALS_rec IN ALS_rec_type,
94: x_no_data_found OUT NOCOPY BOOLEAN

Line 96: CURSOR OKL_AG_SOURCE_MAPS_pk_csr (p_id IN NUMBER) IS

92: FUNCTION get_rec (
93: p_ALS_rec IN ALS_rec_type,
94: x_no_data_found OUT NOCOPY BOOLEAN
95: ) RETURN ALS_rec_type IS
96: CURSOR OKL_AG_SOURCE_MAPS_pk_csr (p_id IN NUMBER) IS
97: SELECT
98: ID,
99: OBJECT_VERSION_NUMBER,
100: ORG_ID,

Line 110: FROM OKL_AG_SOURCE_MAPS

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM OKL_AG_SOURCE_MAPS
111: WHERE OKL_AG_SOURCE_MAPS.id = p_id;
112: l_OKL_AG_SOURCE_MAPS_pk OKL_AG_SOURCE_MAPS_pk_csr%ROWTYPE;
113: l_ALS_rec ALS_rec_type;
114: BEGIN

Line 111: WHERE OKL_AG_SOURCE_MAPS.id = p_id;

107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM OKL_AG_SOURCE_MAPS
111: WHERE OKL_AG_SOURCE_MAPS.id = p_id;
112: l_OKL_AG_SOURCE_MAPS_pk OKL_AG_SOURCE_MAPS_pk_csr%ROWTYPE;
113: l_ALS_rec ALS_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;

Line 112: l_OKL_AG_SOURCE_MAPS_pk OKL_AG_SOURCE_MAPS_pk_csr%ROWTYPE;

108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM OKL_AG_SOURCE_MAPS
111: WHERE OKL_AG_SOURCE_MAPS.id = p_id;
112: l_OKL_AG_SOURCE_MAPS_pk OKL_AG_SOURCE_MAPS_pk_csr%ROWTYPE;
113: l_ALS_rec ALS_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values

Line 117: OPEN OKL_AG_SOURCE_MAPS_pk_csr (p_ALS_rec.id);

113: l_ALS_rec ALS_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values
117: OPEN OKL_AG_SOURCE_MAPS_pk_csr (p_ALS_rec.id);
118: FETCH OKL_AG_SOURCE_MAPS_pk_csr INTO
119: l_ALS_rec.ID,
120: l_ALS_rec.OBJECT_VERSION_NUMBER,
121: l_ALS_rec.ORG_ID,

Line 118: FETCH OKL_AG_SOURCE_MAPS_pk_csr INTO

114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values
117: OPEN OKL_AG_SOURCE_MAPS_pk_csr (p_ALS_rec.id);
118: FETCH OKL_AG_SOURCE_MAPS_pk_csr INTO
119: l_ALS_rec.ID,
120: l_ALS_rec.OBJECT_VERSION_NUMBER,
121: l_ALS_rec.ORG_ID,
122: l_ALS_rec.AE_LINE_TYPE,

Line 131: x_no_data_found := OKL_AG_SOURCE_MAPS_pk_csr%NOTFOUND;

127: l_ALS_rec.CREATION_DATE,
128: l_ALS_rec.LAST_UPDATED_BY,
129: l_ALS_rec.LAST_UPDATE_DATE,
130: l_ALS_rec.LAST_UPDATE_LOGIN;
131: x_no_data_found := OKL_AG_SOURCE_MAPS_pk_csr%NOTFOUND;
132: CLOSE OKL_AG_SOURCE_MAPS_pk_csr;
133: RETURN(l_ALS_rec);
134: END get_rec;
135:

Line 132: CLOSE OKL_AG_SOURCE_MAPS_pk_csr;

128: l_ALS_rec.LAST_UPDATED_BY,
129: l_ALS_rec.LAST_UPDATE_DATE,
130: l_ALS_rec.LAST_UPDATE_LOGIN;
131: x_no_data_found := OKL_AG_SOURCE_MAPS_pk_csr%NOTFOUND;
132: CLOSE OKL_AG_SOURCE_MAPS_pk_csr;
133: RETURN(l_ALS_rec);
134: END get_rec;
135:
136: FUNCTION get_rec (

Line 144: -- FUNCTION get_rec for: OKL_AG_SOURCE_MAPS_V

140: BEGIN
141: RETURN(get_rec(p_ALS_rec, l_row_notfound));
142: END get_rec;
143: ---------------------------------------------------------------------------
144: -- FUNCTION get_rec for: OKL_AG_SOURCE_MAPS_V
145: ---------------------------------------------------------------------------
146: FUNCTION get_rec (
147: p_ALSv_rec IN ALSv_rec_type,
148: x_no_data_found OUT NOCOPY BOOLEAN

Line 164: FROM OKL_AG_SOURCE_MAPS

160: CREATION_DATE,
161: LAST_UPDATED_BY,
162: LAST_UPDATE_DATE,
163: LAST_UPDATE_LOGIN
164: FROM OKL_AG_SOURCE_MAPS
165: WHERE OKL_AG_SOURCE_MAPS.id = p_id;
166: l_okl_ALSv_pk okl_ALSv_pk_csr%ROWTYPE;
167: l_ALSv_rec ALSv_rec_type;
168: BEGIN

Line 165: WHERE OKL_AG_SOURCE_MAPS.id = p_id;

161: LAST_UPDATED_BY,
162: LAST_UPDATE_DATE,
163: LAST_UPDATE_LOGIN
164: FROM OKL_AG_SOURCE_MAPS
165: WHERE OKL_AG_SOURCE_MAPS.id = p_id;
166: l_okl_ALSv_pk okl_ALSv_pk_csr%ROWTYPE;
167: l_ALSv_rec ALSv_rec_type;
168: BEGIN
169: x_no_data_found := TRUE;

Line 199: -- FUNCTION null_out_defaults for: OKL_AG_SOURCE_MAPS_V --

195: RETURN(get_rec(p_ALSv_rec, l_row_notfound));
196: END get_rec;
197:
198: --------------------------------------------------------
199: -- FUNCTION null_out_defaults for: OKL_AG_SOURCE_MAPS_V --
200: --------------------------------------------------------
201: FUNCTION null_out_defaults (
202: p_ALSv_rec IN ALSv_rec_type
203: ) RETURN ALSv_rec_type IS

Line 245: -- Validate_Attributes for:OKL_AG_SOURCE_MAPS_V --

241: ---------------------------------------------------------------------------
242: -- PROCEDURE Validate_Attributes
243: ---------------------------------------------------------------------------
244: ------------------------------------------------
245: -- Validate_Attributes for:OKL_AG_SOURCE_MAPS_V --
246: ------------------------------------------------
247: FUNCTION Validate_Attributes (
248: p_ALSv_rec IN ALSv_rec_type
249: ) RETURN VARCHAR2 IS

Line 305: -- Validate_Record for:OKL_AG_SOURCE_MAPS_V --

301: ---------------------------------------------------------------------------
302: -- PROCEDURE Validate_Record
303: ---------------------------------------------------------------------------
304: --------------------------------------------
305: -- Validate_Record for:OKL_AG_SOURCE_MAPS_V --
306: --------------------------------------------
307: FUNCTION Validate_Record (
308: p_ALSv_rec IN ALSv_rec_type
309: ) RETURN VARCHAR2 IS

Line 390: -- validate_row for:OKL_AG_SOURCE_MAPS_V --

386: ---------------------------------------------------------------------------
387: -- PROCEDURE validate_row
388: ---------------------------------------------------------------------------
389: -----------------------------------------
390: -- validate_row for:OKL_AG_SOURCE_MAPS_V --
391: -----------------------------------------
392: PROCEDURE validate_row(
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 541: -- insert_row for:OKL_AG_SOURCE_MAPS --

537: ---------------------------------------------------------------------------
538: -- PROCEDURE insert_row
539: ---------------------------------------------------------------------------
540: -------------------------------------
541: -- insert_row for:OKL_AG_SOURCE_MAPS --
542: -------------------------------------
543: PROCEDURE insert_row(
544: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
545: x_return_status OUT NOCOPY VARCHAR2,

Line 557: -- Set_Attributes for:OKL_AG_SOURCE_MAPS --

553: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
554: l_ALS_rec ALS_rec_type := p_ALS_rec;
555: l_def_ALS_rec ALS_rec_type;
556: -----------------------------------------
557: -- Set_Attributes for:OKL_AG_SOURCE_MAPS --
558: -----------------------------------------
559:
560: FUNCTION Set_Attributes (
561: p_ALS_rec IN ALS_rec_type,

Line 596: INSERT INTO OKL_AG_SOURCE_MAPS(

592:
593: l_als_rec.primary_key_column := 'DEFAULT';
594:
595:
596: INSERT INTO OKL_AG_SOURCE_MAPS(
597: id,
598: object_version_number,
599: org_id,
600: AE_LINE_TYPE,

Line 658: -- insert_row for:OKL_AG_SOURCE_MAPS_V --

654: '_PVT'
655: );
656: END insert_row;
657: ---------------------------------------
658: -- insert_row for:OKL_AG_SOURCE_MAPS_V --
659: ---------------------------------------
660: PROCEDURE insert_row(
661: p_api_version IN NUMBER,
662: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 692: -- Set_Attributes for:OKL_AG_SOURCE_MAPS_V --

688: l_ALSv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
689: RETURN(l_ALSv_rec);
690: END fill_who_columns;
691: -------------------------------------------
692: -- Set_Attributes for:OKL_AG_SOURCE_MAPS_V --
693: -------------------------------------------
694: FUNCTION Set_Attributes (
695: p_ALSv_rec IN ALSv_rec_type,
696: x_ALSv_rec OUT NOCOPY ALSv_rec_type

Line 881: -- lock_row for:OKL_AG_SOURCE_MAPS --

877: ---------------------------------------------------------------------------
878: -- PROCEDURE lock_row
879: ---------------------------------------------------------------------------
880: -----------------------------------
881: -- lock_row for:OKL_AG_SOURCE_MAPS --
882: -----------------------------------
883: PROCEDURE lock_row(
884: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
885: x_return_status OUT NOCOPY VARCHAR2,

Line 894: FROM OKL_AG_SOURCE_MAPS

890: E_Resource_Busy EXCEPTION;
891: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
892: CURSOR lock_csr (p_ALS_rec IN ALS_rec_type) IS
893: SELECT OBJECT_VERSION_NUMBER
894: FROM OKL_AG_SOURCE_MAPS
895: WHERE ID = p_ALS_rec.id
896: AND OBJECT_VERSION_NUMBER = p_ALS_rec.object_version_number
897: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
898:

Line 901: FROM OKL_AG_SOURCE_MAPS

897: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
898:
899: CURSOR lchk_csr (p_ALS_rec IN ALS_rec_type) IS
900: SELECT OBJECT_VERSION_NUMBER
901: FROM OKL_AG_SOURCE_MAPS
902: WHERE ID = p_ALS_rec.id;
903: l_api_version CONSTANT NUMBER := 1;
904: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
905: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 906: l_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;

902: WHERE ID = p_ALS_rec.id;
903: l_api_version CONSTANT NUMBER := 1;
904: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
905: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
906: l_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;
907: lc_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;
908: l_row_notfound BOOLEAN := FALSE;
909: lc_row_notfound BOOLEAN := FALSE;
910: BEGIN

Line 907: lc_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;

903: l_api_version CONSTANT NUMBER := 1;
904: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
905: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
906: l_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;
907: lc_object_version_number OKL_AG_SOURCE_MAPS.OBJECT_VERSION_NUMBER%TYPE;
908: l_row_notfound BOOLEAN := FALSE;
909: lc_row_notfound BOOLEAN := FALSE;
910: BEGIN
911: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 987: -- lock_row for:OKL_AG_SOURCE_MAPS_V --

983: '_PVT'
984: );
985: END lock_row;
986: -------------------------------------
987: -- lock_row for:OKL_AG_SOURCE_MAPS_V --
988: -------------------------------------
989: PROCEDURE lock_row(
990: p_api_version IN NUMBER,
991: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1142: -- update_row for:OKL_AG_SOURCE_MAPS --

1138: ---------------------------------------------------------------------------
1139: -- PROCEDURE update_row
1140: ---------------------------------------------------------------------------
1141: -------------------------------------
1142: -- update_row for:OKL_AG_SOURCE_MAPS --
1143: -------------------------------------
1144: PROCEDURE update_row(
1145: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1146: x_return_status OUT NOCOPY VARCHAR2,

Line 1226: -- Set_Attributes for:OKL_AG_SOURCE_MAPS --

1222: END IF;
1223: RETURN(l_return_status);
1224: END populate_new_record;
1225: -----------------------------------------
1226: -- Set_Attributes for:OKL_AG_SOURCE_MAPS --
1227: -----------------------------------------
1228: FUNCTION Set_Attributes (
1229: p_ALS_rec IN ALS_rec_type,
1230: x_ALS_rec OUT NOCOPY ALS_rec_type

Line 1264: UPDATE OKL_AG_SOURCE_MAPS

1260: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1262: RAISE okl_api.G_EXCEPTION_ERROR;
1263: END IF;
1264: UPDATE OKL_AG_SOURCE_MAPS
1265: SET OBJECT_VERSION_NUMBER = l_def_ALS_rec.object_version_number,
1266: ORG_ID = l_def_ALS_rec.org_id,
1267: AE_LINE_TYPE = l_def_ALS_rec.AE_LINE_TYPE,
1268: SOURCE = l_def_ALS_rec.SOURCE,

Line 1313: -- update_row for:OKL_AG_SOURCE_MAPS_V --

1309: '_PVT'
1310: );
1311: END update_row;
1312: ---------------------------------------
1313: -- update_row for:OKL_AG_SOURCE_MAPS_V --
1314: ---------------------------------------
1315: PROCEDURE update_row(
1316: p_api_version IN NUMBER,
1317: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1412: -- Set_Attributes for:OKL_AG_SOURCE_MAPS_V --

1408: END IF;
1409: RETURN(l_return_status);
1410: END populate_new_record;
1411: -------------------------------------------
1412: -- Set_Attributes for:OKL_AG_SOURCE_MAPS_V --
1413: -------------------------------------------
1414: FUNCTION Set_Attributes (
1415: p_ALSv_rec IN ALSv_rec_type,
1416: x_ALSv_rec OUT NOCOPY ALSv_rec_type

Line 1592: -- delete_row for:OKL_AG_SOURCE_MAPS --

1588: ---------------------------------------------------------------------------
1589: -- PROCEDURE delete_row
1590: ---------------------------------------------------------------------------
1591: -------------------------------------
1592: -- delete_row for:OKL_AG_SOURCE_MAPS --
1593: -------------------------------------
1594: PROCEDURE delete_row(
1595: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1596: x_return_status OUT NOCOPY VARCHAR2,

Line 1616: DELETE FROM OKL_AG_SOURCE_MAPS

1612: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1614: RAISE okl_api.G_EXCEPTION_ERROR;
1615: END IF;
1616: DELETE FROM OKL_AG_SOURCE_MAPS
1617: WHERE ID = l_ALS_rec.id;
1618:
1619: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1620: EXCEPTION

Line 1653: -- delete_row for:OKL_AG_SOURCE_MAPS_V --

1649: '_PVT'
1650: );
1651: END delete_row;
1652: ---------------------------------------
1653: -- delete_row for:OKL_AG_SOURCE_MAPS_V --
1654: ---------------------------------------
1655: PROCEDURE delete_row(
1656: p_api_version IN NUMBER,
1657: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,