DBA Data[Home] [Help]

APPS.OKC_OIE_PVT dependencies on OKC_OPERATION_INSTANCES_V

Line 12: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_OPERATION_INSTANCES_V';

8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_OPERATION_INSTANCES_V';
13: G_EXCEPTION_HALT_VALIDATION exception;
14:
15: -- Start of comments
16: --

Line 590: -- FUNCTION get_rec for: OKC_OPERATION_INSTANCES_V

586: RETURN(get_rec(p_oie_rec, l_row_notfound));
587:
588: END get_rec;
589: ---------------------------------------------------------------------------
590: -- FUNCTION get_rec for: OKC_OPERATION_INSTANCES_V
591: ---------------------------------------------------------------------------
592: FUNCTION get_rec (
593: p_oiev_rec IN oiev_rec_type,
594: x_no_data_found OUT NOCOPY BOOLEAN

Line 612: FROM Okc_Operation_Instances_V

608: LAST_UPDATE_LOGIN,
609: JTOT_OBJECT1_CODE,
610: OBJECT1_ID1,
611: OBJECT1_ID2
612: FROM Okc_Operation_Instances_V
613: WHERE okc_operation_instances_v.id = p_id;
614: l_oiev_pk oiev_pk_csr%ROWTYPE;
615: l_oiev_rec oiev_rec_type;
616: BEGIN

Line 613: WHERE okc_operation_instances_v.id = p_id;

609: JTOT_OBJECT1_CODE,
610: OBJECT1_ID1,
611: OBJECT1_ID2
612: FROM Okc_Operation_Instances_V
613: WHERE okc_operation_instances_v.id = p_id;
614: l_oiev_pk oiev_pk_csr%ROWTYPE;
615: l_oiev_rec oiev_rec_type;
616: BEGIN
617:

Line 664: -- FUNCTION null_out_defaults for: OKC_OPERATION_INSTANCES_V --

660:
661: END get_rec;
662:
663: ---------------------------------------------------------------
664: -- FUNCTION null_out_defaults for: OKC_OPERATION_INSTANCES_V --
665: ---------------------------------------------------------------
666: FUNCTION null_out_defaults (
667: p_oiev_rec IN oiev_rec_type
668: ) RETURN oiev_rec_type IS

Line 729: -- Validate_Attributes for:OKC_OPERATION_INSTANCES_V --

725: ---------------------------------------------------------------------------
726: -- PROCEDURE Validate_Attributes
727: ---------------------------------------------------------------------------
728: -------------------------------------------------------
729: -- Validate_Attributes for:OKC_OPERATION_INSTANCES_V --
730: -------------------------------------------------------
731: FUNCTION Validate_Attributes (
732: p_oiev_rec IN oiev_rec_type
733: ) RETURN VARCHAR2 IS

Line 830: -- Validate_Record for:OKC_OPERATION_INSTANCES_V --

826: ---------------------------------------------------------------------------
827: -- PROCEDURE Validate_Record
828: ---------------------------------------------------------------------------
829: ---------------------------------------------------
830: -- Validate_Record for:OKC_OPERATION_INSTANCES_V --
831: ---------------------------------------------------
832: FUNCTION Validate_Record (
833: p_oiev_rec IN oiev_rec_type
834: ) RETURN VARCHAR2 IS

Line 895: -- validate_row for:OKC_OPERATION_INSTANCES_V --

891: ---------------------------------------------------------------------------
892: -- PROCEDURE validate_row
893: ---------------------------------------------------------------------------
894: ------------------------------------------------
895: -- validate_row for:OKC_OPERATION_INSTANCES_V --
896: ------------------------------------------------
897: PROCEDURE validate_row(
898: p_api_version IN NUMBER,
899: p_init_msg_list IN VARCHAR2 ,

Line 1275: -- insert_row for:OKC_OPERATION_INSTANCES_V --

1271: );
1272:
1273: END insert_row;
1274: ----------------------------------------------
1275: -- insert_row for:OKC_OPERATION_INSTANCES_V --
1276: ----------------------------------------------
1277: PROCEDURE insert_row(
1278: p_api_version IN NUMBER,
1279: p_init_msg_list IN VARCHAR2 ,

Line 1312: -- Set_Attributes for:OKC_OPERATION_INSTANCES_V --

1308: RETURN(l_oiev_rec);
1309:
1310: END fill_who_columns;
1311: --------------------------------------------------
1312: -- Set_Attributes for:OKC_OPERATION_INSTANCES_V --
1313: --------------------------------------------------
1314: FUNCTION Set_Attributes (
1315: p_oiev_rec IN oiev_rec_type,
1316: x_oiev_rec OUT NOCOPY oiev_rec_type

Line 1712: -- lock_row for:OKC_OPERATION_INSTANCES_V --

1708: );
1709:
1710: END lock_row;
1711: --------------------------------------------
1712: -- lock_row for:OKC_OPERATION_INSTANCES_V --
1713: --------------------------------------------
1714: PROCEDURE lock_row(
1715: p_api_version IN NUMBER,
1716: p_init_msg_list IN VARCHAR2 ,

Line 2189: -- update_row for:OKC_OPERATION_INSTANCES_V --

2185: );
2186:
2187: END update_row;
2188: ----------------------------------------------
2189: -- update_row for:OKC_OPERATION_INSTANCES_V --
2190: ----------------------------------------------
2191: PROCEDURE update_row(
2192: p_api_version IN NUMBER,
2193: p_init_msg_list IN VARCHAR2 ,

Line 2316: -- Set_Attributes for:OKC_OPERATION_INSTANCES_V --

2312: RETURN(l_return_status);
2313:
2314: END populate_new_record;
2315: --------------------------------------------------
2316: -- Set_Attributes for:OKC_OPERATION_INSTANCES_V --
2317: --------------------------------------------------
2318: FUNCTION Set_Attributes (
2319: p_oiev_rec IN oiev_rec_type,
2320: x_oiev_rec OUT NOCOPY oiev_rec_type

Line 2666: -- delete_row for:OKC_OPERATION_INSTANCES_V --

2662: );
2663:
2664: END delete_row;
2665: ----------------------------------------------
2666: -- delete_row for:OKC_OPERATION_INSTANCES_V --
2667: ----------------------------------------------
2668: PROCEDURE delete_row(
2669: p_api_version IN NUMBER,
2670: p_init_msg_list IN VARCHAR2 ,