APPS.IGW_PROJECT_FUNDINGS_PVT dependencies on IGW_PROJECT_FUNDINGS

Line 1: PACKAGE BODY Igw_Project_Fundings_Pvt AS

1: PACKAGE BODY Igw_Project_Fundings_Pvt AS
2: --$Header: igwvapfb.pls 115.4 2002/11/19 23:45:25 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:

Line 6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROJECT_FUNDINGS_PVT';

2: --$Header: igwvapfb.pls 115.4 2002/11/19 23:45:25 ashkumar noship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROJECT_FUNDINGS_PVT';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Check_Lock

Line 30: FROM igw_project_fundings

26: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
27:
28: SELECT 'N'
29: INTO l_locked
30: FROM igw_project_fundings
31: WHERE rowid = p_rowid;
32: --AND record_version_number = p_record_version_number;
33:
34: END IF;

Line 119: FROM igw_project_fundings

115: pa_project_types t
116: WHERE ((p.project_id = x_project_id) OR
117: (p.project_id IN
118: (SELECT project_id
119: FROM igw_project_fundings
120: WHERE proposal_installment_id = p_proposal_installment_id
121: AND (p_rowid IS NULL OR rowid <> p_rowid))))
122: AND t.project_type = p.project_type;
123:

Line 246: FROM igw_project_fundings

242: END IF;
243:
244: SELECT count(1)
245: INTO l_count
246: FROM igw_project_fundings
247: WHERE proposal_installment_id = p_proposal_installment_id
248: AND project_id = l_project_id
249: AND ((task_id IS NOT NULL AND l_task_id IS NULL) OR
250: (task_id IS NULL AND l_task_id IS NOT NULL));

Line 275: Igw_Project_Fundings_Tbh.Insert_Row

271: /*
272: ** Invoke Table Handler to insert data
273: */
274:
275: Igw_Project_Fundings_Tbh.Insert_Row
276: (
277: x_rowid => x_rowid,
278: x_proposal_funding_id => x_proposal_funding_id,
279: p_proposal_installment_id => p_proposal_installment_id,

Line 414: FROM igw_project_fundings

410: END IF;
411:
412: SELECT count(1)
413: INTO l_count
414: FROM igw_project_fundings
415: WHERE proposal_installment_id = p_proposal_installment_id
416: AND project_id = l_project_id
417: AND rowid <> p_rowid
418: AND ((task_id IS NOT NULL AND l_task_id IS NULL) OR

Line 468: Igw_Project_Fundings_Tbh.Update_Row

464: /*
465: ** Invoke Table Handler to Update data
466: */
467:
468: Igw_Project_Fundings_Tbh.Update_Row
469: (
470: p_rowid => p_rowid,
471: p_proposal_funding_id => p_proposal_funding_id,
472: p_proposal_installment_id => p_proposal_installment_id,

Line 615: Igw_Project_Fundings_Tbh.Delete_Row

611: /*
612: ** Invoke Table Handler to Delete data
613: */
614:
615: Igw_Project_Fundings_Tbh.Delete_Row
616: (
617: p_rowid => p_rowid,
618: x_return_status => x_return_status
619: );

Line 681: END Igw_Project_Fundings_Pvt;

677: END Delete_Project_Funding;
678:
679: ---------------------------------------------------------------------------
680:
681: END Igw_Project_Fundings_Pvt;