APPS.OKC_SPN_PVT dependencies on OKC_SPAN_V

Line 126: -- FUNCTION get_rec for: OKC_SPAN_V

122: BEGIN
123: RETURN(get_rec(p_spn_rec, l_row_notfound));
124: END get_rec;
125: ---------------------------------------------------------------------------
126: -- FUNCTION get_rec for: OKC_SPAN_V
127: ---------------------------------------------------------------------------
128: FUNCTION get_rec (
129: p_spnv_rec IN spnv_rec_type,
130: x_no_data_found OUT NOCOPY BOOLEAN

Line 163: FROM Okc_Span_V

159: CREATION_DATE,
160: LAST_UPDATED_BY,
161: LAST_UPDATE_DATE,
162: LAST_UPDATE_LOGIN
163: FROM Okc_Span_V
164: WHERE okc_span_v.id = p_id;
165: l_okc_spnv_pk okc_spnv_pk_csr%ROWTYPE;
166: l_spnv_rec spnv_rec_type;
167: BEGIN

Line 164: WHERE okc_span_v.id = p_id;

160: LAST_UPDATED_BY,
161: LAST_UPDATE_DATE,
162: LAST_UPDATE_LOGIN
163: FROM Okc_Span_V
164: WHERE okc_span_v.id = p_id;
165: l_okc_spnv_pk okc_spnv_pk_csr%ROWTYPE;
166: l_spnv_rec spnv_rec_type;
167: BEGIN
168: x_no_data_found := TRUE;

Line 215: -- FUNCTION null_out_defaults for: OKC_SPAN_V --

211: RETURN(get_rec(p_spnv_rec, l_row_notfound));
212: END get_rec;
213:
214: ------------------------------------------------
215: -- FUNCTION null_out_defaults for: OKC_SPAN_V --
216: ------------------------------------------------
217: FUNCTION null_out_defaults (
218: p_spnv_rec IN spnv_rec_type
219: ) RETURN spnv_rec_type IS

Line 317: -- Validate_Attributes for:OKC_SPAN_V --

313: -- and is called from Validate_Attributes
314: -- 2. Validate_Records will have tuple rule checks.
315:
316: -----------------------------------------------------
317: -- Validate_Attributes for:OKC_SPAN_V --
318: -----------------------------------------------------
319:
320: PROCEDURE Validate_uom_code (
321: x_return_status OUT NOCOPY VARCHAR2,

Line 375: SELECT id FROM OKC_SPAN_V

371: FROM Okc_Span
372: WHERE id = p_id;
373:
374: CURSOR l_unq_cur(p_spn_id NUMBER) IS
375: SELECT id FROM OKC_SPAN_V
376: WHERE spn_id = p_spn_id;
377:
378: l_id NUMBER := OKC_API.G_MISS_NUM;
379: l_okc_spnv_pk okc_spnv_pk_csr%ROWTYPE;

Line 404: OKC_UTIL.Check_Unique(p_view_name => 'OKC_SPAN_V',

400: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
401: p_msg_name => 'OKC_DUP_SPN_ID');
402: END IF;
403: /*
404: OKC_UTIL.Check_Unique(p_view_name => 'OKC_SPAN_V',
405: p_col_name => 'SPN_ID',
406: p_col_value => p_spnv_rec.SPN_ID,
407: p_id => p_spnv_rec.ID,
408: x_return_status => x_return_status);*/

Line 543: -- Validate_Attributes for:OKC_SPAN_V --

539: ---------------------------------------------------------------------------
540: -- PROCEDURE Validate_Attributes
541: ---------------------------------------------------------------------------
542: ----------------------------------------
543: -- Validate_Attributes for:OKC_SPAN_V --
544: ----------------------------------------
545: FUNCTION Validate_Attributes (
546: p_spnv_rec IN spnv_rec_type
547: ) RETURN VARCHAR2 IS

Line 650: -- Validate_Record for:OKC_SPAN_V --

646: ---------------------------------------------------------------------------
647: -- PROCEDURE Validate_Record
648: ---------------------------------------------------------------------------
649: ------------------------------------
650: -- Validate_Record for:OKC_SPAN_V --
651: ------------------------------------
652: FUNCTION Validate_Record (
653: p_spnv_rec IN spnv_rec_type
654: ) RETURN VARCHAR2 IS

Line 740: -- validate_row for:OKC_SPAN_V --

736: ---------------------------------------------------------------------------
737: -- PROCEDURE validate_row
738: ---------------------------------------------------------------------------
739: ---------------------------------
740: -- validate_row for:OKC_SPAN_V --
741: ---------------------------------
742: PROCEDURE validate_row(
743: p_api_version IN NUMBER,
744: p_init_msg_list IN VARCHAR2,

Line 1027: -- insert_row for:OKC_SPAN_V --

1023: '_PVT'
1024: );
1025: END insert_row;
1026: -------------------------------
1027: -- insert_row for:OKC_SPAN_V --
1028: -------------------------------
1029: PROCEDURE insert_row(
1030: p_api_version IN NUMBER,
1031: p_init_msg_list IN VARCHAR2,

Line 1061: -- Set_Attributes for:OKC_SPAN_V --

1057: l_spnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1058: RETURN(l_spnv_rec);
1059: END fill_who_columns;
1060: -----------------------------------
1061: -- Set_Attributes for:OKC_SPAN_V --
1062: -----------------------------------
1063: FUNCTION Set_Attributes (
1064: p_spnv_rec IN spnv_rec_type,
1065: x_spnv_rec OUT NOCOPY spnv_rec_type

Line 1350: -- lock_row for:OKC_SPAN_V --

1346: '_PVT'
1347: );
1348: END lock_row;
1349: -----------------------------
1350: -- lock_row for:OKC_SPAN_V --
1351: -----------------------------
1352: PROCEDURE lock_row(
1353: p_api_version IN NUMBER,
1354: p_init_msg_list IN VARCHAR2,

Line 1753: -- update_row for:OKC_SPAN_V --

1749: '_PVT'
1750: );
1751: END update_row;
1752: -------------------------------
1753: -- update_row for:OKC_SPAN_V --
1754: -------------------------------
1755: PROCEDURE update_row(
1756: p_api_version IN NUMBER,
1757: p_init_msg_list IN VARCHAR2,

Line 1920: -- Set_Attributes for:OKC_SPAN_V --

1916: END IF;
1917: RETURN(l_return_status);
1918: END populate_new_record;
1919: -----------------------------------
1920: -- Set_Attributes for:OKC_SPAN_V --
1921: -----------------------------------
1922: FUNCTION Set_Attributes (
1923: p_spnv_rec IN spnv_rec_type,
1924: x_spnv_rec OUT NOCOPY spnv_rec_type

Line 2167: -- delete_row for:OKC_SPAN_V --

2163: '_PVT'
2164: );
2165: END delete_row;
2166: -------------------------------
2167: -- delete_row for:OKC_SPAN_V --
2168: -------------------------------
2169: PROCEDURE delete_row(
2170: p_api_version IN NUMBER,
2171: p_init_msg_list IN VARCHAR2,