eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 4645: ,ben_ext_rslt_dtl rdtl

4641: CURSOR csr_person_reported IS
4642: SELECT 'Y'
4643: FROM pqp_extract_attributes pqea
4644: ,ben_ext_rslt rslt
4645: ,ben_ext_rslt_dtl rdtl
4646: ,ben_ext_rcd drcd
4647: WHERE pqea.ext_dfn_type = g_extract_type
4648: AND rslt.ext_dfn_id = pqea.ext_dfn_id
4649: -- Bugfix 3073562:GAP1:GAP2, now using master bg id

Line 4669: FROM ben_ext_rslt_dtl rdtl1

4665: )
4666: -- match the header element
4667: AND EXISTS
4668: ( SELECT 'Y'
4669: FROM ben_ext_rslt_dtl rdtl1
4670: WHERE rdtl1.business_group_id = g_master_bg_id
4671: AND EXISTS
4672: ( SELECT 'Y'
4673: FROM ben_ext_rcd drcd1

Line 12331: l_withdrawal_conf ben_ext_rslt_dtl.val_15%TYPE := ' ';

12327: (p_assignment_id IN NUMBER
12328: ) RETURN VARCHAR2
12329: IS
12330:
12331: l_withdrawal_conf ben_ext_rslt_dtl.val_15%TYPE := ' ';
12332: l_proc_name varchar2(60) := g_proc_name || 'get_tp1_withdrawal_conf';
12333:
12334: BEGIN
12335:

Line 13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;

13809: l_temp_date DATE;
13810: l_temp_date_primary DATE;
13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
13816: l_rowcount NUMBER:=0;
13817: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;

Line 13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;

13810: l_temp_date_primary DATE;
13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
13816: l_rowcount NUMBER:=0;
13817: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
13818: l_asg_details csr_asg_details_up%ROWTYPE;

Line 13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;

13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
13816: l_rowcount NUMBER:=0;
13817: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
13818: l_asg_details csr_asg_details_up%ROWTYPE;
13819: l_temp_location_id per_all_assignments_f.location_id%TYPE;

Line 13875: -- ben_ext_rslt_dtl where the data element will be stored.

13871:
13872: -- PS : The serial numbers below are calcualted as
13873: -- (actual position of the data element) + 1
13874: -- This serial number gives us the column name in the table
13875: -- ben_ext_rslt_dtl where the data element will be stored.
13876: -- E.g. Salary Scale will be stored in column val_11
13877:
13878: -- Bugfix 3803760:FTSUPPLY
13879: -- Set the effective assignments as of effective start date

Line 14669: PROCEDURE upd_rslt_dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE)

14665: p_dtl_rec := l_dtl_rec_nc;
14666: RAISE;
14667: END; -- recalc_data_elements
14668:
14669: PROCEDURE upd_rslt_dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE)
14670: IS
14671:
14672: l_proc_name VARCHAR2(61):=
14673: g_proc_name||'upd_rslt_dtl';

Line 14679: UPDATE ben_ext_rslt_dtl

14675: BEGIN -- upd_rslt_dtl
14676:
14677: debug_enter(l_proc_name);
14678:
14679: UPDATE ben_ext_rslt_dtl
14680: SET VAL_01 = p_dtl_rec.VAL_01
14681: ,VAL_02 = p_dtl_rec.VAL_02
14682: ,VAL_03 = p_dtl_rec.VAL_03
14683: ,VAL_04 = p_dtl_rec.VAL_04

Line 14769: PROCEDURE ins_rslt_dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE)

14765: debug_exit(' Others in '||l_proc_name);
14766: RAISE;
14767: END; -- upd_rslt_dtl
14768:
14769: PROCEDURE ins_rslt_dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE)
14770: IS
14771:
14772:
14773: -- nocopy changes

Line 14774: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

14770: IS
14771:
14772:
14773: -- nocopy changes
14774: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
14775:
14776:
14777: l_proc_name VARCHAR2(61):=
14778: g_proc_name||'ins_rslt_dtl';

Line 14787: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

14783:
14784: -- nocopy changes
14785: l_dtl_rec_nc := p_dtl_rec;
14786:
14787: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14788:
14789: INSERT INTO ben_ext_rslt_dtl
14790: (EXT_RSLT_DTL_ID
14791: ,EXT_RSLT_ID

Line 14789: INSERT INTO ben_ext_rslt_dtl

14785: l_dtl_rec_nc := p_dtl_rec;
14786:
14787: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14788:
14789: INSERT INTO ben_ext_rslt_dtl
14790: (EXT_RSLT_DTL_ID
14791: ,EXT_RSLT_ID
14792: ,BUSINESS_GROUP_ID
14793: ,EXT_RCD_ID

Line 16710: FROM ben_ext_rslt_dtl dtl

16706: FETCH csr_ext_rcd_id INTO l_ext_dtl_rcd_id;
16707: CLOSE csr_ext_rcd_id;
16708:
16709: DELETE
16710: FROM ben_ext_rslt_dtl dtl
16711: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
16712: AND dtl.ext_rcd_id = l_ext_dtl_rcd_id
16713: AND dtl.val_01 = 'DELETE';
16714:

Line 16730: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE

16726: --
16727: -- type1_post_proc_rule
16728: --
16729: FUNCTION type1_post_proc_rule
16730: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE
16731: ) RETURN VARCHAR2
16732: IS
16733:
16734: -- Variable Declaration