APPS.PAY_FR_DB_PAY_SETUP dependencies on STANDARD

Line 29: p_standard_link_flag varchar2 default 'N',

25: p_mult_entries_allowed varchar2 default 'N',
26: p_formula_id number default NULL,
27: p_processing_priority number default NULL,
28: p_closed_for_entry_flag varchar2 default 'N',
29: p_standard_link_flag varchar2 default 'N',
30: p_qual_length_of_service number default NULL,
31: p_qual_units varchar2 default NULL,
32: p_qual_age number default NULL,
33: p_process_in_run_flag varchar2 default 'Y',

Line 120: 'Last Standard Process','L',

116: or
117: hl.lookup_code =
118: decode(p_post_termination_rule, 'Actual Termination','A',
119: 'Final Close', 'F',
120: 'Last Standard Process','L',
121: p_post_termination_rule));
122: --
123: -- Default the start date to the session date if no date is supplied
124: if p_effective_start_date is not NULL then

Line 226: p_standard_flag => p_standard_link_flag,

222: p_val_end_date => v_effective_end_date,
223: p_reporting_name => p_reporting_name,
224: p_rowid => NULL,
225: p_recurring_flag => p_processing_type,
226: p_standard_flag => p_standard_link_flag,
227: p_scndry_ent_allwd_flag => p_add_entry_allowed_flag,
228: p_process_in_run_flag => p_process_in_run_flag,
229: p_indirect_only_flag => p_indirect_only_flag,
230: p_adjustment_only_flag => p_adjustment_only_flag,

Line 270: P_STANDARD_LINK_FLAG =>p_standard_link_flag,

266: P_POST_TERMINATION_RULE =>v_post_term_rule,
267: P_PROCESS_IN_RUN_FLAG =>p_process_in_run_flag,
268: P_PROCESSING_PRIORITY =>v_processing_priority,
269: P_PROCESSING_TYPE =>p_processing_type,
270: P_STANDARD_LINK_FLAG =>p_standard_link_flag,
271: P_COMMENT_ID =>NULL,
272: P_DESCRIPTION =>p_description,
273: P_LEGISLATION_SUBGROUP =>p_legislation_subgroup,
274: P_QUALIFYING_AGE =>p_qual_age,

Line 1099: p_standard_link_flag varchar2 default NULL,

1095: p_element_set_id number default NULL,
1096: p_costable_type varchar2 default 'N',
1097: p_link_to_all_pyrlls_fl varchar2 default 'N',
1098: p_multiply_value_flag varchar2 default 'N',
1099: p_standard_link_flag varchar2 default NULL,
1100: p_transfer_to_gl_flag varchar2 default 'N',
1101: p_qual_age number default NULL,
1102: p_qual_lngth_of_service number default NULL,
1103: p_qual_units varchar2 default NULL,

Line 1123: v_el_standard_link_flag varchar2(30);

1119: v_effective_end_date date;
1120: v_element_type_id number;
1121: v_element_start_date date;
1122: v_element_end_date date;
1123: v_el_standard_link_flag varchar2(30);
1124: v_el_multiply_value_flag varchar2(30);
1125: v_el_qual_age number;
1126: v_el_qual_lngth_of_service number;
1127: v_el_qual_units varchar2(30);

Line 1202: et.standard_link_flag,

1198: --
1199: -- Get information from element for defaulting
1200: select max(et.effective_end_date),
1201: et.element_type_id,
1202: et.standard_link_flag,
1203: et.multiply_value_flag,
1204: et.qualifying_age,
1205: et.qualifying_length_of_service,
1206: et.qualifying_units

Line 1209: v_el_standard_link_flag,

1205: et.qualifying_length_of_service,
1206: et.qualifying_units
1207: into v_element_end_date,
1208: v_element_type_id,
1209: v_el_standard_link_flag,
1210: v_el_multiply_value_flag,
1211: v_el_qual_age,
1212: v_el_qual_lngth_of_service,
1213: v_el_qual_units

Line 1220: group by et.element_type_id, et.standard_link_flag, et.multiply_value_flag,

1216: and (et.business_group_id + 0 = v_business_group_id
1217: or (et.business_group_id is null
1218: and et.legislation_code = v_legislation_code)
1219: or (et.business_group_id is null and et.legislation_code is null))
1220: group by et.element_type_id, et.standard_link_flag, et.multiply_value_flag,
1221: et.qualifying_age, et.qualifying_length_of_service,
1222: et.qualifying_units;
1223: --
1224: if g_debug then

Line 1351: STANDARD_LINK_FLAG,

1347: ELEMENT_SET_ID,
1348: COSTABLE_TYPE,
1349: LINK_TO_ALL_PAYROLLS_FLAG,
1350: MULTIPLY_VALUE_FLAG,
1351: STANDARD_LINK_FLAG,
1352: TRANSFER_TO_GL_FLAG,
1353: COMMENT_ID,
1354: QUALIFYING_AGE,
1355: QUALIFYING_LENGTH_OF_SERVICE,

Line 1381: nvl(p_standard_link_flag,v_el_standard_link_flag),

1377: NULL, -- Do not worry about distribution set
1378: p_costable_type,
1379: p_link_to_all_pyrlls_fl,
1380: nvl(p_multiply_value_flag,v_el_multiply_value_flag),
1381: nvl(p_standard_link_flag,v_el_standard_link_flag),
1382: p_transfer_to_gl_flag,
1383: NULL, -- Do not worry about comments
1384: nvl(p_qual_age,v_el_qual_age),
1385: nvl(p_qual_lngth_of_service,v_el_qual_lngth_of_service),

Line 1733: -- bg and leg code of the balance being inserted. This enables standard startup

1729: -- get and check the base_balance_type_id
1730: --
1731: -- l_ctl_bg and l_ctl_leg are the equivalent to the ctl_globals variables in
1732: -- the form. They are set here by basing the current mode on the values for
1733: -- bg and leg code of the balance being inserted. This enables standard startup
1734: -- table validation, e.g. if inserting a startup balance (leg code not null)
1735: -- then user base balances (bg not null) will be invalid.
1736: -- l_mode is used in the creation of primary balance feed.
1737: --

Line 2352: p_standard_form_title varchar2,

2348: ( p_business_group_id number default NULL,
2349: p_name varchar2,
2350: p_form_name varchar2,
2351: p_query_form_title varchar2,
2352: p_standard_form_title varchar2,
2353: p_enabled_flag varchar2 default 'N',
2354: p_legislation_subgroup varchar2 default NULL,
2355: p_legislation_code varchar2 default NULL
2356: ) return number is

Line 2433: X_STANDARD_FORM_TITLE => p_standard_form_title,

2429: X_NAME => p_name,
2430: X_COMMENTS => null,
2431: X_LEGISLATION_SUBGROUP => p_legislation_subgroup,
2432: X_QUERY_FORM_TITLE => p_query_form_title,
2433: X_STANDARD_FORM_TITLE => p_standard_form_title,
2434: X_CREATION_DATE => v_todays_date,
2435: X_CREATED_BY => -1,
2436: X_LAST_UPDATE_DATE => v_todays_date,
2437: X_LAST_UPDATED_BY => -1,