APPS.OKC_STS_PVT dependencies on OKC_STATUSES_V

Line 216: -- FUNCTION get_rec for: OKC_STATUSES_V

212: BEGIN
213: RETURN(get_rec(p_okc_statuses_tl_rec, l_row_notfound));
214: END get_rec;
215: ---------------------------------------------------------------------------
216: -- FUNCTION get_rec for: OKC_STATUSES_V
217: ---------------------------------------------------------------------------
218: FUNCTION get_rec (
219: p_stsv_rec IN stsv_rec_type,
220: x_no_data_found OUT NOCOPY BOOLEAN

Line 238: FROM Okc_Statuses_V

234: CREATION_DATE,
235: LAST_UPDATED_BY,
236: LAST_UPDATE_DATE,
237: LAST_UPDATE_LOGIN
238: FROM Okc_Statuses_V
239: WHERE okc_statuses_v.code = p_code;
240: l_okc_stsv_pk okc_stsv_pk_csr%ROWTYPE;
241: l_stsv_rec stsv_rec_type;
242: BEGIN

Line 239: WHERE okc_statuses_v.code = p_code;

235: LAST_UPDATED_BY,
236: LAST_UPDATE_DATE,
237: LAST_UPDATE_LOGIN
238: FROM Okc_Statuses_V
239: WHERE okc_statuses_v.code = p_code;
240: l_okc_stsv_pk okc_stsv_pk_csr%ROWTYPE;
241: l_stsv_rec stsv_rec_type;
242: BEGIN
243: x_no_data_found := TRUE;

Line 275: -- FUNCTION null_out_defaults for: OKC_STATUSES_V --

271: RETURN(get_rec(p_stsv_rec, l_row_notfound));
272: END get_rec;
273:
274: ----------------------------------------------------
275: -- FUNCTION null_out_defaults for: OKC_STATUSES_V --
276: ----------------------------------------------------
277: FUNCTION null_out_defaults (
278: p_stsv_rec IN stsv_rec_type
279: ) RETURN stsv_rec_type IS

Line 520: -- Validate_Attributes for:OKC_STATUSES_V --

516: ---------------------------------------------------------------------------
517: -- PROCEDURE Validate_Attributes
518: ---------------------------------------------------------------------------
519: --------------------------------------------
520: -- Validate_Attributes for:OKC_STATUSES_V --
521: --------------------------------------------
522: FUNCTION Validate_Attributes (
523: p_stsv_rec IN stsv_rec_type
524: ) RETURN VARCHAR2 IS

Line 630: from okc_statuses_v

626: l_dummy Varchar2(1);
627: l_row_found Boolean := False;
628: cursor c1(p_code Varchar2) is
629: select 'x'
630: from okc_statuses_v
631: where code = p_code;
632: BEGIN
633: Open c1(p_stsv_rec.code);
634: Fetch c1 Into l_dummy;

Line 667: from okc_statuses_v

663: l_row_found Boolean := False;
664: cursor c1(p_code Varchar2,
665: p_meaning Varchar2) is
666: select 'x'
667: from okc_statuses_v
668: where meaning = p_meaning
669: and ((code <> p_code
670: and p_code is Not NULL)
671: or p_code is NULL);

Line 698: -- Validate_Record for:OKC_STATUSES_V --

694: ---------------------------------------------------------------------------
695: -- PROCEDURE Validate_Record
696: ---------------------------------------------------------------------------
697: ----------------------------------------
698: -- Validate_Record for:OKC_STATUSES_V --
699: ----------------------------------------
700: FUNCTION Validate_Record (
701: p_stsv_rec IN stsv_rec_type
702: ) RETURN VARCHAR2 IS

Line 837: -- validate_row for:OKC_STATUSES_V --

833: ---------------------------------------------------------------------------
834: -- PROCEDURE validate_row
835: ---------------------------------------------------------------------------
836: -------------------------------------
837: -- validate_row for:OKC_STATUSES_V --
838: -------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2,

Line 1205: -- insert_row for:OKC_STATUSES_V --

1201: '_PVT'
1202: );
1203: END insert_row;
1204: -----------------------------------
1205: -- insert_row for:OKC_STATUSES_V --
1206: -----------------------------------
1207: PROCEDURE insert_row(
1208: p_api_version IN NUMBER,
1209: p_init_msg_list IN VARCHAR2,

Line 1241: -- Set_Attributes for:OKC_STATUSES_V --

1237: l_stsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1238: RETURN(l_stsv_rec);
1239: END fill_who_columns;
1240: ---------------------------------------
1241: -- Set_Attributes for:OKC_STATUSES_V --
1242: ---------------------------------------
1243: FUNCTION Set_Attributes (
1244: p_stsv_rec IN stsv_rec_type,
1245: x_stsv_rec OUT NOCOPY stsv_rec_type

Line 1638: -- lock_row for:OKC_STATUSES_V --

1634: '_PVT'
1635: );
1636: END lock_row;
1637: ---------------------------------
1638: -- lock_row for:OKC_STATUSES_V --
1639: ---------------------------------
1640: PROCEDURE lock_row(
1641: p_api_version IN NUMBER,
1642: p_init_msg_list IN VARCHAR2,

Line 2135: -- update_row for:OKC_STATUSES_V --

2131: '_PVT'
2132: );
2133: END update_row;
2134: -----------------------------------
2135: -- update_row for:OKC_STATUSES_V --
2136: -----------------------------------
2137: PROCEDURE update_row(
2138: p_api_version IN NUMBER,
2139: p_init_msg_list IN VARCHAR2,

Line 2244: -- Set_Attributes for:OKC_STATUSES_V --

2240: END IF;
2241: RETURN(l_return_status);
2242: END populate_new_record;
2243: ---------------------------------------
2244: -- Set_Attributes for:OKC_STATUSES_V --
2245: ---------------------------------------
2246: FUNCTION Set_Attributes (
2247: p_stsv_rec IN stsv_rec_type,
2248: x_stsv_rec OUT NOCOPY stsv_rec_type

Line 2592: -- delete_row for:OKC_STATUSES_V --

2588: '_PVT'
2589: );
2590: END delete_row;
2591: -----------------------------------
2592: -- delete_row for:OKC_STATUSES_V --
2593: -----------------------------------
2594: PROCEDURE delete_row(
2595: p_api_version IN NUMBER,
2596: p_init_msg_list IN VARCHAR2,

Line 2757: from okc_statuses_v

2753: p_status_type IN VARCHAR2,
2754: x_status_code OUT NOCOPY VARCHAR2) IS
2755: cursor c1 is
2756: select code
2757: from okc_statuses_v
2758: where ste_code = p_status_type
2759: and default_yn = 'Y';
2760: l_status_code okc_statuses_v.code%TYPE;
2761: l_row_notfound BOOLEAN;

Line 2760: l_status_code okc_statuses_v.code%TYPE;

2756: select code
2757: from okc_statuses_v
2758: where ste_code = p_status_type
2759: and default_yn = 'Y';
2760: l_status_code okc_statuses_v.code%TYPE;
2761: l_row_notfound BOOLEAN;
2762: BEGIN
2763: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2764: Open c1;