DBA Data[Home] [Help]

APPS.PA_PROJECT_ASSETS_PUB dependencies on FND_FLEX_KEY_API

Line 321: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;

317: v_asset_key_required VARCHAR2(1);
318: v_depreciation_expense_ccid NUMBER;
319:
320: --Variable used for validation of required Asset KFF segments
321: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
322: numstruct NUMBER;
323: structnum NUMBER;
324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;

Line 324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;

320: --Variable used for validation of required Asset KFF segments
321: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
322: numstruct NUMBER;
323: structnum NUMBER;
324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
326: numsegs NUMBER;
327: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
328: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;

Line 325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;

321: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
322: numstruct NUMBER;
323: structnum NUMBER;
324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
326: numsegs NUMBER;
327: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
328: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
329: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;

Line 327: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;

323: structnum NUMBER;
324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
326: numsegs NUMBER;
327: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
328: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
329: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
330:
331: BEGIN

Line 328: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;

324: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
325: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
326: numsegs NUMBER;
327: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
328: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
329: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
330:
331: BEGIN
332:

Line 1455: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');

1451: END;
1452:
1453: IF structnum IS NOT NULL THEN
1454:
1455: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');
1456:
1457: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
1458: (appl_short_name =>'OFA',
1459: flex_code =>'KEY#');

Line 1457: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD

1453: IF structnum IS NOT NULL THEN
1454:
1455: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');
1456:
1457: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
1458: (appl_short_name =>'OFA',
1459: flex_code =>'KEY#');
1460:
1461: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);

Line 1461: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);

1457: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
1458: (appl_short_name =>'OFA',
1459: flex_code =>'KEY#');
1460:
1461: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);
1462:
1463: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);
1464:
1465: v_asset_key_required := 'N';

Line 1463: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);

1459: flex_code =>'KEY#');
1460:
1461: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);
1462:
1463: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);
1464:
1465: v_asset_key_required := 'N';
1466:
1467: FOR i IN 1 .. numsegs LOOP

Line 1468: segtype := FND_FLEX_KEY_API.FIND_SEGMENT(fftype,thestruct,listsegs(i));

1464:
1465: v_asset_key_required := 'N';
1466:
1467: FOR i IN 1 .. numsegs LOOP
1468: segtype := FND_FLEX_KEY_API.FIND_SEGMENT(fftype,thestruct,listsegs(i));
1469:
1470: IF (segtype.required_flag = 'Y' and segtype.enabled_flag = 'Y') THEN
1471: v_asset_key_required := 'Y';
1472: END IF;

Line 3127: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;

3123: l_asset_category_id NUMBER;
3124: l_dpis DATE;
3125:
3126: --Variables used for validation of required Asset KFF segments
3127: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
3128: numstruct NUMBER;
3129: structnum NUMBER;
3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;

Line 3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;

3126: --Variables used for validation of required Asset KFF segments
3127: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
3128: numstruct NUMBER;
3129: structnum NUMBER;
3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
3132: numsegs NUMBER;
3133: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;

Line 3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;

3127: fftype FND_FLEX_KEY_API.FLEXFIELD_TYPE;
3128: numstruct NUMBER;
3129: structnum NUMBER;
3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
3132: numsegs NUMBER;
3133: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
3135: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;

Line 3133: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;

3129: structnum NUMBER;
3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
3132: numsegs NUMBER;
3133: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
3135: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
3136:
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct

Line 3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;

3130: liststruct FND_FLEX_KEY_API.STRUCTURE_LIST;
3131: thestruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
3132: numsegs NUMBER;
3133: listsegs FND_FLEX_KEY_API.SEGMENT_LIST;
3134: segtype FND_FLEX_KEY_API.SEGMENT_TYPE;
3135: segname FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE;
3136:
3137: --Variables used as Bind Parameters for the Dynamic SQL Construct
3138: b_pm_asset_reference PA_PROJECT_ASSETS_ALL.pm_asset_reference%TYPE;

Line 5229: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');

5225: END;
5226:
5227: IF structnum IS NOT NULL THEN
5228:
5229: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');
5230:
5231: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
5232: (appl_short_name =>'OFA',
5233: flex_code =>'KEY#');

Line 5231: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD

5227: IF structnum IS NOT NULL THEN
5228:
5229: FND_FLEX_KEY_API.SET_SESSION_MODE('seed_data');
5230:
5231: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
5232: (appl_short_name =>'OFA',
5233: flex_code =>'KEY#');
5234:
5235: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);

Line 5235: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);

5231: fftype := FND_FLEX_KEY_API.FIND_FLEXFIELD
5232: (appl_short_name =>'OFA',
5233: flex_code =>'KEY#');
5234:
5235: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);
5236:
5237: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);
5238:
5239: v_asset_key_required := 'N';

Line 5237: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);

5233: flex_code =>'KEY#');
5234:
5235: thestruct := FND_FLEX_KEY_API.FIND_STRUCTURE(fftype,structnum);
5236:
5237: FND_FLEX_KEY_API.GET_SEGMENTS(fftype,thestruct,TRUE,numsegs,listsegs);
5238:
5239: v_asset_key_required := 'N';
5240:
5241: FOR i IN 1 .. numsegs LOOP

Line 5242: segtype := FND_FLEX_KEY_API.FIND_SEGMENT(fftype,thestruct,listsegs(i));

5238:
5239: v_asset_key_required := 'N';
5240:
5241: FOR i IN 1 .. numsegs LOOP
5242: segtype := FND_FLEX_KEY_API.FIND_SEGMENT(fftype,thestruct,listsegs(i));
5243:
5244: IF (segtype.required_flag = 'Y' and segtype.enabled_flag = 'Y') THEN
5245: v_asset_key_required := 'Y';
5246: END IF;