APPS.PAY_PGP_INS dependencies on PAY_PEOPLE_GROUPS

Line 59: -- Insert the row into: pay_people_groups

55: hr_utility.set_location('Entering:'||l_proc, 5);
56: --
57: pay_pgp_shd.g_api_dml := true; -- Set the api dml status
58: --
59: -- Insert the row into: pay_people_groups
60: --
61: insert into pay_people_groups
62: ( people_group_id,
63: group_name,

Line 61: insert into pay_people_groups

57: pay_pgp_shd.g_api_dml := true; -- Set the api dml status
58: --
59: -- Insert the row into: pay_people_groups
60: --
61: insert into pay_people_groups
62: ( people_group_id,
63: group_name,
64: id_flex_num,
65: summary_flag,

Line 205: Cursor C_Sel1 is select pay_people_groups_s.nextval from sys.dual;

201: Procedure pre_insert(p_rec in out pay_pgp_shd.g_rec_type) is
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';
204: --
205: Cursor C_Sel1 is select pay_people_groups_s.nextval from sys.dual;
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --

Line 513: l_people_group_id pay_people_groups.people_group_id%type;

509: p_people_group_id out number,
510: p_group_name out varchar2,
511: p_validate in boolean default false) is
512: --
513: l_people_group_id pay_people_groups.people_group_id%type;
514: l_group_name pay_people_groups.group_name%type;
515: l_id_flex_num pay_people_groups.id_flex_num%type;
516: l_proc varchar2(72) := g_package||'ins_or_sel';
517: --

Line 514: l_group_name pay_people_groups.group_name%type;

510: p_group_name out varchar2,
511: p_validate in boolean default false) is
512: --
513: l_people_group_id pay_people_groups.people_group_id%type;
514: l_group_name pay_people_groups.group_name%type;
515: l_id_flex_num pay_people_groups.id_flex_num%type;
516: l_proc varchar2(72) := g_package||'ins_or_sel';
517: --
518: --

Line 515: l_id_flex_num pay_people_groups.id_flex_num%type;

511: p_validate in boolean default false) is
512: --
513: l_people_group_id pay_people_groups.people_group_id%type;
514: l_group_name pay_people_groups.group_name%type;
515: l_id_flex_num pay_people_groups.id_flex_num%type;
516: l_proc varchar2(72) := g_package||'ins_or_sel';
517: --
518: --
519: begin