APPS.PAY_LOAD_PROCESS_FLOWS dependencies on PAY_PROCESS_FLOW_SETS

Line 578: -- Procedure used to upload seed data for the table PAY_PROCESS_FLOW_SETS

574: -- |-------------------------< load_process_flow_sets >------------------------|
575: -- ----------------------------------------------------------------------------
576: --
577: -- Description:
578: -- Procedure used to upload seed data for the table PAY_PROCESS_FLOW_SETS
579: --
580: -- ----------------------------------------------------------------------------
581: procedure load_process_flow_sets
582: ( p_flow_name in varchar2

Line 593: from pay_process_flow_sets pfs,

589:
590: cursor pfsexists( p_flow_name varchar2
591: ,p_set_name varchar2) is
592: select pfs.process_flow_set_id
593: from pay_process_flow_sets pfs,
594: pay_process_flows ppf,
595: pay_parameter_sets pps1,
596: pay_parameter_sets pps2,
597: pay_parameters pp1,

Line 660: UPDATE PAY_PROCESS_FLOW_SETS SET

656: end if;
657: --
658: if(found = TRUE) then
659:
660: UPDATE PAY_PROCESS_FLOW_SETS SET
661: process_flow_seq = p_proc_flow_seq
662: ,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
663: ,LAST_UPDATE_DATE = SYSDATE
664: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 680: INSERT INTO PAY_PROCESS_FLOW_SETS (

676:
677: hr_utility.trace('Before inserting, l_set_id: '|| l_set_id);
678: hr_utility.trace('Before inserting, l_process_flow_id: '|| l_process_flow_id);
679:
680: INSERT INTO PAY_PROCESS_FLOW_SETS (
681: process_flow_set_id
682: , process_flow_id
683: , set_id
684: , process_flow_seq

Line 693: PAY_PROCESS_FLOW_SETS_S.nextval

689: ,LAST_UPDATE_LOGIN
690: ,CREATION_DATE
691: ,CREATED_BY )
692: VALUES (
693: PAY_PROCESS_FLOW_SETS_S.nextval
694: , l_process_flow_id
695: , l_set_id
696: , p_proc_flow_seq
697: , l_business_group_id