APPS.OKS_COC_PVT dependencies on OKS_K_ORDER_CONTACTS_V

Line 88: -- FUNCTION get_rec for: OKS_K_ORDER_CONTACTS_V

84: BEGIN
85: RETURN(get_rec(p_coc_rec, l_row_notfound));
86: END get_rec;
87: ---------------------------------------------------------------------------
88: -- FUNCTION get_rec for: OKS_K_ORDER_CONTACTS_V
89: ---------------------------------------------------------------------------
90: FUNCTION get_rec (
91: p_cocv_rec IN cocv_rec_type,
92: x_no_data_found OUT NOCOPY BOOLEAN

Line 107: FROM Oks_K_Order_Contacts_V

103: CREATED_BY,
104: CREATION_DATE,
105: LAST_UPDATED_BY,
106: LAST_UPDATE_DATE
107: FROM Oks_K_Order_Contacts_V
108: WHERE oks_k_order_contacts_v.id = p_id;
109: l_oks_kocv_pk oks_kocv_pk_csr%ROWTYPE;
110: l_cocv_rec cocv_rec_type;
111: BEGIN

Line 108: WHERE oks_k_order_contacts_v.id = p_id;

104: CREATION_DATE,
105: LAST_UPDATED_BY,
106: LAST_UPDATE_DATE
107: FROM Oks_K_Order_Contacts_V
108: WHERE oks_k_order_contacts_v.id = p_id;
109: l_oks_kocv_pk oks_kocv_pk_csr%ROWTYPE;
110: l_cocv_rec cocv_rec_type;
111: BEGIN
112: x_no_data_found := TRUE;

Line 141: -- FUNCTION null_out_defaults for: OKS_K_ORDER_CONTACTS_V --

137: RETURN(get_rec(p_cocv_rec, l_row_notfound));
138: END get_rec;
139:
140: ------------------------------------------------------------
141: -- FUNCTION null_out_defaults for: OKS_K_ORDER_CONTACTS_V --
142: ------------------------------------------------------------
143: FUNCTION null_out_defaults (
144: p_cocv_rec IN cocv_rec_type
145: ) RETURN cocv_rec_type IS

Line 184: -- Validate_Attributes for:OKS_K_ORDER_CONTACTS_V --

180: ---------------------------------------------------------------------------
181: -- PROCEDURE Validate_Attributes
182: ---------------------------------------------------------------------------
183: ----------------------------------------------------
184: -- Validate_Attributes for:OKS_K_ORDER_CONTACTS_V --
185: ----------------------------------------------------
186: -----------------------------------------------------
187: -- Validate ID--
188: -----------------------------------------------------

Line 490: -- Validate_Attributes for:OKS_K_ORDER_CONTACTS_V --

486: p_token2_value => sqlerrm);
487: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
488: end validate_OBJECT1_id1;
489: ---------------------------------------------------
490: -- Validate_Attributes for:OKS_K_ORDER_CONTACTS_V --
491: ---------------------------------------------------
492: FUNCTION Validate_Attributes (
493: p_cocv_rec IN cocv_rec_type
494: )

Line 502: OKC_UTIL.ADD_VIEW('OKS_K_ORDER_CONTACTS_V',x_return_status);

498:
499: Begin
500: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
501:
502: OKC_UTIL.ADD_VIEW('OKS_K_ORDER_CONTACTS_V',x_return_status);
503:
504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
505: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
506: -- need to leave

Line 620: FROM OKS_K_ORDER_CONTACTS_V

616: CURSOR Get_Comb_Keys(P_COd_Id IN NUMBER,
617: P_Cro_Code IN Varchar2,
618: P_Object1_Id1 IN Varchar2) Is
619: SELECT COUNT(1)
620: FROM OKS_K_ORDER_CONTACTS_V
621: WHERE COD_ID=P_COD_ID
622: AND CRO_CODE=P_Cro_Code
623: AND OBJECT1_Id1=P_Object1_Id1;
624: l_Count NUMBER := Null;

Line 693: -- validate_row for:OKS_K_ORDER_CONTACTS_V --

689: ---------------------------------------------------------------------------
690: -- PROCEDURE validate_row
691: ---------------------------------------------------------------------------
692: ---------------------------------------------
693: -- validate_row for:OKS_K_ORDER_CONTACTS_V --
694: ---------------------------------------------
695: PROCEDURE validate_row(
696: p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 946: -- insert_row for:OKS_K_ORDER_CONTACTS_V --

942: '_PVT'
943: );
944: END insert_row;
945: -------------------------------------------
946: -- insert_row for:OKS_K_ORDER_CONTACTS_V --
947: -------------------------------------------
948: PROCEDURE insert_row(
949: p_api_version IN NUMBER,
950: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 979: -- Set_Attributes for:OKS_K_ORDER_CONTACTS_V --

975: l_cocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
976: RETURN(l_cocv_rec);
977: END fill_who_columns;
978: -----------------------------------------------
979: -- Set_Attributes for:OKS_K_ORDER_CONTACTS_V --
980: -----------------------------------------------
981: FUNCTION Set_Attributes (
982: p_cocv_rec IN cocv_rec_type,
983: x_cocv_rec OUT NOCOPY cocv_rec_type

Line 1265: -- lock_row for:OKS_K_ORDER_CONTACTS_V --

1261: '_PVT'
1262: );
1263: END lock_row;
1264: -----------------------------------------
1265: -- lock_row for:OKS_K_ORDER_CONTACTS_V --
1266: -----------------------------------------
1267: PROCEDURE lock_row(
1268: p_api_version IN NUMBER,
1269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1587: -- update_row for:OKS_K_ORDER_CONTACTS_V --

1583: '_PVT'
1584: );
1585: END update_row;
1586: -------------------------------------------
1587: -- update_row for:OKS_K_ORDER_CONTACTS_V --
1588: -------------------------------------------
1589: PROCEDURE update_row(
1590: p_api_version IN NUMBER,
1591: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1681: -- Set_Attributes for:OKS_K_ORDER_CONTACTS_V --

1677: END IF;
1678: RETURN(l_return_status);
1679: END populate_new_record;
1680: -----------------------------------------------
1681: -- Set_Attributes for:OKS_K_ORDER_CONTACTS_V --
1682: -----------------------------------------------
1683: FUNCTION Set_Attributes (
1684: p_cocv_rec IN cocv_rec_type,
1685: x_cocv_rec OUT NOCOPY cocv_rec_type

Line 1925: -- delete_row for:OKS_K_ORDER_CONTACTS_V --

1921: '_PVT'
1922: );
1923: END delete_row;
1924: -------------------------------------------
1925: -- delete_row for:OKS_K_ORDER_CONTACTS_V --
1926: -------------------------------------------
1927: PROCEDURE delete_row(
1928: p_api_version IN NUMBER,
1929: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,