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_RPC_PVT dependencies on OKL_REPAIR_COSTS_B

Line 768: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_B

764: BEGIN
765: RETURN(get_rec(p_okl_repair_costs_tl_rec, l_row_notfound));
766: END get_rec;
767: ---------------------------------------------------------------------------
768: -- FUNCTION get_rec for: OKL_REPAIR_COSTS_B
769: ---------------------------------------------------------------------------
770: -- Start of comments
771: --
772: -- Function Name : get_rec

Line 773: -- Description : for: OKL_REPAIR_COSTS_B

769: ---------------------------------------------------------------------------
770: -- Start of comments
771: --
772: -- Function Name : get_rec
773: -- Description : for: OKL_REPAIR_COSTS_B
774: -- Business Rules :
775: -- Parameters :
776: -- Version : 1.0
777: -- History : SPILLAIP 12-DEC-2002 2667636

Line 784: CURSOR okl_repair_costs_b_pk_csr (p_id IN NUMBER) IS

780: FUNCTION get_rec (
781: p_rpc_rec IN rpc_rec_type,
782: x_no_data_found OUT NOCOPY BOOLEAN
783: ) RETURN rpc_rec_type IS
784: CURSOR okl_repair_costs_b_pk_csr (p_id IN NUMBER) IS
785: SELECT
786: ID,
787: OBJECT_VERSION_NUMBER,
788: ENABLED_YN,

Line 803: FROM Okl_Repair_Costs_B

799: CURRENCY_CONVERSION_TYPE,
800: CURRENCY_CONVERSION_RATE,
801: CURRENCY_CONVERSION_DATE
802: -- SPILLAIP - 2667636 - End
803: FROM Okl_Repair_Costs_B
804: WHERE okl_repair_costs_b.id = p_id;
805: l_okl_repair_costs_b_pk okl_repair_costs_b_pk_csr%ROWTYPE;
806: l_rpc_rec rpc_rec_type;
807: BEGIN

Line 804: WHERE okl_repair_costs_b.id = p_id;

800: CURRENCY_CONVERSION_RATE,
801: CURRENCY_CONVERSION_DATE
802: -- SPILLAIP - 2667636 - End
803: FROM Okl_Repair_Costs_B
804: WHERE okl_repair_costs_b.id = p_id;
805: l_okl_repair_costs_b_pk okl_repair_costs_b_pk_csr%ROWTYPE;
806: l_rpc_rec rpc_rec_type;
807: BEGIN
808: x_no_data_found := TRUE;

Line 805: l_okl_repair_costs_b_pk okl_repair_costs_b_pk_csr%ROWTYPE;

801: CURRENCY_CONVERSION_DATE
802: -- SPILLAIP - 2667636 - End
803: FROM Okl_Repair_Costs_B
804: WHERE okl_repair_costs_b.id = p_id;
805: l_okl_repair_costs_b_pk okl_repair_costs_b_pk_csr%ROWTYPE;
806: l_rpc_rec rpc_rec_type;
807: BEGIN
808: x_no_data_found := TRUE;
809: -- Get current database values

Line 810: OPEN okl_repair_costs_b_pk_csr (p_rpc_rec.id);

806: l_rpc_rec rpc_rec_type;
807: BEGIN
808: x_no_data_found := TRUE;
809: -- Get current database values
810: OPEN okl_repair_costs_b_pk_csr (p_rpc_rec.id);
811: FETCH okl_repair_costs_b_pk_csr INTO
812: l_rpc_rec.ID,
813: l_rpc_rec.OBJECT_VERSION_NUMBER,
814: l_rpc_rec.ENABLED_YN,

Line 811: FETCH okl_repair_costs_b_pk_csr INTO

807: BEGIN
808: x_no_data_found := TRUE;
809: -- Get current database values
810: OPEN okl_repair_costs_b_pk_csr (p_rpc_rec.id);
811: FETCH okl_repair_costs_b_pk_csr INTO
812: l_rpc_rec.ID,
813: l_rpc_rec.OBJECT_VERSION_NUMBER,
814: l_rpc_rec.ENABLED_YN,
815: l_rpc_rec.ORG_ID,

Line 829: x_no_data_found := okl_repair_costs_b_pk_csr%NOTFOUND;

825: l_rpc_rec.CURRENCY_CONVERSION_TYPE,
826: l_rpc_rec.CURRENCY_CONVERSION_RATE,
827: l_rpc_rec.CURRENCY_CONVERSION_DATE;
828: -- SPILLAIP - 2667636 - End
829: x_no_data_found := okl_repair_costs_b_pk_csr%NOTFOUND;
830: CLOSE okl_repair_costs_b_pk_csr;
831: RETURN(l_rpc_rec);
832: END get_rec;
833:

Line 830: CLOSE okl_repair_costs_b_pk_csr;

826: l_rpc_rec.CURRENCY_CONVERSION_RATE,
827: l_rpc_rec.CURRENCY_CONVERSION_DATE;
828: -- SPILLAIP - 2667636 - End
829: x_no_data_found := okl_repair_costs_b_pk_csr%NOTFOUND;
830: CLOSE okl_repair_costs_b_pk_csr;
831: RETURN(l_rpc_rec);
832: END get_rec;
833:
834: FUNCTION get_rec (

Line 1573: -- insert_row for:OKL_REPAIR_COSTS_B --

1569: '_PVT'
1570: );
1571: END insert_row;
1572: ---------------------------------------
1573: -- insert_row for:OKL_REPAIR_COSTS_B --
1574: ---------------------------------------
1575: -- Start of comments
1576: --
1577: -- Procedure Name : insert_row

Line 1578: -- Description : for OKL_REPAIR_COSTS_B

1574: ---------------------------------------
1575: -- Start of comments
1576: --
1577: -- Procedure Name : insert_row
1578: -- Description : for OKL_REPAIR_COSTS_B
1579: -- Business Rules :
1580: -- Parameters :
1581: -- Version : 1.0
1582: -- History : SPILLAIP 12-DEC-2002 2667636

Line 1599: -- Set_Attributes for:OKL_REPAIR_COSTS_B --

1595: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1596: l_rpc_rec rpc_rec_type := p_rpc_rec;
1597: l_def_rpc_rec rpc_rec_type;
1598: -------------------------------------------
1599: -- Set_Attributes for:OKL_REPAIR_COSTS_B --
1600: -------------------------------------------
1601: FUNCTION Set_Attributes (
1602: p_rpc_rec IN rpc_rec_type,
1603: x_rpc_rec OUT NOCOPY rpc_rec_type

Line 1630: INSERT INTO OKL_REPAIR_COSTS_B(

1626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1628: RAISE OKC_API.G_EXCEPTION_ERROR;
1629: END IF;
1630: INSERT INTO OKL_REPAIR_COSTS_B(
1631: id,
1632: object_version_number,
1633: enabled_yn,
1634: org_id,

Line 2070: -- lock_row for:OKL_REPAIR_COSTS_B --

2066: '_PVT'
2067: );
2068: END lock_row;
2069: -------------------------------------
2070: -- lock_row for:OKL_REPAIR_COSTS_B --
2071: -------------------------------------
2072: PROCEDURE lock_row(
2073: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2074: x_return_status OUT NOCOPY VARCHAR2,

Line 2083: FROM OKL_REPAIR_COSTS_B

2079: E_Resource_Busy EXCEPTION;
2080: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2081: CURSOR lock_csr (p_rpc_rec IN rpc_rec_type) IS
2082: SELECT OBJECT_VERSION_NUMBER
2083: FROM OKL_REPAIR_COSTS_B
2084: WHERE ID = p_rpc_rec.id
2085: AND OBJECT_VERSION_NUMBER = p_rpc_rec.object_version_number
2086: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2087:

Line 2090: FROM OKL_REPAIR_COSTS_B

2086: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2087:
2088: CURSOR lchk_csr (p_rpc_rec IN rpc_rec_type) IS
2089: SELECT OBJECT_VERSION_NUMBER
2090: FROM OKL_REPAIR_COSTS_B
2091: WHERE ID = p_rpc_rec.id;
2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2095: l_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2091: WHERE ID = p_rpc_rec.id;
2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2095: l_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2096: lc_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2097: l_row_notfound BOOLEAN := FALSE;
2098: lc_row_notfound BOOLEAN := FALSE;
2099: BEGIN

Line 2096: lc_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2095: l_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2096: lc_object_version_number OKL_REPAIR_COSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2097: l_row_notfound BOOLEAN := FALSE;
2098: lc_row_notfound BOOLEAN := FALSE;
2099: BEGIN
2100: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2526: -- update_row for:OKL_REPAIR_COSTS_B --

2522: '_PVT'
2523: );
2524: END update_row;
2525: ---------------------------------------
2526: -- update_row for:OKL_REPAIR_COSTS_B --
2527: ---------------------------------------
2528: -- Start of comments
2529: --
2530: -- Procedure Name : update_row

Line 2531: -- Description : for OKL_REPAIR_COSTS_B

2527: ---------------------------------------
2528: -- Start of comments
2529: --
2530: -- Procedure Name : update_row
2531: -- Description : for OKL_REPAIR_COSTS_B
2532: -- Business Rules :
2533: -- Parameters :
2534: -- Version : 1.0
2535: -- History : SPILLAIP 12-DEC-2002 2667636

Line 2634: -- Set_Attributes for:OKL_REPAIR_COSTS_B --

2630: -- SPILLAIP - 2667636 - End
2631: RETURN(l_return_status);
2632: END populate_new_record;
2633: -------------------------------------------
2634: -- Set_Attributes for:OKL_REPAIR_COSTS_B --
2635: -------------------------------------------
2636: FUNCTION Set_Attributes (
2637: p_rpc_rec IN rpc_rec_type,
2638: x_rpc_rec OUT NOCOPY rpc_rec_type

Line 2671: UPDATE OKL_REPAIR_COSTS_B

2667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2668: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_ERROR;
2670: END IF;
2671: UPDATE OKL_REPAIR_COSTS_B
2672: SET OBJECT_VERSION_NUMBER = l_def_rpc_rec.object_version_number,
2673: ENABLED_YN = l_def_rpc_rec.enabled_yn,
2674: ORG_ID = l_def_rpc_rec.org_id,
2675: COST = l_def_rpc_rec.cost,

Line 3166: -- delete_row for:OKL_REPAIR_COSTS_B --

3162: '_PVT'
3163: );
3164: END delete_row;
3165: ---------------------------------------
3166: -- delete_row for:OKL_REPAIR_COSTS_B --
3167: ---------------------------------------
3168: PROCEDURE delete_row(
3169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3170: x_return_status OUT NOCOPY VARCHAR2,

Line 3190: DELETE FROM OKL_REPAIR_COSTS_B

3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3187: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3188: RAISE OKC_API.G_EXCEPTION_ERROR;
3189: END IF;
3190: DELETE FROM OKL_REPAIR_COSTS_B
3191: WHERE ID = l_rpc_rec.id;
3192:
3193: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3194: EXCEPTION