DBA Data[Home] [Help]

APPS.OKS_INS_PVT dependencies on OKS_INSTANCE_HISTORY_V

Line 94: -- FUNCTION get_rec for: OKS_INSTANCE_HISTORY_V

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

Line 115: FROM Oks_Instance_History_V

111: LAST_UPDATE_DATE,
112: LAST_UPDATE_LOGIN,
113: OBJECT_VERSION_NUMBER,
114: SECURITY_GROUP_ID
115: FROM Oks_Instance_History_V
116: WHERE oks_instance_history_v.id = p_id;
117: l_oks_insv_pk oks_insv_pk_csr%ROWTYPE;
118: l_insv_rec insv_rec_type;
119: BEGIN

Line 116: WHERE oks_instance_history_v.id = p_id;

112: LAST_UPDATE_LOGIN,
113: OBJECT_VERSION_NUMBER,
114: SECURITY_GROUP_ID
115: FROM Oks_Instance_History_V
116: WHERE oks_instance_history_v.id = p_id;
117: l_oks_insv_pk oks_insv_pk_csr%ROWTYPE;
118: l_insv_rec insv_rec_type;
119: BEGIN
120: x_no_data_found := TRUE;

Line 248: -- FUNCTION null_out_defaults for: OKS_INSTANCE_HISTORY_V

244: BEGIN
245: RETURN(get_rec(p_ins_rec, l_row_not_found));
246: END get_rec;
247: ---------------------------------------------------------------------------
248: -- FUNCTION null_out_defaults for: OKS_INSTANCE_HISTORY_V
249: ---------------------------------------------------------------------------
250: FUNCTION null_out_defaults (
251: p_insv_rec IN insv_rec_type
252: ) RETURN insv_rec_type IS

Line 354: -- Validate_Attributes for:OKS_INSTANCE_HISTORY_V --

350: ---------------------------------------------------------------------------
351: -- FUNCTION Validate_Attributes
352: ---------------------------------------------------------------------------
353: ----------------------------------------------------
354: -- Validate_Attributes for:OKS_INSTANCE_HISTORY_V --
355: ----------------------------------------------------
356: FUNCTION Validate_Attributes (
357: p_insv_rec IN insv_rec_type
358: ) RETURN VARCHAR2 IS

Line 401: -- Validate Record for:OKS_INSTANCE_HISTORY_V --

397: ---------------------------------------------------------------------------
398: -- PROCEDURE Validate_Record
399: ---------------------------------------------------------------------------
400: ------------------------------------------------
401: -- Validate Record for:OKS_INSTANCE_HISTORY_V --
402: ------------------------------------------------
403: FUNCTION Validate_Record (
404: p_insv_rec IN insv_rec_type,
405: p_db_insv_rec IN insv_rec_type

Line 465: -- validate_row for:OKS_INSTANCE_HISTORY_V --

461: ---------------------------------------------------------------------------
462: -- PROCEDURE validate_row
463: ---------------------------------------------------------------------------
464: ---------------------------------------------
465: -- validate_row for:OKS_INSTANCE_HISTORY_V --
466: ---------------------------------------------
467: PROCEDURE validate_row(
468: p_api_version IN NUMBER,
469: p_init_msg_list IN VARCHAR2,

Line 542: -- PL/SQL TBL validate_row for:OKS_INSTANCE_HISTORY_V --

538: '_PVT'
539: );
540: END validate_row;
541: --------------------------------------------------------
542: -- PL/SQL TBL validate_row for:OKS_INSTANCE_HISTORY_V --
543: --------------------------------------------------------
544: PROCEDURE validate_row(
545: p_api_version IN NUMBER,
546: p_init_msg_list IN VARCHAR2,

Line 638: -- PL/SQL TBL validate_row for:OKS_INSTANCE_HISTORY_V --

634: );
635: END validate_row;
636:
637: --------------------------------------------------------
638: -- PL/SQL TBL validate_row for:OKS_INSTANCE_HISTORY_V --
639: --------------------------------------------------------
640: PROCEDURE validate_row(
641: p_api_version IN NUMBER,
642: p_init_msg_list IN VARCHAR2,

Line 815: -- insert_row for :OKS_INSTANCE_HISTORY_V --

811: '_PVT'
812: );
813: END insert_row;
814: --------------------------------------------
815: -- insert_row for :OKS_INSTANCE_HISTORY_V --
816: --------------------------------------------
817: PROCEDURE insert_row(
818: p_api_version IN NUMBER,
819: p_init_msg_list IN VARCHAR2,

Line 849: -- Set_Attributes for:OKS_INSTANCE_HISTORY_V --

845: l_insv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
846: RETURN(l_insv_rec);
847: END fill_who_columns;
848: -----------------------------------------------
849: -- Set_Attributes for:OKS_INSTANCE_HISTORY_V --
850: -----------------------------------------------
851: FUNCTION Set_Attributes (
852: p_insv_rec IN insv_rec_type,
853: x_insv_rec OUT NOCOPY insv_rec_type

Line 1234: -- lock_row for: OKS_INSTANCE_HISTORY_V --

1230: '_PVT'
1231: );
1232: END lock_row;
1233: ------------------------------------------
1234: -- lock_row for: OKS_INSTANCE_HISTORY_V --
1235: ------------------------------------------
1236: PROCEDURE lock_row(
1237: p_api_version IN NUMBER,
1238: p_init_msg_list IN VARCHAR2,

Line 1650: -- update_row for:OKS_INSTANCE_HISTORY_V --

1646: '_PVT'
1647: );
1648: END update_row;
1649: -------------------------------------------
1650: -- update_row for:OKS_INSTANCE_HISTORY_V --
1651: -------------------------------------------
1652: PROCEDURE update_row(
1653: p_api_version IN NUMBER,
1654: p_init_msg_list IN VARCHAR2,

Line 1750: -- Set_Attributes for:OKS_INSTANCE_HISTORY_V --

1746: END IF;
1747: RETURN(l_return_status);
1748: END populate_new_record;
1749: -----------------------------------------------
1750: -- Set_Attributes for:OKS_INSTANCE_HISTORY_V --
1751: -----------------------------------------------
1752: FUNCTION Set_Attributes (
1753: p_insv_rec IN insv_rec_type,
1754: x_insv_rec OUT NOCOPY insv_rec_type

Line 2107: -- delete_row for:OKS_INSTANCE_HISTORY_V --

2103: '_PVT'
2104: );
2105: END delete_row;
2106: -------------------------------------------
2107: -- delete_row for:OKS_INSTANCE_HISTORY_V --
2108: -------------------------------------------
2109: PROCEDURE delete_row(
2110: p_api_version IN NUMBER,
2111: p_init_msg_list IN VARCHAR2,

Line 2189: -- PL/SQL TBL delete_row for:OKS_INSTANCE_HISTORY_V --

2185: '_PVT'
2186: );
2187: END delete_row;
2188: ------------------------------------------------------
2189: -- PL/SQL TBL delete_row for:OKS_INSTANCE_HISTORY_V --
2190: ------------------------------------------------------
2191: PROCEDURE delete_row(
2192: p_api_version IN NUMBER,
2193: p_init_msg_list IN VARCHAR2,

Line 2285: -- PL/SQL TBL delete_row for:OKS_INSTANCE_HISTORY_V --

2281: );
2282: END delete_row;
2283:
2284: ------------------------------------------------------
2285: -- PL/SQL TBL delete_row for:OKS_INSTANCE_HISTORY_V --
2286: ------------------------------------------------------
2287: PROCEDURE delete_row(
2288: p_api_version IN NUMBER,
2289: p_init_msg_list IN VARCHAR2,