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_IRH_PVT dependencies on OKL_FE_ITEM_RESIDUAL

Line 21: -- Procedure get_rec for OKL_FE_ITEM_RESIDUAL_ALL

17: null;
18: END change_version;
19:
20: --------------------------------------------------------------------------------
21: -- Procedure get_rec for OKL_FE_ITEM_RESIDUAL_ALL
22: --------------------------------------------------------------------------------
23:
24: FUNCTION get_rec(
25: p_irh_rec IN okl_irh_rec,

Line 50: FROM OKL_FE_ITEM_RESIDUAL_ALL WHERE OKL_FE_ITEM_RESIDUAL_ALL.item_residual_id=p_id;

46: STS_CODE,
47: EFFECTIVE_FROM_DATE,
48: EFFECTIVE_TO_DATE,
49: ORG_ID
50: FROM OKL_FE_ITEM_RESIDUAL_ALL WHERE OKL_FE_ITEM_RESIDUAL_ALL.item_residual_id=p_id;
51: l_irh_pk irh_pk_csr%ROWTYPE;
52: l_irh_rec okl_irh_rec;
53: BEGIN
54: x_no_data_found:= TRUE;

Line 91: -- Procedure get_rec for OKL_FE_ITEM_RESIDUAL

87: RETURN(get_rec(p_irh_rec,l_row_notfound));
88: END get_rec;
89:
90: --------------------------------------------------------------------------------
91: -- Procedure get_rec for OKL_FE_ITEM_RESIDUAL
92: --------------------------------------------------------------------------------
93:
94: FUNCTION get_rec(
95: p_irhv_rec IN okl_irhv_rec,

Line 121: OKL_FE_ITEM_RESIDUAL_ALL IRH

117: , EFFECTIVE_FROM_DATE
118: , EFFECTIVE_TO_DATE
119: , ORG_ID
120: FROM
121: OKL_FE_ITEM_RESIDUAL_ALL IRH
122: WHERE
123: IRH.ITEM_RESIDUAL_ID = p_id;
124: l_irhv_pk irhv_pk_csr%ROWTYPE;
125: l_irhv_rec okl_irhv_rec;

Line 682: OKL_FE_ITEM_RESIDUAL IRHV

678: CURSOR get_residual_items (p_inventory_item_id NUMBER, p_organization_id NUMBER, p_category_set_id NUMBER, p_residual_type_code VARCHAR2, p_currency_code VARCHAR2) IS
679: SELECT
680: IRHV.ITEM_RESIDUAL_ID
681: FROM
682: OKL_FE_ITEM_RESIDUAL IRHV
683: -- , OKL_SYSTEM_PARAMS_ALL_V SYSOP
684: WHERE
685: IRHV.INVENTORY_ITEM_ID = p_inventory_item_id
686: AND IRHV.ORGANIZATION_ID = p_organization_id

Line 700: OKL_FE_ITEM_RESIDUAL IRHV

696: CURSOR get_residual_categories (p_category_id NUMBER, p_category_set_id NUMBER, p_residual_type_code VARCHAR2, p_currency_code VARCHAR2) IS
697: SELECT
698: IRHV.ITEM_RESIDUAL_ID
699: FROM
700: OKL_FE_ITEM_RESIDUAL IRHV
701: -- , OKL_SYSTEM_PARAMS_ALL_V SYSOP
702: WHERE
703: IRHV.CATEGORY_ID = p_category_id
704: AND IRHV.CATEGORY_SET_ID = p_category_set_id

Line 717: OKL_FE_ITEM_RESIDUAL IRHV

713: CURSOR get_residual_rcs ( p_resi_category_set_id NUMBER, p_residual_type_code VARCHAR2, p_currency_code VARCHAR2) IS
714: SELECT
715: IRHV.ITEM_RESIDUAL_ID
716: FROM
717: OKL_FE_ITEM_RESIDUAL IRHV
718: -- , OKL_SYSTEM_PARAMS_ALL_V SYSOP
719: WHERE
720: IRHV.RESI_CATEGORY_SET_ID = p_resi_category_set_id
721: AND IRHV.RESIDUAL_TYPE_CODE = p_residual_type_code

Line 841: INSERT INTO OKL_FE_ITEM_RESIDUAL_ALL(

837: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
838: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
839: RAISE OKL_API.G_EXCEPTION_ERROR;
840: END IF;
841: INSERT INTO OKL_FE_ITEM_RESIDUAL_ALL(
842: ITEM_RESIDUAL_ID,
843: ORIG_ITEM_RESIDUAL_ID,
844: OBJECT_VERSION_NUMBER,
845: CREATED_BY,

Line 1174: FROM OKL_FE_ITEM_RESIDUAL_ALL

1170: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1171:
1172: CURSOR lock_csr (p_def_irh_rec IN okl_irh_rec) IS
1173: SELECT OBJECT_VERSION_NUMBER
1174: FROM OKL_FE_ITEM_RESIDUAL_ALL
1175: WHERE ITEM_RESIDUAL_ID = p_def_irh_rec.item_residual_id
1176: AND OBJECT_VERSION_NUMBER = p_def_irh_rec.object_version_number
1177: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1178:

Line 1181: FROM OKL_FE_ITEM_RESIDUAL_ALL

1177: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1178:
1179: CURSOR lchk_csr (p_def_irh_rec IN okl_irh_rec) IS
1180: SELECT OBJECT_VERSION_NUMBER
1181: FROM OKL_FE_ITEM_RESIDUAL_ALL
1182: WHERE item_residual_id = p_def_irh_rec.item_residual_id;
1183:
1184: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1185: l_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;

Line 1185: l_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;

1181: FROM OKL_FE_ITEM_RESIDUAL_ALL
1182: WHERE item_residual_id = p_def_irh_rec.item_residual_id;
1183:
1184: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1185: l_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;
1186: lc_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;
1187: l_row_notfound BOOLEAN := FALSE;
1188: lc_row_notfound BOOLEAN := FALSE;
1189:

Line 1186: lc_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;

1182: WHERE item_residual_id = p_def_irh_rec.item_residual_id;
1183:
1184: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1185: l_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;
1186: lc_object_version_number OKL_FE_ITEM_RESIDUAL_ALL.OBJECT_VERSION_NUMBER%TYPE;
1187: l_row_notfound BOOLEAN := FALSE;
1188: lc_row_notfound BOOLEAN := FALSE;
1189:
1190: BEGIN

Line 1392: UPDATE OKL_FE_ITEM_RESIDUAL_ALL

1388: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1389: RAISE OKL_API.G_EXCEPTION_ERROR;
1390: END IF;
1391:
1392: UPDATE OKL_FE_ITEM_RESIDUAL_ALL
1393: SET
1394: ITEM_RESIDUAL_ID= l_def_irh_rec.ITEM_RESIDUAL_ID,
1395: ORIG_ITEM_RESIDUAL_ID = l_def_irh_rec.ORIG_ITEM_RESIDUAL_ID,
1396: OBJECT_VERSION_NUMBER= l_def_irh_rec.OBJECT_VERSION_NUMBER+1,

Line 1810: DELETE FROM OKL_FE_ITEM_RESIDUAL_ALL

1806: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1807: RAISE OKL_API.G_EXCEPTION_ERROR;
1808: END IF;
1809:
1810: DELETE FROM OKL_FE_ITEM_RESIDUAL_ALL
1811: WHERE ITEM_RESIDUAL_ID=l_irh_rec.item_residual_id;
1812:
1813: EXCEPTION
1814: WHEN G_EXCEPTION_HALT_VALIDATION then