DBA Data[Home] [Help]

APPS.OKS_SUBSCR_HDR_PVT dependencies on OKS_SUBSCR_HEADER_V

Line 169: -- FUNCTION get_rec for: OKS_SUBSCR_HEADER_V

165: );
166: END add_language;
167:
168: ---------------------------------------------------------------------------
169: -- FUNCTION get_rec for: OKS_SUBSCR_HEADER_V
170: ---------------------------------------------------------------------------
171: FUNCTION get_rec (
172: p_schv_rec IN schv_rec_type,
173: x_no_data_found OUT NOCOPY BOOLEAN

Line 200: FROM Oks_Subscr_Header_V

196: CREATION_DATE,
197: LAST_UPDATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATE_LOGIN
200: FROM Oks_Subscr_Header_V
201: WHERE oks_subscr_header_v.id = p_id;
202: l_oks_sch_pk oks_sch_pk_csr%ROWTYPE;
203: l_schv_rec schv_rec_type;
204: BEGIN

Line 201: WHERE oks_subscr_header_v.id = p_id;

197: LAST_UPDATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATE_LOGIN
200: FROM Oks_Subscr_Header_V
201: WHERE oks_subscr_header_v.id = p_id;
202: l_oks_sch_pk oks_sch_pk_csr%ROWTYPE;
203: l_schv_rec schv_rec_type;
204: BEGIN
205: x_no_data_found := TRUE;

Line 445: -- FUNCTION null_out_defaults for: OKS_SUBSCR_HEADER_V

441: BEGIN
442: RETURN(get_rec(p_oks_subscr_header_tl_rec, l_row_not_found));
443: END get_rec;
444: ---------------------------------------------------------------------------
445: -- FUNCTION null_out_defaults for: OKS_SUBSCR_HEADER_V
446: ---------------------------------------------------------------------------
447: FUNCTION null_out_defaults (
448: p_schv_rec IN schv_rec_type
449: ) RETURN schv_rec_type IS

Line 743: -- Validate_Attributes for:OKS_SUBSCR_HEADER_V --

739: ---------------------------------------------------------------------------
740: -- FUNCTION Validate_Attributes
741: ---------------------------------------------------------------------------
742: -------------------------------------------------
743: -- Validate_Attributes for:OKS_SUBSCR_HEADER_V --
744: -------------------------------------------------
745: FUNCTION Validate_Attributes (
746: p_schv_rec IN schv_rec_type
747: ) RETURN VARCHAR2 IS

Line 844: -- Validate Record for:OKS_SUBSCR_HEADER_V --

840: ---------------------------------------------------------------------------
841: -- PROCEDURE Validate_Record
842: ---------------------------------------------------------------------------
843: ---------------------------------------------
844: -- Validate Record for:OKS_SUBSCR_HEADER_V --
845: ---------------------------------------------
846: FUNCTION Validate_Record (
847: p_schv_rec IN schv_rec_type,
848: p_db_schv_rec IN schv_rec_type

Line 954: -- validate_row for:OKS_SUBSCR_HEADER_V --

950: ---------------------------------------------------------------------------
951: -- PROCEDURE validate_row
952: ---------------------------------------------------------------------------
953: ------------------------------------------
954: -- validate_row for:OKS_SUBSCR_HEADER_V --
955: ------------------------------------------
956: PROCEDURE validate_row(
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2,

Line 1031: -- PL/SQL TBL validate_row for:OKS_SUBSCR_HEADER_V --

1027: '_PVT'
1028: );
1029: END validate_row;
1030: -----------------------------------------------------
1031: -- PL/SQL TBL validate_row for:OKS_SUBSCR_HEADER_V --
1032: -----------------------------------------------------
1033: PROCEDURE validate_row(
1034: p_api_version IN NUMBER,
1035: p_init_msg_list IN VARCHAR2,

Line 1127: -- PL/SQL TBL validate_row for:OKS_SUBSCR_HEADER_V --

1123: );
1124: END validate_row;
1125:
1126: -----------------------------------------------------
1127: -- PL/SQL TBL validate_row for:OKS_SUBSCR_HEADER_V --
1128: -----------------------------------------------------
1129: PROCEDURE validate_row(
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2,

Line 1447: -- insert_row for :OKS_SUBSCR_HEADER_V --

1443: '_PVT'
1444: );
1445: END insert_row;
1446: -----------------------------------------
1447: -- insert_row for :OKS_SUBSCR_HEADER_V --
1448: -----------------------------------------
1449: PROCEDURE insert_row(
1450: p_api_version IN NUMBER,
1451: p_init_msg_list IN VARCHAR2,

Line 1483: -- Set_Attributes for:OKS_SUBSCR_HEADER_V --

1479: l_schv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1480: RETURN(l_schv_rec);
1481: END fill_who_columns;
1482: --------------------------------------------
1483: -- Set_Attributes for:OKS_SUBSCR_HEADER_V --
1484: --------------------------------------------
1485: FUNCTION Set_Attributes (
1486: p_schv_rec IN schv_rec_type,
1487: x_schv_rec OUT NOCOPY schv_rec_type

Line 1970: -- lock_row for: OKS_SUBSCR_HEADER_V --

1966: '_PVT'
1967: );
1968: END lock_row;
1969: ---------------------------------------
1970: -- lock_row for: OKS_SUBSCR_HEADER_V --
1971: ---------------------------------------
1972: PROCEDURE lock_row(
1973: p_api_version IN NUMBER,
1974: p_init_msg_list IN VARCHAR2,

Line 2628: -- update_row for:OKS_SUBSCR_HEADER_V --

2624: '_PVT'
2625: );
2626: END update_row;
2627: ----------------------------------------
2628: -- update_row for:OKS_SUBSCR_HEADER_V --
2629: ----------------------------------------
2630: PROCEDURE update_row(
2631: p_api_version IN NUMBER,
2632: p_init_msg_list IN VARCHAR2,

Line 2770: -- Set_Attributes for:OKS_SUBSCR_HEADER_V --

2766: END IF;
2767: RETURN(l_return_status);
2768: END populate_new_record;
2769: --------------------------------------------
2770: -- Set_Attributes for:OKS_SUBSCR_HEADER_V --
2771: --------------------------------------------
2772: FUNCTION Set_Attributes (
2773: p_schv_rec IN schv_rec_type,
2774: x_schv_rec OUT NOCOPY schv_rec_type

Line 3205: -- delete_row for:OKS_SUBSCR_HEADER_V --

3201: '_PVT'
3202: );
3203: END delete_row;
3204: ----------------------------------------
3205: -- delete_row for:OKS_SUBSCR_HEADER_V --
3206: ----------------------------------------
3207: PROCEDURE delete_row(
3208: p_api_version IN NUMBER,
3209: p_init_msg_list IN VARCHAR2,

Line 3301: -- PL/SQL TBL delete_row for:OKS_SUBSCR_HEADER_V --

3297: '_PVT'
3298: );
3299: END delete_row;
3300: ---------------------------------------------------
3301: -- PL/SQL TBL delete_row for:OKS_SUBSCR_HEADER_V --
3302: ---------------------------------------------------
3303: PROCEDURE delete_row(
3304: p_api_version IN NUMBER,
3305: p_init_msg_list IN VARCHAR2,

Line 3397: -- PL/SQL TBL delete_row for:OKS_SUBSCR_HEADER_V --

3393: );
3394: END delete_row;
3395:
3396: ---------------------------------------------------
3397: -- PL/SQL TBL delete_row for:OKS_SUBSCR_HEADER_V --
3398: ---------------------------------------------------
3399: PROCEDURE delete_row(
3400: p_api_version IN NUMBER,
3401: p_init_msg_list IN VARCHAR2,