eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_SCN_PVT dependencies on OKC_SECTIONS_V

Line 821: -- FUNCTION get_rec for: OKC_SECTIONS_V

817: RETURN(get_rec(p_okc_sections_tl_rec, l_row_notfound));
818:
819: END get_rec;
820: ---------------------------------------------------------------------------
821: -- FUNCTION get_rec for: OKC_SECTIONS_V
822: ---------------------------------------------------------------------------
823: FUNCTION get_rec (
824: p_scnv_rec IN scnv_rec_type,
825: x_no_data_found OUT NOCOPY BOOLEAN

Line 862: FROM okc_sections_v

858: ATTRIBUTE12,
859: ATTRIBUTE13,
860: ATTRIBUTE14,
861: ATTRIBUTE15
862: FROM okc_sections_v
863: WHERE okc_sections_v.id = p_id;
864:
865: l_okc_scnv_pk okc_scnv_pk_csr%ROWTYPE;
866: -- UPTO THIS (JOHN)

Line 863: WHERE okc_sections_v.id = p_id;

859: ATTRIBUTE13,
860: ATTRIBUTE14,
861: ATTRIBUTE15
862: FROM okc_sections_v
863: WHERE okc_sections_v.id = p_id;
864:
865: l_okc_scnv_pk okc_scnv_pk_csr%ROWTYPE;
866: -- UPTO THIS (JOHN)
867:

Line 939: -- FUNCTION null_out_defaults for: OKC_SECTIONS_V --

935:
936: END get_rec;
937:
938: ----------------------------------------------------
939: -- FUNCTION null_out_defaults for: OKC_SECTIONS_V --
940: ----------------------------------------------------
941: FUNCTION null_out_defaults (
942: p_scnv_rec IN scnv_rec_type
943: ) RETURN scnv_rec_type IS

Line 1058: -- Validate_Attributes for:OKC_SECTIONS_V --

1054: ---------------------------------------------------------------------------
1055: -- PROCEDURE Validate_Attributes
1056: ---------------------------------------------------------------------------
1057: --------------------------------------------
1058: -- Validate_Attributes for:OKC_SECTIONS_V --
1059: --------------------------------------------
1060: FUNCTION Validate_Attributes (
1061: p_scnv_rec IN scnv_rec_type
1062: ) RETURN VARCHAR2 IS

Line 1174: -- Validate_Record for:OKC_SECTIONS_V --

1170: ---------------------------------------------------------------------------
1171: -- PROCEDURE Validate_Record
1172: ---------------------------------------------------------------------------
1173: ----------------------------------------
1174: -- Validate_Record for:OKC_SECTIONS_V --
1175: ----------------------------------------
1176: FUNCTION Validate_Record (
1177: p_scnv_rec IN scnv_rec_type
1178: ) RETURN VARCHAR2 IS

Line 1190: FROM okc_sections_v

1186: -- Two cursors with and without SCN_ID null condition
1187: -- ------------------------------------------------------
1188: CURSOR cur_scn_1 IS
1189: SELECT 'x'
1190: FROM okc_sections_v
1191: WHERE chr_id = p_scnv_rec.CHR_ID
1192: AND sat_code = p_scnv_rec.SAT_CODE
1193: AND section_sequence = p_scnv_rec.SECTION_SEQUENCE
1194: AND scn_id = p_scnv_rec.SCN_ID

Line 1396: -- validate_row for:OKC_SECTIONS_V --

1392: ---------------------------------------------------------------------------
1393: -- PROCEDURE validate_row
1394: ---------------------------------------------------------------------------
1395: -------------------------------------
1396: -- validate_row for:OKC_SECTIONS_V --
1397: -------------------------------------
1398: PROCEDURE validate_row(
1399: p_api_version IN NUMBER,
1400: p_init_msg_list IN VARCHAR2,

Line 1923: -- insert_row for:OKC_SECTIONS_V --

1919: );
1920:
1921: END insert_row;
1922: -----------------------------------
1923: -- insert_row for:OKC_SECTIONS_V --
1924: -----------------------------------
1925: PROCEDURE insert_row(
1926: p_api_version IN NUMBER,
1927: p_init_msg_list IN VARCHAR2,

Line 1961: -- Set_Attributes for:OKC_SECTIONS_V --

1957: RETURN(l_scnv_rec);
1958:
1959: END fill_who_columns;
1960: ---------------------------------------
1961: -- Set_Attributes for:OKC_SECTIONS_V --
1962: ---------------------------------------
1963: FUNCTION Set_Attributes (
1964: p_scnv_rec IN scnv_rec_type,
1965: x_scnv_rec OUT NOCOPY scnv_rec_type

Line 2506: -- lock_row for:OKC_SECTIONS_V --

2502: );
2503:
2504: END lock_row;
2505: ---------------------------------
2506: -- lock_row for:OKC_SECTIONS_V --
2507: ---------------------------------
2508: PROCEDURE lock_row(
2509: p_api_version IN NUMBER,
2510: p_init_msg_list IN VARCHAR2,

Line 3240: -- update_row for:OKC_SECTIONS_V --

3236: );
3237:
3238: END update_row;
3239: -----------------------------------
3240: -- update_row for:OKC_SECTIONS_V --
3241: -----------------------------------
3242: PROCEDURE update_row(
3243: p_api_version IN NUMBER,
3244: p_init_msg_list IN VARCHAR2,

Line 3432: -- Set_Attributes for:OKC_SECTIONS_V --

3428: RETURN(l_return_status);
3429:
3430: END populate_new_record;
3431: ---------------------------------------
3432: -- Set_Attributes for:OKC_SECTIONS_V --
3433: ---------------------------------------
3434: FUNCTION Set_Attributes (
3435: p_scnv_rec IN scnv_rec_type,
3436: x_scnv_rec OUT NOCOPY scnv_rec_type

Line 3904: -- delete_row for:OKC_SECTIONS_V --

3900: );
3901:
3902: END delete_row;
3903: -----------------------------------
3904: -- delete_row for:OKC_SECTIONS_V --
3905: -----------------------------------
3906: PROCEDURE delete_row(
3907: p_api_version IN NUMBER,
3908: p_init_msg_list IN VARCHAR2,