APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_RCD

Line 1540: Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE

1536:
1537: -- ================================================================================
1538: -- ~ Update_Record_Values :
1539: -- ================================================================================
1540: Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1541: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE

Line 1546: Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE

1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
1545: ) Is
1546: Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1547: ,c_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1548: ) Is
1549: select der.ext_data_elmt_id,
1550: der.seq_num,

Line 2078: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

2074: -- ====================================================================
2075: Function Del_Service_Detail_Recs (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
2076: )Return Number Is
2077:
2078: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
2079: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
2080: l_proc_name Varchar2(150):= g_proc_name||'Del_Service_Detail_Recs';
2081: l_return_value Number := 0; --0= Sucess, -1=Error
2082:

Line 2079: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

2075: Function Del_Service_Detail_Recs (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
2076: )Return Number Is
2077:
2078: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
2079: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
2080: l_proc_name Varchar2(150):= g_proc_name||'Del_Service_Detail_Recs';
2081: l_return_value Number := 0; --0= Sucess, -1=Error
2082:
2083: Begin