APPS.OKE_DELIVERABLE_PVT dependencies on OKE_K_DELIVERABLES_B

Line 171: FROM oke_k_deliverables_b

167: L_Value VARCHAR2(1) := 'N';
168:
169: CURSOR C (P_ID NUMBER, P_Num VARCHAR2 ) IS
170: SELECT 'X'
171: FROM oke_k_deliverables_b
172: WHERE Deliverable_Num = P_Num
173: AND K_Line_ID = P_ID;
174:
175: Begin

Line 2500: from oke_k_deliverables_b b, oke_k_deliverables_tl t

2496: b.rate_date,
2497: b.exchange_rate,
2498: b.requisition_line_type_id,
2499: b.po_category_id
2500: from oke_k_deliverables_b b, oke_k_deliverables_tl t
2501: where b.deliverable_id = p_id
2502: and t.deliverable_id = p_id
2503: and t.language = userenv('LANG');
2504:

Line 3567: -- insert data into oke_k_deliverables_b/tl

3563: '_PVT'
3564: );
3565: END validate_row;
3566:
3567: -- insert data into oke_k_deliverables_b/tl
3568:
3569: PROCEDURE insert_row(
3570: p_api_version IN NUMBER,
3571: p_init_msg_list IN VARCHAR2 ,

Line 3604: -- Set_Attributes for:OKE_K_DELIVERABLES_B

3600: RETURN(l_del_rec);
3601:
3602: END fill_who_columns;
3603:
3604: -- Set_Attributes for:OKE_K_DELIVERABLES_B
3605:
3606: FUNCTION Set_Attributes (
3607: p_del_rec IN del_rec_type,
3608: x_del_rec OUT NOCOPY del_rec_type

Line 3725: INSERT INTO OKE_K_DELIVERABLES_B(

3721:
3722: end if;
3723:
3724:
3725: INSERT INTO OKE_K_DELIVERABLES_B(
3726: deliverable_id,
3727: deliverable_num,
3728: project_id,
3729: task_id,

Line 4674: UPDATE oke_k_deliverables_b

4670: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4671: RAISE OKE_API.G_EXCEPTION_ERROR;
4672: END IF; */
4673:
4674: UPDATE oke_k_deliverables_b
4675: SET
4676: deliverable_num = l_def_del_rec.deliverable_num,
4677: project_id = l_def_del_rec.project_id,
4678: task_id = l_def_del_rec.task_id,

Line 4929: DELETE FROM oke_k_deliverables_b

4925: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4926: RAISE OKE_API.G_EXCEPTION_ERROR;
4927: END IF;
4928:
4929: DELETE FROM oke_k_deliverables_b
4930: WHERE deliverable_id = l_del_rec.deliverable_id;
4931:
4932: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
4933:

Line 5055: FROM oke_k_deliverables_b

5051: E_Resource_Busy EXCEPTION;
5052: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
5053: CURSOR lock_csr (p_del_rec IN del_rec_type) IS
5054: SELECT deliverable_num
5055: FROM oke_k_deliverables_b
5056: WHERE deliverable_id = p_del_rec.deliverable_id
5057:
5058: FOR UPDATE OF deliverable_id NOWAIT;
5059:

Line 5062: FROM oke_k_deliverables_b

5058: FOR UPDATE OF deliverable_id NOWAIT;
5059:
5060: CURSOR lchk_csr (p_del_rec IN del_rec_type) IS
5061: SELECT deliverable_num
5062: FROM oke_k_deliverables_b
5063: WHERE deliverable_id = p_del_rec.deliverable_id;
5064: l_api_version CONSTANT NUMBER := 1;
5065: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5066: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 5067: l_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;

5063: WHERE deliverable_id = p_del_rec.deliverable_id;
5064: l_api_version CONSTANT NUMBER := 1;
5065: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5066: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
5067: l_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;
5068: lc_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;
5069: l_row_notfound BOOLEAN := FALSE;
5070: lc_row_notfound BOOLEAN := FALSE;
5071: BEGIN

Line 5068: lc_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;

5064: l_api_version CONSTANT NUMBER := 1;
5065: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
5066: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
5067: l_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;
5068: lc_deliverable_num OKE_K_DELIVERABLES_B.DELIVERABLE_NUM%TYPE;
5069: l_row_notfound BOOLEAN := FALSE;
5070: lc_row_notfound BOOLEAN := FALSE;
5071: BEGIN
5072: l_return_status := OKE_API.START_ACTIVITY(l_api_name,

Line 5227: from OKE_K_DELIVERABLES_B B

5223: begin
5224: delete from OKE_K_DELIVERABLES_TL T
5225: where not exists
5226: (select NULL
5227: from OKE_K_DELIVERABLES_B B
5228: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5229: );
5230:
5231: update OKE_K_DELIVERABLES_TL T set (

Line 5300: from OKE_K_DELIVERABLES_BH B

5296: --
5297: delete from OKE_K_DELIVERABLES_TLH T
5298: where not exists
5299: (select NULL
5300: from OKE_K_DELIVERABLES_BH B
5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5302: and T.MAJOR_VERSION = B.MAJOR_VERSION
5303: );
5304: