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_SAV_PVT dependencies on OKC_STD_ART_VERSIONS_V

Line 281: -- FUNCTION get_rec for: OKC_STD_ART_VERSIONS_V

277: BEGIN
278: RETURN(get_rec(p_okc_std_art_versions_tl_rec, l_row_notfound));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION get_rec for: OKC_STD_ART_VERSIONS_V
282: ---------------------------------------------------------------------------
283: FUNCTION get_rec (
284: p_savv_rec IN savv_rec_type,
285: x_no_data_found OUT NOCOPY BOOLEAN

Line 318: FROM Okc_Std_Art_Versions_V

314: CREATION_DATE,
315: LAST_UPDATED_BY,
316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okc_Std_Art_Versions_V
319: WHERE okc_std_art_versions_v.sae_id = p_sae_id
320: AND okc_std_art_versions_v.sav_release = p_sav_release;
321: l_okc_savv_pk okc_savv_pk_csr%ROWTYPE;
322: l_savv_rec savv_rec_type;

Line 319: WHERE okc_std_art_versions_v.sae_id = p_sae_id

315: LAST_UPDATED_BY,
316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okc_Std_Art_Versions_V
319: WHERE okc_std_art_versions_v.sae_id = p_sae_id
320: AND okc_std_art_versions_v.sav_release = p_sav_release;
321: l_okc_savv_pk okc_savv_pk_csr%ROWTYPE;
322: l_savv_rec savv_rec_type;
323: BEGIN

Line 320: AND okc_std_art_versions_v.sav_release = p_sav_release;

316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN
318: FROM Okc_Std_Art_Versions_V
319: WHERE okc_std_art_versions_v.sae_id = p_sae_id
320: AND okc_std_art_versions_v.sav_release = p_sav_release;
321: l_okc_savv_pk okc_savv_pk_csr%ROWTYPE;
322: l_savv_rec savv_rec_type;
323: BEGIN
324: x_no_data_found := TRUE;

Line 371: -- FUNCTION null_out_defaults for: OKC_STD_ART_VERSIONS_V --

367: RETURN(get_rec(p_savv_rec, l_row_notfound));
368: END get_rec;
369:
370: ------------------------------------------------------------
371: -- FUNCTION null_out_defaults for: OKC_STD_ART_VERSIONS_V --
372: ------------------------------------------------------------
373: FUNCTION null_out_defaults (
374: p_savv_rec IN savv_rec_type
375: ) RETURN savv_rec_type IS

Line 522: from okc_std_art_versions_v sav

518: procedure validate_latest(p_savv_rec IN savv_rec_type,
519: x_return_status OUT NOCOPY VARCHAR2) is
520:
521: Cursor l_sav_csr is select sav_release
522: from okc_std_art_versions_v sav
523: where sav.sae_id=p_savv_rec.sae_id order by date_active desc, creation_date DESC ;
524:
525: l_sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;
526:

Line 617: from okc_std_art_versions_v

613: procedure Valid_Date_For_Ins_Upd(p_savv_rec IN savv_rec_type,
614: x_return_status OUT NOCOPY VARCHAR2) IS
615:
616: Cursor l_date_csr is select max(date_active)
617: from okc_std_art_versions_v
618: where sae_id = p_savv_rec.sae_id and sav_release<>p_savv_rec.sav_release;
619: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;
620:
621: Begin

Line 619: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;

615:
616: Cursor l_date_csr is select max(date_active)
617: from okc_std_art_versions_v
618: where sae_id = p_savv_rec.sae_id and sav_release<>p_savv_rec.sav_release;
619: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;
620:
621: Begin
622:
623: /* commented as result of bug launched 1162366 - which doesnot want to treat this as error

Line 917: from okc_std_art_versions_v

913: procedure validate_date_active(p_savv_rec IN savv_rec_type,
914: x_return_status OUT NOCOPY VARCHAR2) is
915:
916: Cursor l_csr is select date_active,sav_release
917: from okc_std_art_versions_v
918: where sae_id = p_savv_rec.sae_id and sav_release=p_savv_rec.sav_release;
919:
920: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;
921: l_sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;

Line 920: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;

916: Cursor l_csr is select date_active,sav_release
917: from okc_std_art_versions_v
918: where sae_id = p_savv_rec.sae_id and sav_release=p_savv_rec.sav_release;
919:
920: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;
921: l_sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;
922:
923: BEGIN
924: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

Line 921: l_sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;

917: from okc_std_art_versions_v
918: where sae_id = p_savv_rec.sae_id and sav_release=p_savv_rec.sav_release;
919:
920: l_date OKC_STD_ART_VERSIONS_V.DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE;
921: l_sav_release OKC_STD_ART_VERSIONS_V.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;
922:
923: BEGIN
924: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
925: --check not null

Line 975: -- Validate_Attributes for:OKC_STD_ART_VERSIONS_V --

971: ---------------------------------------------------------------------------
972: -- PROCEDURE Validate_Attributes
973: ---------------------------------------------------------------------------
974: ------------------------------------------------
975: -- Validate_Attributes for:OKC_STD_ART_VERSIONS_V --
976: ------------------------------------------------
977: FUNCTION Validate_Attributes (
978: p_savv_rec IN savv_rec_type
979: ) RETURN VARCHAR2 IS

Line 1059: -- Validate_Record for:OKC_STD_ART_VERSIONS_V --

1055: ---------------------------------------------------------------------------
1056: -- PROCEDURE Validate_Record
1057: ---------------------------------------------------------------------------
1058: ------------------------------------------------
1059: -- Validate_Record for:OKC_STD_ART_VERSIONS_V --
1060: ------------------------------------------------
1061: FUNCTION Validate_Record (
1062: p_savv_rec IN savv_rec_type
1063: ) RETURN VARCHAR2 IS

Line 1173: -- validate_row for:OKC_STD_ART_VERSIONS_V --

1169: ---------------------------------------------------------------------------
1170: -- PROCEDURE validate_row
1171: ---------------------------------------------------------------------------
1172: ---------------------------------------------
1173: -- validate_row for:OKC_STD_ART_VERSIONS_V --
1174: ---------------------------------------------
1175: PROCEDURE validate_row(
1176: p_api_version IN NUMBER,
1177: p_init_msg_list IN VARCHAR2 ,

Line 1574: -- insert_row for:OKC_STD_ART_VERSIONS_V --

1570: '_PVT'
1571: );
1572: END insert_row;
1573: -------------------------------------------
1574: -- insert_row for:OKC_STD_ART_VERSIONS_V --
1575: -------------------------------------------
1576: PROCEDURE insert_row(
1577: p_api_version IN NUMBER,
1578: p_init_msg_list IN VARCHAR2 ,

Line 1628: -- Set_Attributes for:OKC_STD_ART_VERSIONS_V --

1624: l_savv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1625: RETURN(l_savv_rec);
1626: END fill_who_columns;
1627: -----------------------------------------------
1628: -- Set_Attributes for:OKC_STD_ART_VERSIONS_V --
1629: -----------------------------------------------
1630: FUNCTION Set_Attributes (
1631: p_savv_rec IN savv_rec_type,
1632: x_savv_rec OUT NOCOPY savv_rec_type

Line 1693: -- check uniqueness for SAE_ID + SAV_RELEASE in OKC_STD_ART_VERSIONS_V

1689: -- ---------------------------------------------------------------------
1690: -- Bug 1636056 related changes - Shyam
1691: -- OKC_UTIL.check_comp_unique call is replaced with
1692: -- the explicit cursors above, for identical function to
1693: -- check uniqueness for SAE_ID + SAV_RELEASE in OKC_STD_ART_VERSIONS_V
1694: -- ---------------------------------------------------------------------
1695: IF ( (l_def_savv_rec.sae_id IS NOT NULL)
1696: AND (l_def_savv_rec.sae_id <> OKC_API.G_MISS_NUM) )
1697: AND

Line 2055: -- lock_row for:OKC_STD_ART_VERSIONS_V --

2051: '_PVT'
2052: );
2053: END lock_row;
2054: -----------------------------------------
2055: -- lock_row for:OKC_STD_ART_VERSIONS_V --
2056: -----------------------------------------
2057: PROCEDURE lock_row(
2058: p_api_version IN NUMBER,
2059: p_init_msg_list IN VARCHAR2 ,

Line 2641: -- update_row for:OKC_STD_ART_VERSIONS_V --

2637: '_PVT'
2638: );
2639: END update_row;
2640: -------------------------------------------
2641: -- update_row for:OKC_STD_ART_VERSIONS_V --
2642: -------------------------------------------
2643: PROCEDURE update_row(
2644: p_api_version IN NUMBER,
2645: p_init_msg_list IN VARCHAR2 ,

Line 2809: -- Set_Attributes for:OKC_STD_ART_VERSIONS_V --

2805: END IF;
2806: RETURN(l_return_status);
2807: END populate_new_record;
2808: -----------------------------------------------
2809: -- Set_Attributes for:OKC_STD_ART_VERSIONS_V --
2810: -----------------------------------------------
2811: FUNCTION Set_Attributes (
2812: p_savv_rec IN savv_rec_type,
2813: x_savv_rec OUT NOCOPY savv_rec_type

Line 3165: -- delete_row for:OKC_STD_ART_VERSIONS_V --

3161: '_PVT'
3162: );
3163: END delete_row;
3164: -------------------------------------------
3165: -- delete_row for:OKC_STD_ART_VERSIONS_V --
3166: -------------------------------------------
3167: PROCEDURE delete_row(
3168: p_api_version IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 ,