DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on FND_FLEX_KEY_API

Line 1199: l_flexfield fnd_flex_key_api.flexfield_type;

1195: p_shorthand_enabled_flag IN VARCHAR2,
1196: p_shorthand_prompt IN VARCHAR2,
1197: p_shorthand_length IN NUMBER) RETURN NUMBER IS
1198:
1199: l_flexfield fnd_flex_key_api.flexfield_type;
1200: l_structure fnd_flex_key_api.structure_type;
1201: l_application_id NUMBER(15);
1202: l_exists varchar2(1);
1203:

Line 1200: l_structure fnd_flex_key_api.structure_type;

1196: p_shorthand_prompt IN VARCHAR2,
1197: p_shorthand_length IN NUMBER) RETURN NUMBER IS
1198:
1199: l_flexfield fnd_flex_key_api.flexfield_type;
1200: l_structure fnd_flex_key_api.structure_type;
1201: l_application_id NUMBER(15);
1202: l_exists varchar2(1);
1203:
1204:

Line 1224: fnd_flex_key_api.set_session_mode('seed_data');

1220: FROM FND_APPLICATION
1221: WHERE application_short_name = p_appl_Short_Name;
1222:
1223: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1224: fnd_flex_key_api.set_session_mode('seed_data');
1225:
1226: l_flexfield := fnd_flex_key_api.find_flexfield
1227: ( appl_short_name => p_appl_short_name,
1228: flex_code => p_flex_code );

Line 1226: l_flexfield := fnd_flex_key_api.find_flexfield

1222:
1223: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1224: fnd_flex_key_api.set_session_mode('seed_data');
1225:
1226: l_flexfield := fnd_flex_key_api.find_flexfield
1227: ( appl_short_name => p_appl_short_name,
1228: flex_code => p_flex_code );
1229:
1230: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);

Line 1233: l_structure := fnd_flex_key_api.find_structure

1229:
1230: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',20);
1231: BEGIN
1232:
1233: l_structure := fnd_flex_key_api.find_structure
1234: ( flexfield => l_flexfield,
1235: structure_code => p_structure_code );
1236:
1237: return l_structure.structure_number;

Line 1255: l_structure:=fnd_flex_key_api.new_structure

1251: END IF;
1252:
1253: CLOSE duplicate_structure_check;
1254:
1255: l_structure:=fnd_flex_key_api.new_structure
1256: (flexfield => l_flexfield,
1257: structure_code => p_structure_code,
1258: structure_title => p_structure_title,
1259: description => p_description,

Line 1283: fnd_flex_key_api.add_structure

1279: WHERE ifs.application_id = l_application_id
1280: AND ifs.id_flex_code = p_flex_code
1281: AND ifs.id_flex_num < 101;
1282:
1283: fnd_flex_key_api.add_structure
1284: ( flexfield => l_flexfield,
1285: structure => l_structure );
1286:
1287: RETURN l_structure.structure_number;

Line 1314: l_flexfield fnd_flex_key_api.flexfield_type;

1310: p_lov_prompt IN VARCHAR2,
1311: p_window_prompt IN VARCHAR2
1312: ) IS
1313:
1314: l_flexfield fnd_flex_key_api.flexfield_type;
1315: l_structure fnd_flex_key_api.structure_type;
1316: l_application_id NUMBER(15);
1317: l_flex_num NUMBER(15);
1318: l_segment fnd_flex_key_api.segment_type;

Line 1315: l_structure fnd_flex_key_api.structure_type;

1311: p_window_prompt IN VARCHAR2
1312: ) IS
1313:
1314: l_flexfield fnd_flex_key_api.flexfield_type;
1315: l_structure fnd_flex_key_api.structure_type;
1316: l_application_id NUMBER(15);
1317: l_flex_num NUMBER(15);
1318: l_segment fnd_flex_key_api.segment_type;
1319: BEGIN

Line 1318: l_segment fnd_flex_key_api.segment_type;

1314: l_flexfield fnd_flex_key_api.flexfield_type;
1315: l_structure fnd_flex_key_api.structure_type;
1316: l_application_id NUMBER(15);
1317: l_flex_num NUMBER(15);
1318: l_segment fnd_flex_key_api.segment_type;
1319: BEGIN
1320:
1321: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1322: fnd_flex_key_api.set_session_mode('seed_data');

Line 1322: fnd_flex_key_api.set_session_mode('seed_data');

1318: l_segment fnd_flex_key_api.segment_type;
1319: BEGIN
1320:
1321: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1322: fnd_flex_key_api.set_session_mode('seed_data');
1323: l_flexfield := fnd_flex_key_api.find_flexfield
1324: ( appl_short_name => p_appl_short_name,
1325: flex_code => p_flex_code );
1326:

Line 1323: l_flexfield := fnd_flex_key_api.find_flexfield

1319: BEGIN
1320:
1321: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',10);
1322: fnd_flex_key_api.set_session_mode('seed_data');
1323: l_flexfield := fnd_flex_key_api.find_flexfield
1324: ( appl_short_name => p_appl_short_name,
1325: flex_code => p_flex_code );
1326:
1327: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);

Line 1329: l_structure := fnd_flex_key_api.find_structure

1325: flex_code => p_flex_code );
1326:
1327: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',11);
1328:
1329: l_structure := fnd_flex_key_api.find_structure
1330: ( flexfield => l_flexfield,
1331: structure_code => p_structure_code );
1332:
1333: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);

Line 1337: l_segment := fnd_flex_key_api.find_segment

1333: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',12);
1334: begin
1335:
1336: hr_utility.trace(p_segment_name);
1337: l_segment := fnd_flex_key_api.find_segment
1338: (
1339: flexfield => l_flexfield
1340: ,structure => l_structure
1341: ,segment_name => p_segment_name

Line 1345: l_segment:= fnd_flex_key_api.new_segment

1341: ,segment_name => p_segment_name
1342: );
1343: exception
1344: when no_data_found then
1345: l_segment:= fnd_flex_key_api.new_segment
1346: (
1347: flexfield => l_flexfield
1348: ,structure => l_structure
1349: ,segment_name => p_segment_name

Line 1372: fnd_flex_key_api.add_segment

1368: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',13);
1369:
1370: hr_utility.trace(p_segment_name);
1371: begin
1372: fnd_flex_key_api.add_segment
1373: (
1374: flexfield => l_flexfield
1375: ,structure => l_structure
1376: ,segment => l_segment

Line 1380: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));

1376: ,segment => l_segment
1377: );
1378: exception
1379: when others then
1380: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1381: end;
1382: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1383: fnd_flex_key_api.assign_qualifier
1384: (

Line 1383: fnd_flex_key_api.assign_qualifier

1379: when others then
1380: hr_utility.trace(substr(fnd_flex_key_api.message,1,256));
1381: end;
1382: hr_utility.set_location('pay_ip_startup_util.create_key_segments ',14);
1383: fnd_flex_key_api.assign_qualifier
1384: (
1385: flexfield => l_flexfield
1386: ,structure => l_structure
1387: ,segment => l_segment