DBA Data[Home] [Help]

APPS.OKS_SUBSCR_ELEMS_PVT dependencies on OKS_SUBSCR_ELEMENTS_V

Line 94: -- FUNCTION get_rec for: OKS_SUBSCR_ELEMENTS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_SUBSCR_ELEMENTS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_scev_rec IN scev_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 122: FROM Oks_Subscr_Elements_V

118: CREATION_DATE,
119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Oks_Subscr_Elements_V
123: WHERE oks_subscr_elements_v.id = p_id;
124: l_oks_sce_pk oks_sce_pk_csr%ROWTYPE;
125: l_scev_rec scev_rec_type;
126: BEGIN

Line 123: WHERE oks_subscr_elements_v.id = p_id;

119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Oks_Subscr_Elements_V
123: WHERE oks_subscr_elements_v.id = p_id;
124: l_oks_sce_pk oks_sce_pk_csr%ROWTYPE;
125: l_scev_rec scev_rec_type;
126: BEGIN
127: x_no_data_found := TRUE;

Line 276: -- FUNCTION null_out_defaults for: OKS_SUBSCR_ELEMENTS_V

272: BEGIN
273: RETURN(get_rec(p_sbe_rec, l_row_not_found));
274: END get_rec;
275: ---------------------------------------------------------------------------
276: -- FUNCTION null_out_defaults for: OKS_SUBSCR_ELEMENTS_V
277: ---------------------------------------------------------------------------
278: FUNCTION null_out_defaults (
279: p_scev_rec IN scev_rec_type
280: ) RETURN scev_rec_type IS

Line 511: -- Validate_Attributes for:OKS_SUBSCR_ELEMENTS_V --

507: ---------------------------------------------------------------------------
508: -- FUNCTION Validate_Attributes
509: ---------------------------------------------------------------------------
510: ---------------------------------------------------
511: -- Validate_Attributes for:OKS_SUBSCR_ELEMENTS_V --
512: ---------------------------------------------------
513: FUNCTION Validate_Attributes (
514: p_scev_rec IN scev_rec_type
515: ) RETURN VARCHAR2 IS

Line 594: -- Validate Record for:OKS_SUBSCR_ELEMENTS_V --

590: ---------------------------------------------------------------------------
591: -- PROCEDURE Validate_Record
592: ---------------------------------------------------------------------------
593: -----------------------------------------------
594: -- Validate Record for:OKS_SUBSCR_ELEMENTS_V --
595: -----------------------------------------------
596: FUNCTION Validate_Record (
597: p_scev_rec IN scev_rec_type,
598: p_db_scev_rec IN scev_rec_type

Line 674: -- validate_row for:OKS_SUBSCR_ELEMENTS_V --

670: ---------------------------------------------------------------------------
671: -- PROCEDURE validate_row
672: ---------------------------------------------------------------------------
673: --------------------------------------------
674: -- validate_row for:OKS_SUBSCR_ELEMENTS_V --
675: --------------------------------------------
676: PROCEDURE validate_row(
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 751: -- PL/SQL TBL validate_row for:OKS_SUBSCR_ELEMENTS_V --

747: '_PVT'
748: );
749: END validate_row;
750: -------------------------------------------------------
751: -- PL/SQL TBL validate_row for:OKS_SUBSCR_ELEMENTS_V --
752: -------------------------------------------------------
753: PROCEDURE validate_row(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 847: -- PL/SQL TBL validate_row for:OKS_SUBSCR_ELEMENTS_V --

843: );
844: END validate_row;
845:
846: -------------------------------------------------------
847: -- PL/SQL TBL validate_row for:OKS_SUBSCR_ELEMENTS_V --
848: -------------------------------------------------------
849: PROCEDURE validate_row(
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1038: -- insert_row for :OKS_SUBSCR_ELEMENTS_V --

1034: '_PVT'
1035: );
1036: END insert_row;
1037: -------------------------------------------
1038: -- insert_row for :OKS_SUBSCR_ELEMENTS_V --
1039: -------------------------------------------
1040: PROCEDURE insert_row(
1041: p_api_version IN NUMBER,
1042: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1072: -- Set_Attributes for:OKS_SUBSCR_ELEMENTS_V --

1068: l_scev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1069: RETURN(l_scev_rec);
1070: END fill_who_columns;
1071: ----------------------------------------------
1072: -- Set_Attributes for:OKS_SUBSCR_ELEMENTS_V --
1073: ----------------------------------------------
1074: FUNCTION Set_Attributes (
1075: p_scev_rec IN scev_rec_type,
1076: x_scev_rec OUT NOCOPY scev_rec_type

Line 1455: -- lock_row for: OKS_SUBSCR_ELEMENTS_V --

1451: '_PVT'
1452: );
1453: END lock_row;
1454: -----------------------------------------
1455: -- lock_row for: OKS_SUBSCR_ELEMENTS_V --
1456: -----------------------------------------
1457: PROCEDURE lock_row(
1458: p_api_version IN NUMBER,
1459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1906: -- update_row for:OKS_SUBSCR_ELEMENTS_V --

1902: '_PVT'
1903: );
1904: END update_row;
1905: ------------------------------------------
1906: -- update_row for:OKS_SUBSCR_ELEMENTS_V --
1907: ------------------------------------------
1908: PROCEDURE update_row(
1909: p_api_version IN NUMBER,
1910: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2034: -- Set_Attributes for:OKS_SUBSCR_ELEMENTS_V --

2030: END IF;
2031: RETURN(l_return_status);
2032: END populate_new_record;
2033: ----------------------------------------------
2034: -- Set_Attributes for:OKS_SUBSCR_ELEMENTS_V --
2035: ----------------------------------------------
2036: FUNCTION Set_Attributes (
2037: p_scev_rec IN scev_rec_type,
2038: x_scev_rec OUT NOCOPY scev_rec_type

Line 2389: -- delete_row for:OKS_SUBSCR_ELEMENTS_V --

2385: '_PVT'
2386: );
2387: END delete_row;
2388: ------------------------------------------
2389: -- delete_row for:OKS_SUBSCR_ELEMENTS_V --
2390: ------------------------------------------
2391: PROCEDURE delete_row(
2392: p_api_version IN NUMBER,
2393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2471: -- PL/SQL TBL delete_row for:OKS_SUBSCR_ELEMENTS_V --

2467: '_PVT'
2468: );
2469: END delete_row;
2470: -----------------------------------------------------
2471: -- PL/SQL TBL delete_row for:OKS_SUBSCR_ELEMENTS_V --
2472: -----------------------------------------------------
2473: PROCEDURE delete_row(
2474: p_api_version IN NUMBER,
2475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2567: -- PL/SQL TBL delete_row for:OKS_SUBSCR_ELEMENTS_V --

2563: );
2564: END delete_row;
2565:
2566: -----------------------------------------------------
2567: -- PL/SQL TBL delete_row for:OKS_SUBSCR_ELEMENTS_V --
2568: -----------------------------------------------------
2569: PROCEDURE delete_row(
2570: p_api_version IN NUMBER,
2571: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,