APPS.OKC_SCC_PVT dependencies on OKC_SECTION_CONTENTS_V

Line 560: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS_V

556: RETURN(get_rec(p_scc_rec, l_row_notfound));
557:
558: END get_rec;
559: ---------------------------------------------------------------------------
560: -- FUNCTION get_rec for: OKC_SECTION_CONTENTS_V
561: ---------------------------------------------------------------------------
562: FUNCTION get_rec (
563: p_sccv_rec IN sccv_rec_type,
564: x_no_data_found OUT NOCOPY BOOLEAN

Line 599: FROM okc_section_contents_v

595: ATTRIBUTE12,
596: ATTRIBUTE13,
597: ATTRIBUTE14,
598: ATTRIBUTE15
599: FROM okc_section_contents_v
600: WHERE okc_section_contents_v.id = p_id;
601:
602: l_okc_sccv_pk okc_sccv_pk_csr%ROWTYPE;
603:

Line 600: WHERE okc_section_contents_v.id = p_id;

596: ATTRIBUTE13,
597: ATTRIBUTE14,
598: ATTRIBUTE15
599: FROM okc_section_contents_v
600: WHERE okc_section_contents_v.id = p_id;
601:
602: l_okc_sccv_pk okc_sccv_pk_csr%ROWTYPE;
603:
604: -- UPTO THIS (JOHN)

Line 676: -- FUNCTION null_out_defaults for: OKC_SECTION_CONTENTS_V --

672:
673: END get_rec;
674:
675: ------------------------------------------------------------
676: -- FUNCTION null_out_defaults for: OKC_SECTION_CONTENTS_V --
677: ------------------------------------------------------------
678: FUNCTION null_out_defaults (
679: p_sccv_rec IN sccv_rec_type
680: ) RETURN sccv_rec_type IS

Line 789: -- Validate_Attributes for:OKC_SECTION_CONTENTS_V --

785: ---------------------------------------------------------------------------
786: -- PROCEDURE Validate_Attributes
787: ---------------------------------------------------------------------------
788: ----------------------------------------------------
789: -- Validate_Attributes for:OKC_SECTION_CONTENTS_V --
790: ----------------------------------------------------
791: FUNCTION Validate_Attributes (
792: p_sccv_rec IN sccv_rec_type
793: ) RETURN VARCHAR2 IS

Line 895: -- Validate_Record for:OKC_SECTION_CONTENTS_V --

891: ---------------------------------------------------------------------------
892: -- PROCEDURE Validate_Record
893: ---------------------------------------------------------------------------
894: ------------------------------------------------
895: -- Validate_Record for:OKC_SECTION_CONTENTS_V --
896: ------------------------------------------------
897: FUNCTION Validate_Record (
898: p_sccv_rec IN sccv_rec_type
899: ) RETURN VARCHAR2 IS

Line 906: FROM okc_section_contents_v

902: l_counter NUMBER := 0;
903:
904: Cursor l_sccv_csr Is
905: SELECT count(*)
906: FROM okc_section_contents_v
907: WHERE cat_id = p_sccv_rec.CAT_ID
908: AND scn_id IN (SELECT id
909: FROM okc_sections_b
910: WHERE chr_id = (SELECT chr_id

Line 1026: -- validate_row for:OKC_SECTION_CONTENTS_V --

1022: ---------------------------------------------------------------------------
1023: -- PROCEDURE validate_row
1024: ---------------------------------------------------------------------------
1025: ---------------------------------------------
1026: -- validate_row for:OKC_SECTION_CONTENTS_V --
1027: ---------------------------------------------
1028: PROCEDURE validate_row(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2,

Line 1408: -- insert_row for:OKC_SECTION_CONTENTS_V --

1404: );
1405:
1406: END insert_row;
1407: -------------------------------------------
1408: -- insert_row for:OKC_SECTION_CONTENTS_V --
1409: -------------------------------------------
1410: PROCEDURE insert_row(
1411: p_api_version IN NUMBER,
1412: p_init_msg_list IN VARCHAR2,

Line 1444: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --

1440: RETURN(l_sccv_rec);
1441:
1442: END fill_who_columns;
1443: -----------------------------------------------
1444: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --
1445: -----------------------------------------------
1446: FUNCTION Set_Attributes (
1447: p_sccv_rec IN sccv_rec_type,
1448: x_sccv_rec OUT NOCOPY sccv_rec_type

Line 1847: -- lock_row for:OKC_SECTION_CONTENTS_V --

1843: );
1844:
1845: END lock_row;
1846: -----------------------------------------
1847: -- lock_row for:OKC_SECTION_CONTENTS_V --
1848: -----------------------------------------
1849: PROCEDURE lock_row(
1850: p_api_version IN NUMBER,
1851: p_init_msg_list IN VARCHAR2,

Line 2358: -- update_row for:OKC_SECTION_CONTENTS_V --

2354: );
2355:
2356: END update_row;
2357: -------------------------------------------
2358: -- update_row for:OKC_SECTION_CONTENTS_V --
2359: -------------------------------------------
2360: PROCEDURE update_row(
2361: p_api_version IN NUMBER,
2362: p_init_msg_list IN VARCHAR2,

Line 2540: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --

2536: RETURN(l_return_status);
2537:
2538: END populate_new_record;
2539: -----------------------------------------------
2540: -- Set_Attributes for:OKC_SECTION_CONTENTS_V --
2541: -----------------------------------------------
2542: FUNCTION Set_Attributes (
2543: p_sccv_rec IN sccv_rec_type,
2544: x_sccv_rec OUT NOCOPY sccv_rec_type

Line 2880: -- delete_row for:OKC_SECTION_CONTENTS_V --

2876: );
2877:
2878: END delete_row;
2879: -------------------------------------------
2880: -- delete_row for:OKC_SECTION_CONTENTS_V --
2881: -------------------------------------------
2882: PROCEDURE delete_row(
2883: p_api_version IN NUMBER,
2884: p_init_msg_list IN VARCHAR2,