DBA Data[Home] [Help]

APPS.OKC_PAC_PVT dependencies on OKC_PRICE_ADJ_ASSOCS_V

Line 123: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ASSOCS_V

119: RETURN(get_rec(p_pac_rec, l_row_notfound));
120:
121: END get_rec;
122: ---------------------------------------------------------------------------
123: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ASSOCS_V
124: ---------------------------------------------------------------------------
125: FUNCTION get_rec (
126: p_pacv_rec IN pacv_rec_type,
127: x_no_data_found OUT NOCOPY BOOLEAN

Line 147: FROM Okc_Price_Adj_Assocs_V

143: PROGRAM_ID,
144: PROGRAM_UPDATE_DATE,
145: REQUEST_ID,
146: OBJECT_VERSION_NUMBER
147: FROM Okc_Price_Adj_Assocs_V
148: WHERE okc_price_adj_assocs_v.id = p_id;
149: l_okc_pacv_pk okc_pacv_pk_csr%ROWTYPE;
150: l_pacv_rec pacv_rec_type;
151: BEGIN

Line 148: WHERE okc_price_adj_assocs_v.id = p_id;

144: PROGRAM_UPDATE_DATE,
145: REQUEST_ID,
146: OBJECT_VERSION_NUMBER
147: FROM Okc_Price_Adj_Assocs_V
148: WHERE okc_price_adj_assocs_v.id = p_id;
149: l_okc_pacv_pk okc_pacv_pk_csr%ROWTYPE;
150: l_pacv_rec pacv_rec_type;
151: BEGIN
152:

Line 202: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ASSOCS_V --

198:
199: END get_rec;
200:
201: ------------------------------------------------------------
202: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ASSOCS_V --
203: ------------------------------------------------------------
204: FUNCTION null_out_defaults (
205: p_pacv_rec IN pacv_rec_type
206: ) RETURN pacv_rec_type IS

Line 364: -- Validate_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

360: ---------------------------------------------------------------------------
361: -- PROCEDURE Validate_Attributes
362: ---------------------------------------------------------------------------
363: ----------------------------------------------------
364: -- Validate_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
365: ----------------------------------------------------
366: FUNCTION Validate_Attributes (
367: p_pacv_rec IN pacv_rec_type
368: ) RETURN VARCHAR2 IS

Line 381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);

377:
378: ---------------------------------------------------------------------------------------
379: --Attribute Level Validation Procedure Calls Starts(Modification on TAPI generated Code.)--
380: ---------------------------------------------------------------------------------------
381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);
382: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
383: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
384: x_return_status := l_return_status;
385: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 451: -- Validate_Record for:OKC_PRICE_ADJ_ASSOCS_V --

447: ---------------------------------------------------------------------------
448: -- PROCEDURE Validate_Record
449: ---------------------------------------------------------------------------
450: ------------------------------------------------
451: -- Validate_Record for:OKC_PRICE_ADJ_ASSOCS_V --
452: ------------------------------------------------
453: FUNCTION Validate_Record (
454: p_pacv_rec IN pacv_rec_type
455: ) RETURN VARCHAR2 IS

Line 641: -- validate_row for:OKC_PRICE_ADJ_ASSOCS_V --

637: ---------------------------------------------------------------------------
638: -- PROCEDURE validate_row
639: ---------------------------------------------------------------------------
640: ---------------------------------------------
641: -- validate_row for:OKC_PRICE_ADJ_ASSOCS_V --
642: ---------------------------------------------
643: PROCEDURE validate_row(
644: p_api_version IN NUMBER,
645: p_init_msg_list IN VARCHAR2 ,

Line 997: -- insert_row for:OKC_PRICE_ADJ_ASSOCS_V --

993: );
994:
995: END insert_row;
996: -------------------------------------------
997: -- insert_row for:OKC_PRICE_ADJ_ASSOCS_V --
998: -------------------------------------------
999: PROCEDURE insert_row(
1000: p_api_version IN NUMBER,
1001: p_init_msg_list IN VARCHAR2 ,

Line 1033: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

1029: RETURN(l_pacv_rec);
1030:
1031: END fill_who_columns;
1032: -----------------------------------------------
1033: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
1034: -----------------------------------------------
1035: FUNCTION Set_Attributes (
1036: p_pacv_rec IN pacv_rec_type,
1037: x_pacv_rec OUT NOCOPY pacv_rec_type

Line 1466: -- lock_row for:OKC_PRICE_ADJ_ASSOCS_V --

1462: );
1463:
1464: END lock_row;
1465: -----------------------------------------
1466: -- lock_row for:OKC_PRICE_ADJ_ASSOCS_V --
1467: -----------------------------------------
1468: PROCEDURE lock_row(
1469: p_api_version IN NUMBER,
1470: p_init_msg_list IN VARCHAR2 ,

Line 1913: -- update_row for:OKC_PRICE_ADJ_ASSOCS_V --

1909: );
1910:
1911: END update_row;
1912: -------------------------------------------
1913: -- update_row for:OKC_PRICE_ADJ_ASSOCS_V --
1914: -------------------------------------------
1915: PROCEDURE update_row(
1916: p_api_version IN NUMBER,
1917: p_init_msg_list IN VARCHAR2 ,

Line 2044: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

2040: RETURN(l_return_status);
2041:
2042: END populate_new_record;
2043: -----------------------------------------------
2044: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
2045: -----------------------------------------------
2046: FUNCTION Set_Attributes (
2047: p_pacv_rec IN pacv_rec_type,
2048: x_pacv_rec OUT NOCOPY pacv_rec_type

Line 2383: -- delete_row for:OKC_PRICE_ADJ_ASSOCS_V --

2379: );
2380:
2381: END delete_row;
2382: -------------------------------------------
2383: -- delete_row for:OKC_PRICE_ADJ_ASSOCS_V --
2384: -------------------------------------------
2385: PROCEDURE delete_row(
2386: p_api_version IN NUMBER,
2387: p_init_msg_list IN VARCHAR2 ,