DBA Data[Home] [Help]

APPS.OKS_COD_PVT dependencies on OKS_K_ORDER_DETAILS_V

Line 94: -- FUNCTION get_rec for: OKS_K_ORDER_DETAILS_V

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

Line 135: FROM Oks_K_Order_Details_V

131: PHONE_ID,
132: FAX_ID,
133: BILLING_PROFILE_ID,
134: RENEWAL_APPROVAL_FLAG
135: FROM Oks_K_Order_Details_V
136: WHERE oks_k_order_details_v.id = p_id;
137: l_oks_kodv_pk oks_kodv_pk_csr%ROWTYPE;
138: l_codv_rec codv_rec_type;
139: BEGIN

Line 136: WHERE oks_k_order_details_v.id = p_id;

132: FAX_ID,
133: BILLING_PROFILE_ID,
134: RENEWAL_APPROVAL_FLAG
135: FROM Oks_K_Order_Details_V
136: WHERE oks_k_order_details_v.id = p_id;
137: l_oks_kodv_pk oks_kodv_pk_csr%ROWTYPE;
138: l_codv_rec codv_rec_type;
139: BEGIN
140: x_no_data_found := TRUE;

Line 328: -- FUNCTION null_out_defaults for: OKS_K_ORDER_DETAILS_V

324: BEGIN
325: RETURN(get_rec(p_cod_rec, l_row_not_found));
326: END get_rec;
327: ---------------------------------------------------------------------------
328: -- FUNCTION null_out_defaults for: OKS_K_ORDER_DETAILS_V
329: ---------------------------------------------------------------------------
330: FUNCTION null_out_defaults (
331: p_codv_rec IN codv_rec_type
332: ) RETURN codv_rec_type IS

Line 630: -- Validate_Attributes for:OKS_K_ORDER_DETAILS_V --

626: ---------------------------------------------------------------------------
627: -- FUNCTION Validate_Attributes
628: ---------------------------------------------------------------------------
629: ---------------------------------------------------
630: -- Validate_Attributes for:OKS_K_ORDER_DETAILS_V --
631: ---------------------------------------------------
632: FUNCTION Validate_Attributes (
633: p_codv_rec IN codv_rec_type
634: ) RETURN VARCHAR2 IS

Line 722: -- Validate Record for:OKS_K_ORDER_DETAILS_V --

718: ---------------------------------------------------------------------------
719: -- PROCEDURE Validate_Record
720: ---------------------------------------------------------------------------
721: -----------------------------------------------
722: -- Validate Record for:OKS_K_ORDER_DETAILS_V --
723: -----------------------------------------------
724: FUNCTION Validate_Record (
725: p_codv_rec IN codv_rec_type,
726: p_db_codv_rec IN codv_rec_type

Line 829: -- validate_row for:OKS_K_ORDER_DETAILS_V --

825: ---------------------------------------------------------------------------
826: -- PROCEDURE validate_row
827: ---------------------------------------------------------------------------
828: --------------------------------------------
829: -- validate_row for:OKS_K_ORDER_DETAILS_V --
830: --------------------------------------------
831: PROCEDURE validate_row(
832: p_api_version IN NUMBER,
833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 906: -- PL/SQL TBL validate_row for:OKS_K_ORDER_DETAILS_V --

902: '_PVT'
903: );
904: END validate_row;
905: -------------------------------------------------------
906: -- PL/SQL TBL validate_row for:OKS_K_ORDER_DETAILS_V --
907: -------------------------------------------------------
908: PROCEDURE validate_row(
909: p_api_version IN NUMBER,
910: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1002: -- PL/SQL TBL validate_row for:OKS_K_ORDER_DETAILS_V --

998: );
999: END validate_row;
1000:
1001: -------------------------------------------------------
1002: -- PL/SQL TBL validate_row for:OKS_K_ORDER_DETAILS_V --
1003: -------------------------------------------------------
1004: PROCEDURE validate_row(
1005: p_api_version IN NUMBER,
1006: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1219: -- insert_row for :OKS_K_ORDER_DETAILS_V --

1215: '_PVT'
1216: );
1217: END insert_row;
1218: -------------------------------------------
1219: -- insert_row for :OKS_K_ORDER_DETAILS_V --
1220: -------------------------------------------
1221: PROCEDURE insert_row(
1222: p_api_version IN NUMBER,
1223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1253: -- Set_Attributes for:OKS_K_ORDER_DETAILS_V --

1249: --l_codv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1250: RETURN(l_codv_rec);
1251: END fill_who_columns;
1252: ----------------------------------------------
1253: -- Set_Attributes for:OKS_K_ORDER_DETAILS_V --
1254: ----------------------------------------------
1255: FUNCTION Set_Attributes (
1256: p_codv_rec IN codv_rec_type,
1257: x_codv_rec OUT NOCOPY codv_rec_type

Line 1636: -- lock_row for: OKS_K_ORDER_DETAILS_V --

1632: '_PVT'
1633: );
1634: END lock_row;
1635: -----------------------------------------
1636: -- lock_row for: OKS_K_ORDER_DETAILS_V --
1637: -----------------------------------------
1638: PROCEDURE lock_row(
1639: p_api_version IN NUMBER,
1640: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2153: -- update_row for:OKS_K_ORDER_DETAILS_V --

2149: '_PVT'
2150: );
2151: END update_row;
2152: ------------------------------------------
2153: -- update_row for:OKS_K_ORDER_DETAILS_V --
2154: ------------------------------------------
2155: PROCEDURE update_row(
2156: p_api_version IN NUMBER,
2157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2335: -- Set_Attributes for:OKS_K_ORDER_DETAILS_V --

2331: END IF;
2332: RETURN(l_return_status);
2333: END populate_new_record;
2334: ----------------------------------------------
2335: -- Set_Attributes for:OKS_K_ORDER_DETAILS_V --
2336: ----------------------------------------------
2337: FUNCTION Set_Attributes (
2338: p_codv_rec IN codv_rec_type,
2339: x_codv_rec OUT NOCOPY codv_rec_type

Line 2690: -- delete_row for:OKS_K_ORDER_DETAILS_V --

2686: '_PVT'
2687: );
2688: END delete_row;
2689: ------------------------------------------
2690: -- delete_row for:OKS_K_ORDER_DETAILS_V --
2691: ------------------------------------------
2692: PROCEDURE delete_row(
2693: p_api_version IN NUMBER,
2694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2772: -- PL/SQL TBL delete_row for:OKS_K_ORDER_DETAILS_V --

2768: '_PVT'
2769: );
2770: END delete_row;
2771: -----------------------------------------------------
2772: -- PL/SQL TBL delete_row for:OKS_K_ORDER_DETAILS_V --
2773: -----------------------------------------------------
2774: PROCEDURE delete_row(
2775: p_api_version IN NUMBER,
2776: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2868: -- PL/SQL TBL delete_row for:OKS_K_ORDER_DETAILS_V --

2864: );
2865: END delete_row;
2866:
2867: -----------------------------------------------------
2868: -- PL/SQL TBL delete_row for:OKS_K_ORDER_DETAILS_V --
2869: -----------------------------------------------------
2870: PROCEDURE delete_row(
2871: p_api_version IN NUMBER,
2872: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,