APPS.PQP_GB_OSP_TEMPLATE dependencies on PQP_CONFIGURATION_MODULES

Line 491: l_module_id pqp_configuration_modules.module_id%TYPE ;

487: -- PROCEDURE create_config_data
488: --======================================================================
489: PROCEDURE create_config_data IS
490:
491: l_module_id pqp_configuration_modules.module_id%TYPE ;
492: l_proc_step NUMBER(20,10);
493: l_proc_name VARCHAR2(61):=
494: g_package_name||'create_config_data';
495:

Line 501: INSERT INTO PQP_CONFIGURATION_MODULES

497:
498: debug_enter(l_proc_name);
499:
500:
501: INSERT INTO PQP_CONFIGURATION_MODULES
502: ( MODULE_ID -- pqp_configuration_modules_s.nextval
503: ,MODULE_NAME -- 'Absence Schemes'
504: ,BUSINESS_GROUP_ID -- NULL
505: ,LEGISLATION_CODE -- 'GB'

Line 502: ( MODULE_ID -- pqp_configuration_modules_s.nextval

498: debug_enter(l_proc_name);
499:
500:
501: INSERT INTO PQP_CONFIGURATION_MODULES
502: ( MODULE_ID -- pqp_configuration_modules_s.nextval
503: ,MODULE_NAME -- 'Absence Schemes'
504: ,BUSINESS_GROUP_ID -- NULL
505: ,LEGISLATION_CODE -- 'GB'
506: ,DESCRIPTION -- 'GB Absence Schemes OSP/OMP'

Line 516: pqp_configuration_modules_s.nextval

512: ,CREATED_BY -- 2
513: ,CREATION_DATE -- hr_api.g_sot -- DO NOT USE SYSDATE
514: )
515: SELECT
516: pqp_configuration_modules_s.nextval
517: ,'Absence Schemes'
518: ,NULL
519: ,'GB'
520: ,'GB Absence Schemes OSP/OMP'

Line 530: ( SELECT 1 FROM pqp_configuration_modules

526: ,2
527: ,hr_api.g_sot
528: FROM DUAL
529: WHERE NOT EXISTS
530: ( SELECT 1 FROM pqp_configuration_modules
531: WHERE module_name = 'Absence Schemes'
532: and legislation_code = 'GB'
533: );
534:

Line 538: FROM pqp_configuration_modules

534:
535:
536: SELECT module_id
537: INTO l_module_id
538: FROM pqp_configuration_modules
539: where module_name = 'Absence Schemes'
540: and legislation_code = 'GB' ;
541:
542:

Line 3168: -- creates values in pqp_configuration_modules

3164: ,p_template_id => l_template_id
3165: ) ;
3166:
3167: -- Elements Links are created Here
3168: -- creates values in pqp_configuration_modules
3169: -- ,pqp_configuration_types table.
3170: -- once the lct, ldt are finalized to ship these values this code
3171: -- will be replaced by a proper ldt.
3172: