DBA Data[Home] [Help]

APPS.OKS_PBR_PVT dependencies on OKS_PRICE_BREAKS_V

Line 94: -- FUNCTION get_rec for: OKS_PRICE_BREAKS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_PRICE_BREAKS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_pbrv_rec IN pbrv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 132: FROM Oks_Price_Breaks_V

128: CREATION_DATE,
129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM Oks_Price_Breaks_V
133: WHERE oks_price_breaks_v.id = p_id;
134: l_oks_pbrv_pk oks_pbrv_pk_csr%ROWTYPE;
135: l_pbrv_rec pbrv_rec_type;
136: BEGIN

Line 133: WHERE oks_price_breaks_v.id = p_id;

129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM Oks_Price_Breaks_V
133: WHERE oks_price_breaks_v.id = p_id;
134: l_oks_pbrv_pk oks_pbrv_pk_csr%ROWTYPE;
135: l_pbrv_rec pbrv_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;

Line 316: -- FUNCTION null_out_defaults for: OKS_PRICE_BREAKS_V

312: BEGIN
313: RETURN(get_rec(p_pbr_rec, l_row_not_found));
314: END get_rec;
315: ---------------------------------------------------------------------------
316: -- FUNCTION null_out_defaults for: OKS_PRICE_BREAKS_V
317: ---------------------------------------------------------------------------
318: FUNCTION null_out_defaults (
319: p_pbrv_rec IN pbrv_rec_type
320: ) RETURN pbrv_rec_type IS

Line 473: -- Validate_Attributes for:OKS_PRICE_BREAKS_V --

469: ---------------------------------------------------------------------------
470: -- FUNCTION Validate_Attributes
471: ---------------------------------------------------------------------------
472: ------------------------------------------------
473: -- Validate_Attributes for:OKS_PRICE_BREAKS_V --
474: ------------------------------------------------
475: FUNCTION Validate_Attributes (
476: p_pbrv_rec IN pbrv_rec_type
477: ) RETURN VARCHAR2 IS

Line 520: -- Validate Record for:OKS_PRICE_BREAKS_V --

516: ---------------------------------------------------------------------------
517: -- PROCEDURE Validate_Record
518: ---------------------------------------------------------------------------
519: --------------------------------------------
520: -- Validate Record for:OKS_PRICE_BREAKS_V --
521: --------------------------------------------
522: FUNCTION Validate_Record (
523: p_pbrv_rec IN pbrv_rec_type,
524: p_db_pbrv_rec IN pbrv_rec_type

Line 620: -- validate_row for:OKS_PRICE_BREAKS_V --

616: ---------------------------------------------------------------------------
617: -- PROCEDURE validate_row
618: ---------------------------------------------------------------------------
619: -----------------------------------------
620: -- validate_row for:OKS_PRICE_BREAKS_V --
621: -----------------------------------------
622: PROCEDURE validate_row(
623: p_api_version IN NUMBER,
624: p_init_msg_list IN VARCHAR2,

Line 697: -- PL/SQL TBL validate_row for:OKS_PRICE_BREAKS_V --

693: '_PVT'
694: );
695: END validate_row;
696: ----------------------------------------------------
697: -- PL/SQL TBL validate_row for:OKS_PRICE_BREAKS_V --
698: ----------------------------------------------------
699: PROCEDURE validate_row(
700: p_api_version IN NUMBER,
701: p_init_msg_list IN VARCHAR2,

Line 793: -- PL/SQL TBL validate_row for:OKS_PRICE_BREAKS_V --

789: );
790: END validate_row;
791:
792: ----------------------------------------------------
793: -- PL/SQL TBL validate_row for:OKS_PRICE_BREAKS_V --
794: ----------------------------------------------------
795: PROCEDURE validate_row(
796: p_api_version IN NUMBER,
797: p_init_msg_list IN VARCHAR2,

Line 1004: -- insert_row for :OKS_PRICE_BREAKS_V --

1000: '_PVT'
1001: );
1002: END insert_row;
1003: ----------------------------------------
1004: -- insert_row for :OKS_PRICE_BREAKS_V --
1005: ----------------------------------------
1006: PROCEDURE insert_row(
1007: p_api_version IN NUMBER,
1008: p_init_msg_list IN VARCHAR2,

Line 1038: -- Set_Attributes for:OKS_PRICE_BREAKS_V --

1034: l_pbrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1035: RETURN(l_pbrv_rec);
1036: END fill_who_columns;
1037: -------------------------------------------
1038: -- Set_Attributes for:OKS_PRICE_BREAKS_V --
1039: -------------------------------------------
1040: FUNCTION Set_Attributes (
1041: p_pbrv_rec IN pbrv_rec_type,
1042: x_pbrv_rec OUT NOCOPY pbrv_rec_type

Line 1423: -- lock_row for: OKS_PRICE_BREAKS_V --

1419: '_PVT'
1420: );
1421: END lock_row;
1422: --------------------------------------
1423: -- lock_row for: OKS_PRICE_BREAKS_V --
1424: --------------------------------------
1425: PROCEDURE lock_row(
1426: p_api_version IN NUMBER,
1427: p_init_msg_list IN VARCHAR2,

Line 1924: -- update_row for:OKS_PRICE_BREAKS_V --

1920: '_PVT'
1921: );
1922: END update_row;
1923: ---------------------------------------
1924: -- update_row for:OKS_PRICE_BREAKS_V --
1925: ---------------------------------------
1926: PROCEDURE update_row(
1927: p_api_version IN NUMBER,
1928: p_init_msg_list IN VARCHAR2,

Line 2092: -- Set_Attributes for:OKS_PRICE_BREAKS_V --

2088: END IF;
2089: RETURN(l_return_status);
2090: END populate_new_record;
2091: -------------------------------------------
2092: -- Set_Attributes for:OKS_PRICE_BREAKS_V --
2093: -------------------------------------------
2094: FUNCTION Set_Attributes (
2095: p_pbrv_rec IN pbrv_rec_type,
2096: x_pbrv_rec OUT NOCOPY pbrv_rec_type

Line 2449: -- delete_row for:OKS_PRICE_BREAKS_V --

2445: '_PVT'
2446: );
2447: END delete_row;
2448: ---------------------------------------
2449: -- delete_row for:OKS_PRICE_BREAKS_V --
2450: ---------------------------------------
2451: PROCEDURE delete_row(
2452: p_api_version IN NUMBER,
2453: p_init_msg_list IN VARCHAR2,

Line 2531: -- PL/SQL TBL delete_row for:OKS_PRICE_BREAKS_V --

2527: '_PVT'
2528: );
2529: END delete_row;
2530: --------------------------------------------------
2531: -- PL/SQL TBL delete_row for:OKS_PRICE_BREAKS_V --
2532: --------------------------------------------------
2533: PROCEDURE delete_row(
2534: p_api_version IN NUMBER,
2535: p_init_msg_list IN VARCHAR2,

Line 2627: -- PL/SQL TBL delete_row for:OKS_PRICE_BREAKS_V --

2623: );
2624: END delete_row;
2625:
2626: --------------------------------------------------
2627: -- PL/SQL TBL delete_row for:OKS_PRICE_BREAKS_V --
2628: --------------------------------------------------
2629: PROCEDURE delete_row(
2630: p_api_version IN NUMBER,
2631: p_init_msg_list IN VARCHAR2,