DBA Data[Home] [Help]

APPS.OKS_SLL_PVT dependencies on OKS_STREAM_LEVELS_V

Line 94: -- FUNCTION get_rec for: OKS_STREAM_LEVELS_V

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

Line 131: FROM Oks_Stream_Levels_V

127: LAST_UPDATE_LOGIN,
128: ORIG_SYSTEM_ID1,
129: ORIG_SYSTEM_REFERENCE1,
130: ORIG_SYSTEM_SOURCE_CODE
131: FROM Oks_Stream_Levels_V
132: WHERE oks_stream_levels_v.id = p_id;
133: l_oks_sllv_pk oks_sllv_pk_csr%ROWTYPE;
134: l_sllv_rec sllv_rec_type;
135: BEGIN

Line 132: WHERE oks_stream_levels_v.id = p_id;

128: ORIG_SYSTEM_ID1,
129: ORIG_SYSTEM_REFERENCE1,
130: ORIG_SYSTEM_SOURCE_CODE
131: FROM Oks_Stream_Levels_V
132: WHERE oks_stream_levels_v.id = p_id;
133: l_oks_sllv_pk oks_sllv_pk_csr%ROWTYPE;
134: l_sllv_rec sllv_rec_type;
135: BEGIN
136: x_no_data_found := TRUE;

Line 310: -- FUNCTION null_out_defaults for: OKS_STREAM_LEVELS_V

306: BEGIN
307: RETURN(get_rec(p_sll_rec, l_row_not_found));
308: END get_rec;
309: ---------------------------------------------------------------------------
310: -- FUNCTION null_out_defaults for: OKS_STREAM_LEVELS_V
311: ---------------------------------------------------------------------------
312: FUNCTION null_out_defaults (
313: p_sllv_rec IN sllv_rec_type
314: ) RETURN sllv_rec_type IS

Line 491: -- Validate_Attributes for:OKS_STREAM_LEVELS_V --

487: ---------------------------------------------------------------------------
488: -- FUNCTION Validate_Attributes
489: ---------------------------------------------------------------------------
490: -------------------------------------------------
491: -- Validate_Attributes for:OKS_STREAM_LEVELS_V --
492: -------------------------------------------------
493: FUNCTION Validate_Attributes (
494: p_sllv_rec IN sllv_rec_type
495: ) RETURN VARCHAR2 IS

Line 547: -- Validate Record for:OKS_STREAM_LEVELS_V --

543: ---------------------------------------------------------------------------
544: -- PROCEDURE Validate_Record
545: ---------------------------------------------------------------------------
546: ---------------------------------------------
547: -- Validate Record for:OKS_STREAM_LEVELS_V --
548: ---------------------------------------------
549: FUNCTION Validate_Record (
550: p_sllv_rec IN sllv_rec_type,
551: p_db_sllv_rec IN sllv_rec_type

Line 643: -- validate_row for:OKS_STREAM_LEVELS_V --

639: ---------------------------------------------------------------------------
640: -- PROCEDURE validate_row
641: ---------------------------------------------------------------------------
642: ------------------------------------------
643: -- validate_row for:OKS_STREAM_LEVELS_V --
644: ------------------------------------------
645: PROCEDURE validate_row(
646: p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2,

Line 720: -- PL/SQL TBL validate_row for:OKS_STREAM_LEVELS_V --

716: '_PVT'
717: );
718: END validate_row;
719: -----------------------------------------------------
720: -- PL/SQL TBL validate_row for:OKS_STREAM_LEVELS_V --
721: -----------------------------------------------------
722: PROCEDURE validate_row(
723: p_api_version IN NUMBER,
724: p_init_msg_list IN VARCHAR2,

Line 816: -- PL/SQL TBL validate_row for:OKS_STREAM_LEVELS_V --

812: );
813: END validate_row;
814:
815: -----------------------------------------------------
816: -- PL/SQL TBL validate_row for:OKS_STREAM_LEVELS_V --
817: -----------------------------------------------------
818: PROCEDURE validate_row(
819: p_api_version IN NUMBER,
820: p_init_msg_list IN VARCHAR2,

Line 1023: -- insert_row for :OKS_STREAM_LEVELS_V --

1019: '_PVT'
1020: );
1021: END insert_row;
1022: -----------------------------------------
1023: -- insert_row for :OKS_STREAM_LEVELS_V --
1024: -----------------------------------------
1025: PROCEDURE insert_row(
1026: p_api_version IN NUMBER,
1027: p_init_msg_list IN VARCHAR2,

Line 1057: -- Set_Attributes for:OKS_STREAM_LEVELS_V --

1053: l_sllv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1054: RETURN(l_sllv_rec);
1055: END fill_who_columns;
1056: --------------------------------------------
1057: -- Set_Attributes for:OKS_STREAM_LEVELS_V --
1058: --------------------------------------------
1059: FUNCTION Set_Attributes (
1060: p_sllv_rec IN sllv_rec_type,
1061: x_sllv_rec OUT NOCOPY sllv_rec_type

Line 1442: -- lock_row for: OKS_STREAM_LEVELS_V --

1438: '_PVT'
1439: );
1440: END lock_row;
1441: ---------------------------------------
1442: -- lock_row for: OKS_STREAM_LEVELS_V --
1443: ---------------------------------------
1444: PROCEDURE lock_row(
1445: p_api_version IN NUMBER,
1446: p_init_msg_list IN VARCHAR2,

Line 1933: -- update_row for:OKS_STREAM_LEVELS_V --

1929: '_PVT'
1930: );
1931: END update_row;
1932: ----------------------------------------
1933: -- update_row for:OKS_STREAM_LEVELS_V --
1934: ----------------------------------------
1935: PROCEDURE update_row(
1936: p_api_version IN NUMBER,
1937: p_init_msg_list IN VARCHAR2,

Line 2097: -- Set_Attributes for:OKS_STREAM_LEVELS_V --

2093: END IF;
2094: RETURN(l_return_status);
2095: END populate_new_record;
2096: --------------------------------------------
2097: -- Set_Attributes for:OKS_STREAM_LEVELS_V --
2098: --------------------------------------------
2099: FUNCTION Set_Attributes (
2100: p_sllv_rec IN sllv_rec_type,
2101: x_sllv_rec OUT NOCOPY sllv_rec_type

Line 2454: -- delete_row for:OKS_STREAM_LEVELS_V --

2450: '_PVT'
2451: );
2452: END delete_row;
2453: ----------------------------------------
2454: -- delete_row for:OKS_STREAM_LEVELS_V --
2455: ----------------------------------------
2456: PROCEDURE delete_row(
2457: p_api_version IN NUMBER,
2458: p_init_msg_list IN VARCHAR2,

Line 2536: -- PL/SQL TBL delete_row for:OKS_STREAM_LEVELS_V --

2532: '_PVT'
2533: );
2534: END delete_row;
2535: ---------------------------------------------------
2536: -- PL/SQL TBL delete_row for:OKS_STREAM_LEVELS_V --
2537: ---------------------------------------------------
2538: PROCEDURE delete_row(
2539: p_api_version IN NUMBER,
2540: p_init_msg_list IN VARCHAR2,

Line 2632: -- PL/SQL TBL delete_row for:OKS_STREAM_LEVELS_V --

2628: );
2629: END delete_row;
2630:
2631: ---------------------------------------------------
2632: -- PL/SQL TBL delete_row for:OKS_STREAM_LEVELS_V --
2633: ---------------------------------------------------
2634: PROCEDURE delete_row(
2635: p_api_version IN NUMBER,
2636: p_init_msg_list IN VARCHAR2,