DBA Data[Home] [Help]

APPS.OKC_KSQ_PVT dependencies on OKC_K_SEQ_HEADER_V

Line 367: p_token2_value => 'OKC_K_SEQ_HEADER_V',

363: p_msg_name => g_no_parent_record,
364: p_token1 => g_col_name_token,
365: p_token1_value => 'pdf_id',
366: p_token2 => g_child_table_token,
367: p_token2_value => 'OKC_K_SEQ_HEADER_V',
368: p_token3 => g_parent_table_token,
369: p_token3_value => 'OKC_PROCESS_DEFS_V');
370:
371: -- notify caller of an error

Line 535: -- FUNCTION get_rec for: OKC_K_SEQ_HEADER_V

531: BEGIN
532: RETURN(get_rec(p_ksq_rec, l_row_notfound));
533: END get_rec;
534: ---------------------------------------------------------------------------
535: -- FUNCTION get_rec for: OKC_K_SEQ_HEADER_V
536: ---------------------------------------------------------------------------
537: FUNCTION get_rec (
538: p_ksqv_rec IN ksqv_rec_type,
539: x_no_data_found OUT NOCOPY BOOLEAN

Line 541: CURSOR okc_ksqv_pk_csr (p_line_code IN OKC_K_SEQ_HEADER_V.LINE_CODE%TYPE) IS

537: FUNCTION get_rec (
538: p_ksqv_rec IN ksqv_rec_type,
539: x_no_data_found OUT NOCOPY BOOLEAN
540: ) RETURN ksqv_rec_type IS
541: CURSOR okc_ksqv_pk_csr (p_line_code IN OKC_K_SEQ_HEADER_V.LINE_CODE%TYPE) IS
542: SELECT
543: LINE_CODE,
544: SITE_YN,
545: BG_OU_NONE,

Line 556: FROM OKC_K_SEQ_HEADER_V

552: CREATION_DATE,
553: LAST_UPDATED_BY,
554: LAST_UPDATE_DATE,
555: LAST_UPDATE_LOGIN
556: FROM OKC_K_SEQ_HEADER_V
557: WHERE OKC_K_SEQ_HEADER_V.LINE_CODE = p_line_code;
558: l_okc_ksqv_pk okc_ksqv_pk_csr%ROWTYPE;
559: l_ksqv_rec ksqv_rec_type;
560: BEGIN

Line 557: WHERE OKC_K_SEQ_HEADER_V.LINE_CODE = p_line_code;

553: LAST_UPDATED_BY,
554: LAST_UPDATE_DATE,
555: LAST_UPDATE_LOGIN
556: FROM OKC_K_SEQ_HEADER_V
557: WHERE OKC_K_SEQ_HEADER_V.LINE_CODE = p_line_code;
558: l_okc_ksqv_pk okc_ksqv_pk_csr%ROWTYPE;
559: l_ksqv_rec ksqv_rec_type;
560: BEGIN
561: x_no_data_found := TRUE;

Line 592: -- FUNCTION null_out_defaults for: OKC_K_SEQ_HEADER_V --

588: RETURN(get_rec(p_ksqv_rec, l_row_notfound));
589: END get_rec;
590:
591: ------------------------------------------------------
592: -- FUNCTION null_out_defaults for: OKC_K_SEQ_HEADER_V --
593: ------------------------------------------------------
594: FUNCTION null_out_defaults (
595: p_ksqv_rec IN ksqv_rec_type
596: ) RETURN ksqv_rec_type IS

Line 641: -- Validate_Attributes for:OKC_K_SEQ_HEADER_V --

637: ---------------------------------------------------------------------------
638: -- PROCEDURE Validate_Attributes
639: ---------------------------------------------------------------------------
640: ----------------------------------------------
641: -- Validate_Attributes for:OKC_K_SEQ_HEADER_V --
642: ----------------------------------------------
643: FUNCTION Validate_Attributes (
644: p_ksqv_rec IN ksqv_rec_type
645: ) RETURN VARCHAR2 IS

Line 748: -- Validate_Record for:OKC_K_SEQ_HEADER_V --

744: ---------------------------------------------------------------------------
745: -- PROCEDURE Validate_Record
746: ---------------------------------------------------------------------------
747: ------------------------------------------
748: -- Validate_Record for:OKC_K_SEQ_HEADER_V --
749: ------------------------------------------
750: FUNCTION Validate_Record (
751: p_ksqv_rec IN ksqv_rec_type
752: ) RETURN VARCHAR2 IS

Line 881: -- validate_row for:OKC_K_SEQ_HEADER_V --

877: ---------------------------------------------------------------------------
878: -- PROCEDURE validate_row
879: ---------------------------------------------------------------------------
880: ---------------------------------------
881: -- validate_row for:OKC_K_SEQ_HEADER_V --
882: ---------------------------------------
883: PROCEDURE validate_row(
884: p_api_version IN NUMBER,
885: p_init_msg_list IN VARCHAR2 ,

Line 1147: -- insert_row for:OKC_K_SEQ_HEADER_V --

1143: '_PVT'
1144: );
1145: END insert_row;
1146: -------------------------------------
1147: -- insert_row for:OKC_K_SEQ_HEADER_V --
1148: -------------------------------------
1149: PROCEDURE insert_row(
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 ,

Line 1181: -- Set_Attributes for:OKC_K_SEQ_HEADER_V --

1177: l_ksqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1178: RETURN(l_ksqv_rec);
1179: END fill_who_columns;
1180: -----------------------------------------
1181: -- Set_Attributes for:OKC_K_SEQ_HEADER_V --
1182: -----------------------------------------
1183: FUNCTION Set_Attributes (
1184: p_ksqv_rec IN ksqv_rec_type,
1185: x_ksqv_rec OUT NOCOPY ksqv_rec_type

Line 1478: -- lock_row for:OKC_K_SEQ_HEADER_V --

1474: '_PVT'
1475: );
1476: END lock_row;
1477: -----------------------------------
1478: -- lock_row for:OKC_K_SEQ_HEADER_V --
1479: -----------------------------------
1480: PROCEDURE lock_row(
1481: p_api_version IN NUMBER,
1482: p_init_msg_list IN VARCHAR2 ,

Line 1812: -- update_row for:OKC_K_SEQ_HEADER_V --

1808: '_PVT'
1809: );
1810: END update_row;
1811: -------------------------------------
1812: -- update_row for:OKC_K_SEQ_HEADER_V --
1813: -------------------------------------
1814: PROCEDURE update_row(
1815: p_api_version IN NUMBER,
1816: p_init_msg_list IN VARCHAR2 ,

Line 1915: -- Set_Attributes for:OKC_K_SEQ_HEADER_V --

1911: END IF;
1912: RETURN(l_return_status);
1913: END populate_new_record;
1914: -----------------------------------------
1915: -- Set_Attributes for:OKC_K_SEQ_HEADER_V --
1916: -----------------------------------------
1917: FUNCTION Set_Attributes (
1918: p_ksqv_rec IN ksqv_rec_type,
1919: x_ksqv_rec OUT NOCOPY ksqv_rec_type

Line 2170: -- delete_row for:OKC_K_SEQ_HEADER_V --

2166: '_PVT'
2167: );
2168: END delete_row;
2169: -------------------------------------
2170: -- delete_row for:OKC_K_SEQ_HEADER_V --
2171: -------------------------------------
2172: PROCEDURE delete_row(
2173: p_api_version IN NUMBER,
2174: p_init_msg_list IN VARCHAR2 ,