APPS.OKC_PAT_PVT dependencies on OKC_PRICE_ADJUSTMENTS_V

Line 225: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS_V

221: RETURN(get_rec(p_pat_rec, l_row_notfound));
222:
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS_V
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_patv_rec IN patv_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN

Line 300: FROM Okc_Price_Adjustments_V

296: LAST_UPDATED_BY,
297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN,
299: REBATE_TRANSACTION_TYPE_CODE
300: FROM Okc_Price_Adjustments_V
301: WHERE okc_price_adjustments_v.id = p_id;
302: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
303: l_patv_rec patv_rec_type;
304: BEGIN

Line 301: WHERE okc_price_adjustments_v.id = p_id;

297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN,
299: REBATE_TRANSACTION_TYPE_CODE
300: FROM Okc_Price_Adjustments_V
301: WHERE okc_price_adjustments_v.id = p_id;
302: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
303: l_patv_rec patv_rec_type;
304: BEGIN
305:

Line 405: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJUSTMENTS_V --

401:
402: END get_rec;
403:
404: -------------------------------------------------------------
405: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJUSTMENTS_V --
406: -------------------------------------------------------------
407: FUNCTION null_out_defaults (
408: p_patv_rec IN patv_rec_type
409: ) RETURN patv_rec_type IS

Line 1160: -- Validate_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

1156: ---------------------------------------------------------------------------
1157: -- PROCEDURE Validate_Attributes
1158: ---------------------------------------------------------------------------
1159: -----------------------------------------------------
1160: -- Validate_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
1161: -----------------------------------------------------
1162: FUNCTION Validate_Attributes (
1163: p_patv_rec IN patv_rec_type
1164: ) RETURN VARCHAR2 IS

Line 1312: -- Validate_Record for:OKC_PRICE_ADJUSTMENTS_V --

1308: ---------------------------------------------------------------------------
1309: -- PROCEDURE Validate_Record
1310: ---------------------------------------------------------------------------
1311: -------------------------------------------------
1312: -- Validate_Record for:OKC_PRICE_ADJUSTMENTS_V --
1313: -------------------------------------------------
1314: FUNCTION Validate_Record (
1315: p_patv_rec IN patv_rec_type
1316: ) RETURN VARCHAR2 IS

Line 1328: FROM Okc_Price_Adjustments_V

1324: item_not_found_error EXCEPTION;
1325: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
1326: SELECT
1327: 'x'
1328: FROM Okc_Price_Adjustments_V
1329: WHERE okc_price_adjustments_v.id = p_id;
1330: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
1331: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
1332: SELECT

Line 1329: WHERE okc_price_adjustments_v.id = p_id;

1325: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
1326: SELECT
1327: 'x'
1328: FROM Okc_Price_Adjustments_V
1329: WHERE okc_price_adjustments_v.id = p_id;
1330: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
1331: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
1332: SELECT
1333: 'x'

Line 1626: -- validate_row for:OKC_PRICE_ADJUSTMENTS_V --

1622: ---------------------------------------------------------------------------
1623: -- PROCEDURE validate_row
1624: ---------------------------------------------------------------------------
1625: ----------------------------------------------
1626: -- validate_row for:OKC_PRICE_ADJUSTMENTS_V --
1627: ----------------------------------------------
1628: PROCEDURE validate_row(
1629: p_api_version IN NUMBER,
1630: p_init_msg_list IN VARCHAR2 ,

Line 2084: -- insert_row for:OKC_PRICE_ADJUSTMENTS_V --

2080: );
2081:
2082: END insert_row;
2083: --------------------------------------------
2084: -- insert_row for:OKC_PRICE_ADJUSTMENTS_V --
2085: --------------------------------------------
2086: PROCEDURE insert_row(
2087: p_api_version IN NUMBER,
2088: p_init_msg_list IN VARCHAR2 ,

Line 2120: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

2116: RETURN(l_patv_rec);
2117:
2118: END fill_who_columns;
2119: ------------------------------------------------
2120: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
2121: ------------------------------------------------
2122: FUNCTION Set_Attributes (
2123: p_patv_rec IN patv_rec_type,
2124: x_patv_rec OUT NOCOPY patv_rec_type

Line 2521: -- lock_row for:OKC_PRICE_ADJUSTMENTS_V --

2517: );
2518:
2519: END lock_row;
2520: ------------------------------------------
2521: -- lock_row for:OKC_PRICE_ADJUSTMENTS_V --
2522: ------------------------------------------
2523: PROCEDURE lock_row(
2524: p_api_version IN NUMBER,
2525: p_init_msg_list IN VARCHAR2 ,

Line 3224: -- update_row for:OKC_PRICE_ADJUSTMENTS_V --

3220: );
3221:
3222: END update_row;
3223: --------------------------------------------
3224: -- update_row for:OKC_PRICE_ADJUSTMENTS_V --
3225: --------------------------------------------
3226: PROCEDURE update_row(
3227: p_api_version IN NUMBER,
3228: p_init_msg_list IN VARCHAR2 ,

Line 3561: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

3557: RETURN(l_return_status);
3558:
3559: END populate_new_record;
3560: ------------------------------------------------
3561: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
3562: ------------------------------------------------
3563: FUNCTION Set_Attributes (
3564: p_patv_rec IN patv_rec_type,
3565: x_patv_rec OUT NOCOPY patv_rec_type

Line 3900: -- delete_row for:OKC_PRICE_ADJUSTMENTS_V --

3896: );
3897:
3898: END delete_row;
3899: --------------------------------------------
3900: -- delete_row for:OKC_PRICE_ADJUSTMENTS_V --
3901: --------------------------------------------
3902: PROCEDURE delete_row(
3903: p_api_version IN NUMBER,
3904: p_init_msg_list IN VARCHAR2 ,