DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on FND_PROFILE

Line 5987: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');

5983: END IF; -- Global Element Introduced for Element Entry Overrides
5984:
5985:
5986: if p_mode = 'D' then --- introduced for 3813688
5987: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');
5988: open get_control_id;
5989: fetch get_control_id into l_payroll_control_id;
5990: close get_control_id;
5991:

Line 8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

8410: from per_time_periods
8411: where time_period_id = g_time_period_id;
8412: end if;
8413:
8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8415: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8418:

Line 8415: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

8411: where time_period_id = g_time_period_id;
8412: end if;
8413:
8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8415: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8418:
8419: -- moved from archive part .. 4744285, commented for 5080403 and introduced below cursor

Line 8420: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');

8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8418:
8419: -- moved from archive part .. 4744285, commented for 5080403 and introduced below cursor
8420: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');
8421: open autopop_config_cur;
8422: fetch autopop_config_cur into g_global_element_autopop,
8423: g_asg_element_autopop,
8424: g_asg_ele_group_autopop,

Line 8434: g_use_eff_date := FND_PROFILE.VALUE('PSP_USE_NON_ORACLE_EFFECTIVE_DATE'); /* bug 1874696 */

8430: close autopop_config_cur;
8431:
8432: --dbms_output.put_line('value of profile is '||g_auto_population);
8433:
8434: g_use_eff_date := FND_PROFILE.VALUE('PSP_USE_NON_ORACLE_EFFECTIVE_DATE'); /* bug 1874696 */
8435:
8436: g_dff_grouping_option := psp_general.get_act_dff_grouping_option(g_business_group_id); -- Introduced for bug fix 2908859
8437:
8438: g_salary_cap_option := psp_general.get_configuration_option_value(g_business_group_id, 'PSP_ENABLE_SALARY_CAP');

Line 8536: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

8532: g_payroll_id
8533: from pay_payroll_actions ppa
8534: where ppa.payroll_action_id = pactid;
8535:
8536: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8537: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8538:
8539:
8540: --#fnd_file.put_line(fnd_file.log,'########ENTERED RangeCode#######pactid, g_source_code='||pactid||','|| g_source_code);

Line 8537: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

8533: from pay_payroll_actions ppa
8534: where ppa.payroll_action_id = pactid;
8535:
8536: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8537: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8538:
8539:
8540: --#fnd_file.put_line(fnd_file.log,'########ENTERED RangeCode#######pactid, g_source_code='||pactid||','|| g_source_code);
8541: open get_control_ids;

Line 8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

8792: into g_payroll_id
8793: from per_time_periods
8794: where time_period_id = g_time_period_id;
8795: end if;
8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8798: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8799: --#fnd_file.put_line(fnd_file.log,p_pactid||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8800:

Line 8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

8793: from per_time_periods
8794: where time_period_id = g_time_period_id;
8795: end if;
8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8798: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8799: --#fnd_file.put_line(fnd_file.log,p_pactid||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8800:
8801: open get_assignments(p_pactid, stasg, endasg, psp_labor_dist.g_time_period_id);

Line 8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

8842: g_payroll_id
8843: from pay_payroll_actions ppa
8844: where ppa.payroll_action_id = pactid;
8845:
8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);

Line 8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

8843: from pay_payroll_actions ppa
8844: where ppa.payroll_action_id = pactid;
8845:
8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);