DBA Data[Home] [Help]

APPS.OKC_COP_PVT dependencies on OKC_CLASS_OPERATIONS_V

Line 15: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_CLASS_OPERATIONS_V';

11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
15: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_CLASS_OPERATIONS_V';
16: G_EXCEPTION_HALT_VALIDATION exception;
17: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
18:
19: -- Start of comments

Line 421: okc_class_operations_v

417: Cursor cop_csr Is
418: SELECT
419: nvl(max(id), 11000) + 1
420: FROM
421: okc_class_operations_v
422: WHERE
423: ID >= 11000 AND id < 50000;
424:
425: l_seq NUMBER;

Line 525: -- FUNCTION get_rec for: OKC_CLASS_OPERATIONS_V

521: BEGIN
522: RETURN(get_rec(p_cop_rec, l_row_notfound));
523: END get_rec;
524: ---------------------------------------------------------------------------
525: -- FUNCTION get_rec for: OKC_CLASS_OPERATIONS_V
526: ---------------------------------------------------------------------------
527: FUNCTION get_rec (
528: p_copv_rec IN copv_rec_type,
529: x_no_data_found OUT NOCOPY BOOLEAN

Line 547: FROM Okc_Class_Operations_V

543: LAST_UPDATE_LOGIN,
544: PDF_ID,
545: grid_datasource_name,
546: QA_PDF_ID -- Bug# 2171059
547: FROM Okc_Class_Operations_V
548: WHERE okc_class_operations_v.id = p_id;
549: l_OKC_COPv_pk OKC_COPv_pk_csr%ROWTYPE;
550: l_copv_rec copv_rec_type;
551: BEGIN

Line 548: WHERE okc_class_operations_v.id = p_id;

544: PDF_ID,
545: grid_datasource_name,
546: QA_PDF_ID -- Bug# 2171059
547: FROM Okc_Class_Operations_V
548: WHERE okc_class_operations_v.id = p_id;
549: l_OKC_COPv_pk OKC_COPv_pk_csr%ROWTYPE;
550: l_copv_rec copv_rec_type;
551: BEGIN
552: x_no_data_found := TRUE;

Line 584: -- FUNCTION null_out_defaults for: OKC_CLASS_OPERATIONS_V --

580: RETURN(get_rec(p_copv_rec, l_row_notfound));
581: END get_rec;
582:
583: ------------------------------------------------------------
584: -- FUNCTION null_out_defaults for: OKC_CLASS_OPERATIONS_V --
585: ------------------------------------------------------------
586: FUNCTION null_out_defaults (
587: p_copv_rec IN copv_rec_type
588: ) RETURN copv_rec_type IS

Line 636: -- Validate_Attributes for:OKC_CLASS_OPERATIONS_V --

632: ---------------------------------------------------------------------------
633: -- PROCEDURE Validate_Attributes
634: ---------------------------------------------------------------------------
635: ----------------------------------------------------
636: -- Validate_Attributes for:OKC_CLASS_OPERATIONS_V --
637: ----------------------------------------------------
638: FUNCTION Validate_Attributes (
639: p_copv_rec IN copv_rec_type
640: ) RETURN VARCHAR2 IS

Line 731: -- Validate_Record for:OKC_CLASS_OPERATIONS_V --

727: ---------------------------------------------------------------------------
728: -- PROCEDURE Validate_Record
729: ---------------------------------------------------------------------------
730: ------------------------------------------------
731: -- Validate_Record for:OKC_CLASS_OPERATIONS_V --
732: ------------------------------------------------
733: FUNCTION Validate_Record (
734: p_copv_rec IN copv_rec_type
735: ) RETURN VARCHAR2 IS

Line 822: -- validate_row for:OKC_CLASS_OPERATIONS_V --

818: ---------------------------------------------------------------------------
819: -- PROCEDURE validate_row
820: ---------------------------------------------------------------------------
821: ---------------------------------------------
822: -- validate_row for:OKC_CLASS_OPERATIONS_V --
823: ---------------------------------------------
824: PROCEDURE validate_row(
825: p_api_version IN NUMBER,
826: p_init_msg_list IN VARCHAR2 ,

Line 1079: -- insert_row for:OKC_CLASS_OPERATIONS_V --

1075: '_PVT'
1076: );
1077: END insert_row;
1078: -------------------------------------------
1079: -- insert_row for:OKC_CLASS_OPERATIONS_V --
1080: -------------------------------------------
1081: PROCEDURE insert_row(
1082: p_api_version IN NUMBER,
1083: p_init_msg_list IN VARCHAR2 ,

Line 1113: -- Set_Attributes for:OKC_CLASS_OPERATIONS_V --

1109: l_copv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1110: RETURN(l_copv_rec);
1111: END fill_who_columns;
1112: -----------------------------------------------
1113: -- Set_Attributes for:OKC_CLASS_OPERATIONS_V --
1114: -----------------------------------------------
1115: FUNCTION Set_Attributes (
1116: p_copv_rec IN copv_rec_type,
1117: x_copv_rec OUT NOCOPY copv_rec_type

Line 1410: -- lock_row for:OKC_CLASS_OPERATIONS_V --

1406: '_PVT'
1407: );
1408: END lock_row;
1409: -----------------------------------------
1410: -- lock_row for:OKC_CLASS_OPERATIONS_V --
1411: -----------------------------------------
1412: PROCEDURE lock_row(
1413: p_api_version IN NUMBER,
1414: p_init_msg_list IN VARCHAR2 ,

Line 1750: -- update_row for:OKC_CLASS_OPERATIONS_V --

1746: '_PVT'
1747: );
1748: END update_row;
1749: -------------------------------------------
1750: -- update_row for:OKC_CLASS_OPERATIONS_V --
1751: -------------------------------------------
1752: PROCEDURE update_row(
1753: p_api_version IN NUMBER,
1754: p_init_msg_list IN VARCHAR2 ,

Line 1857: -- Set_Attributes for:OKC_CLASS_OPERATIONS_V --

1853: END IF;
1854: RETURN(l_return_status);
1855: END populate_new_record;
1856: -----------------------------------------------
1857: -- Set_Attributes for:OKC_CLASS_OPERATIONS_V --
1858: -----------------------------------------------
1859: FUNCTION Set_Attributes (
1860: p_copv_rec IN copv_rec_type,
1861: x_copv_rec OUT NOCOPY copv_rec_type

Line 2115: -- delete_row for:OKC_CLASS_OPERATIONS_V --

2111: '_PVT'
2112: );
2113: END delete_row;
2114: -------------------------------------------
2115: -- delete_row for:OKC_CLASS_OPERATIONS_V --
2116: -------------------------------------------
2117: PROCEDURE delete_row(
2118: p_api_version IN NUMBER,
2119: p_init_msg_list IN VARCHAR2 ,