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 1124: p_standard_link_flag varchar2 default NULL,

1120: p_element_set_id number default NULL,
1121: p_costable_type varchar2 default 'N',
1122: p_link_to_all_pyrlls_fl varchar2 default 'N',
1123: p_multiply_value_flag varchar2 default 'N',
1124: p_standard_link_flag varchar2 default NULL,
1125: p_transfer_to_gl_flag varchar2 default 'N',
1126: p_qual_age number default NULL,
1127: p_qual_lngth_of_service number default NULL,
1128: p_qual_units varchar2 default NULL,

Line 1148: v_el_standard_link_flag varchar2(30);

1144: v_effective_end_date date;
1145: v_element_type_id number;
1146: v_element_start_date date;
1147: v_element_end_date date;
1148: v_el_standard_link_flag varchar2(30);
1149: v_el_multiply_value_flag varchar2(30);
1150: v_el_qual_age number;
1151: v_el_qual_lngth_of_service number;
1152: v_el_qual_units varchar2(30);

Line 1227: et.standard_link_flag,

1223: --
1224: -- Get information from element for defaulting
1225: select max(et.effective_end_date),
1226: et.element_type_id,
1227: et.standard_link_flag,
1228: et.multiply_value_flag,
1229: et.qualifying_age,
1230: et.qualifying_length_of_service,
1231: et.qualifying_units

Line 1234: v_el_standard_link_flag,

1230: et.qualifying_length_of_service,
1231: et.qualifying_units
1232: into v_element_end_date,
1233: v_element_type_id,
1234: v_el_standard_link_flag,
1235: v_el_multiply_value_flag,
1236: v_el_qual_age,
1237: v_el_qual_lngth_of_service,
1238: v_el_qual_units

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

1241: and (et.business_group_id + 0 = v_business_group_id
1242: or (et.business_group_id is null
1243: and et.legislation_code = v_legislation_code)
1244: or (et.business_group_id is null and et.legislation_code is null))
1245: group by et.element_type_id, et.standard_link_flag, et.multiply_value_flag,
1246: et.qualifying_age, et.qualifying_length_of_service,
1247: et.qualifying_units;
1248: --
1249: if g_debug then

Line 1376: STANDARD_LINK_FLAG,

1372: ELEMENT_SET_ID,
1373: COSTABLE_TYPE,
1374: LINK_TO_ALL_PAYROLLS_FLAG,
1375: MULTIPLY_VALUE_FLAG,
1376: STANDARD_LINK_FLAG,
1377: TRANSFER_TO_GL_FLAG,
1378: COMMENT_ID,
1379: QUALIFYING_AGE,
1380: QUALIFYING_LENGTH_OF_SERVICE,

Line 1406: nvl(p_standard_link_flag,v_el_standard_link_flag),

1402: NULL, -- Do not worry about distribution set
1403: p_costable_type,
1404: p_link_to_all_pyrlls_fl,
1405: nvl(p_multiply_value_flag,v_el_multiply_value_flag),
1406: nvl(p_standard_link_flag,v_el_standard_link_flag),
1407: p_transfer_to_gl_flag,
1408: NULL, -- Do not worry about comments
1409: nvl(p_qual_age,v_el_qual_age),
1410: nvl(p_qual_lngth_of_service,v_el_qual_lngth_of_service),

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

1754: -- get and check the base_balance_type_id
1755: --
1756: -- l_ctl_bg and l_ctl_leg are the equivalent to the ctl_globals variables in
1757: -- the form. They are set here by basing the current mode on the values for
1758: -- bg and leg code of the balance being inserted. This enables standard startup
1759: -- table validation, e.g. if inserting a startup balance (leg code not null)
1760: -- then user base balances (bg not null) will be invalid.
1761: -- l_mode is used in the creation of primary balance feed.
1762: --

Line 2368: p_standard_form_title varchar2,

2364: ( p_business_group_id number default NULL,
2365: p_name varchar2,
2366: p_form_name varchar2,
2367: p_query_form_title varchar2,
2368: p_standard_form_title varchar2,
2369: p_enabled_flag varchar2 default 'N',
2370: p_legislation_subgroup varchar2 default NULL,
2371: p_legislation_code varchar2 default NULL
2372: ) return number is

Line 2449: X_STANDARD_FORM_TITLE => p_standard_form_title,

2445: X_NAME => p_name,
2446: X_COMMENTS => null,
2447: X_LEGISLATION_SUBGROUP => p_legislation_subgroup,
2448: X_QUERY_FORM_TITLE => p_query_form_title,
2449: X_STANDARD_FORM_TITLE => p_standard_form_title,
2450: X_CREATION_DATE => v_todays_date,
2451: X_CREATED_BY => -1,
2452: X_LAST_UPDATE_DATE => v_todays_date,
2453: X_LAST_UPDATED_BY => -1,