APPS.PAY_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 121: 'Last Standard Process','L',

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

Line 227: p_standard_flag => p_standard_link_flag,

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

Line 271: P_STANDARD_LINK_FLAG =>p_standard_link_flag,

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

Line 1101: p_standard_link_flag varchar2 default NULL,

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

Line 1125: v_el_standard_link_flag varchar2(30);

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

Line 1204: et.standard_link_flag,

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

Line 1211: v_el_standard_link_flag,

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

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

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

Line 1353: STANDARD_LINK_FLAG,

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

Line 1383: nvl(p_standard_link_flag,v_el_standard_link_flag),

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

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

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

Line 2345: p_standard_form_title varchar2,

2341: ( p_business_group_id number default NULL,
2342: p_name varchar2,
2343: p_form_name varchar2,
2344: p_query_form_title varchar2,
2345: p_standard_form_title varchar2,
2346: p_enabled_flag varchar2 default 'N',
2347: p_legislation_subgroup varchar2 default NULL,
2348: p_legislation_code varchar2 default NULL
2349: ) return number is

Line 2426: X_STANDARD_FORM_TITLE => p_standard_form_title,

2422: X_NAME => p_name,
2423: X_COMMENTS => null,
2424: X_LEGISLATION_SUBGROUP => p_legislation_subgroup,
2425: X_QUERY_FORM_TITLE => p_query_form_title,
2426: X_STANDARD_FORM_TITLE => p_standard_form_title,
2427: X_CREATION_DATE => v_todays_date,
2428: X_CREATED_BY => -1,
2429: X_LAST_UPDATE_DATE => v_todays_date,
2430: X_LAST_UPDATED_BY => -1,