172: -- Notes : Initializes global array for Position Costs
173: --
174:
175: PROCEDURE Initialize_Calc
176: ( p_init_index NUMBER := FND_API.G_MISS_NUM
177: );
178:
179: /* ----------------------------------------------------------------------- */
180:
237: --
238:
239: FUNCTION Check_Allowed
240: ( p_api_version IN NUMBER,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
242: p_worksheet_id IN NUMBER,
243: p_position_budget_group_id IN NUMBER
244: ) RETURN VARCHAR2;
245:
360: /* ----------------------------------------------------------------------- */
361:
362: -- API name : Create_Position_Lines
363: -- Type : Private
364: -- Pre-reqs : FND_API, FND_MESSAGE
365: -- .
366: -- Version : Current version 1.0
367: -- Initial version 1.0
368: -- Created 12/08/1997 by Supriyo Ghosh
372: --
373:
374: PROCEDURE Create_Position_Lines
375: ( p_api_version IN NUMBER,
376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
377: p_return_status OUT NOCOPY VARCHAR2,
378: p_position_line_id OUT NOCOPY NUMBER,
379: p_worksheet_id IN NUMBER,
380: p_position_id IN NUMBER,
378: p_position_line_id OUT NOCOPY NUMBER,
379: p_worksheet_id IN NUMBER,
380: p_position_id IN NUMBER,
381: p_budget_group_id IN NUMBER,
382: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM
383: );
384:
385: /* ----------------------------------------------------------------------- */
386:
385: /* ----------------------------------------------------------------------- */
386:
387: -- API name : Create_Position_Matrix
388: -- Type : Private
389: -- Pre-reqs : FND_API, FND_MESSAGE
390: -- .
391: -- Version : Current version 1.0
392: -- Initial version 1.0
393: -- Created 12/08/1997 by Supriyo Ghosh
396: --
397:
398: PROCEDURE Create_Position_Matrix
399: ( p_api_version IN NUMBER,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
401: p_return_status OUT NOCOPY VARCHAR2,
402: p_worksheet_id IN NUMBER,
403: p_position_line_id IN NUMBER,
404: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
401: p_return_status OUT NOCOPY VARCHAR2,
402: p_worksheet_id IN NUMBER,
403: p_position_line_id IN NUMBER,
404: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
405: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
406: );
407:
408: /* ----------------------------------------------------------------------- */
401: p_return_status OUT NOCOPY VARCHAR2,
402: p_worksheet_id IN NUMBER,
403: p_position_line_id IN NUMBER,
404: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
405: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
406: );
407:
408: /* ----------------------------------------------------------------------- */
409:
408: /* ----------------------------------------------------------------------- */
409:
410: -- API name : Create_FTE_Lines
411: -- Type : Private
412: -- Pre-reqs : FND_API, FND_MESSAGE
413: -- .
414: -- Version : Current version 1.0
415: -- Initial version 1.0
416: -- Created 12/08/1997 by Supriyo Ghosh
419: --
420:
421: PROCEDURE Create_FTE_Lines
422: ( p_api_version IN NUMBER,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
424: p_return_status OUT NOCOPY VARCHAR2,
425: p_fte_line_id OUT NOCOPY NUMBER,
426: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
427: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
422: ( p_api_version IN NUMBER,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
424: p_return_status OUT NOCOPY VARCHAR2,
425: p_fte_line_id OUT NOCOPY NUMBER,
426: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
427: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
428: p_worksheet_id IN NUMBER,
429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_position_line_id IN NUMBER,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
424: p_return_status OUT NOCOPY VARCHAR2,
425: p_fte_line_id OUT NOCOPY NUMBER,
426: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
427: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
428: p_worksheet_id IN NUMBER,
429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_position_line_id IN NUMBER,
431: p_budget_year_id IN NUMBER,
425: p_fte_line_id OUT NOCOPY NUMBER,
426: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
427: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
428: p_worksheet_id IN NUMBER,
429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_position_line_id IN NUMBER,
431: p_budget_year_id IN NUMBER,
432: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
433: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
428: p_worksheet_id IN NUMBER,
429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_position_line_id IN NUMBER,
431: p_budget_year_id IN NUMBER,
432: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
433: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
434: p_service_package_id IN NUMBER,
435: p_stage_set_id IN NUMBER,
436: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
430: p_position_line_id IN NUMBER,
431: p_budget_year_id IN NUMBER,
432: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
433: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
434: p_service_package_id IN NUMBER,
435: p_stage_set_id IN NUMBER,
436: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
437: p_current_stage_seq IN NUMBER,
432: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
433: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
434: p_service_package_id IN NUMBER,
435: p_stage_set_id IN NUMBER,
436: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
437: p_current_stage_seq IN NUMBER,
438: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
439: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
440: );
434: p_service_package_id IN NUMBER,
435: p_stage_set_id IN NUMBER,
436: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
437: p_current_stage_seq IN NUMBER,
438: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
439: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
440: );
441:
442: /* ----------------------------------------------------------------------- */
442: /* ----------------------------------------------------------------------- */
443:
444: -- API name : Create_FTE_Lines
445: -- Type : Private
446: -- Pre-reqs : FND_API, FND_MESSAGE
447: -- .
448: -- Version : Current version 1.0
449: -- Initial version 1.0
450: -- Created 12/08/1997 by Supriyo Ghosh
453: --
454:
455: PROCEDURE Create_FTE_Lines
456: ( p_api_version IN NUMBER,
457: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
460: p_worksheet_id IN NUMBER,
461: p_fte_line_id IN NUMBER,
455: PROCEDURE Create_FTE_Lines
456: ( p_api_version IN NUMBER,
457: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
460: p_worksheet_id IN NUMBER,
461: p_fte_line_id IN NUMBER,
462: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
458: p_return_status OUT NOCOPY VARCHAR2,
459: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
460: p_worksheet_id IN NUMBER,
461: p_fte_line_id IN NUMBER,
462: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
464: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
465: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
466: );
459: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
460: p_worksheet_id IN NUMBER,
461: p_fte_line_id IN NUMBER,
462: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
464: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
465: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
466: );
467:
461: p_fte_line_id IN NUMBER,
462: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
463: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
464: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
465: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
466: );
467:
468: /* ----------------------------------------------------------------------- */
469: -- API name : Create_Element_Lines
467:
468: /* ----------------------------------------------------------------------- */
469: -- API name : Create_Element_Lines
470: -- Type : Private
471: -- Pre-reqs : FND_API, FND_MESSAGE
472: -- .
473: -- Version : Current version 1.0
474: -- Initial version 1.0
475: -- Created 12/09/1997 by Supriyo Ghosh
478: --
479:
480: PROCEDURE Create_Element_Lines
481: ( p_api_version IN NUMBER,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
483: p_return_status OUT NOCOPY VARCHAR2,
484: p_element_line_id OUT NOCOPY NUMBER,
485: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
486: p_position_line_id IN NUMBER,
481: ( p_api_version IN NUMBER,
482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
483: p_return_status OUT NOCOPY VARCHAR2,
484: p_element_line_id OUT NOCOPY NUMBER,
485: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
486: p_position_line_id IN NUMBER,
487: p_budget_year_id IN NUMBER,
488: p_pay_element_id IN NUMBER,
489: p_currency_code IN VARCHAR2,
490: p_element_cost IN NUMBER,
491: p_element_set_id IN NUMBER,
492: p_service_package_id IN NUMBER,
493: p_stage_set_id IN NUMBER,
494: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
495: p_current_stage_seq IN NUMBER,
496: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
497: p_functional_transaction IN VARCHAR2 := NULL
498: );
492: p_service_package_id IN NUMBER,
493: p_stage_set_id IN NUMBER,
494: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
495: p_current_stage_seq IN NUMBER,
496: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
497: p_functional_transaction IN VARCHAR2 := NULL
498: );
499:
500: /* ----------------------------------------------------------------------- */
500: /* ----------------------------------------------------------------------- */
501:
502: -- API name : Create_Element_Lines
503: -- Type : Private
504: -- Pre-reqs : FND_API, FND_MESSAGE
505: -- .
506: -- Version : Current version 1.0
507: -- Initial version 1.0
508: -- Created 08/12/1998 by Supriyo Ghosh
511: --
512:
513: PROCEDURE Create_Element_Lines
514: ( p_api_version IN NUMBER,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
518: p_element_line_id IN NUMBER,
519: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
513: PROCEDURE Create_Element_Lines
514: ( p_api_version IN NUMBER,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
518: p_element_line_id IN NUMBER,
519: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
521: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
518: p_element_line_id IN NUMBER,
519: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
521: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
522: );
523:
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
518: p_element_line_id IN NUMBER,
519: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
521: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
522: );
523:
524: /* ----------------------------------------------------------------------- */
517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
518: p_element_line_id IN NUMBER,
519: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
520: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
521: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
522: );
523:
524: /* ----------------------------------------------------------------------- */
525:
524: /* ----------------------------------------------------------------------- */
525:
526: -- API name : Update_Annual_FTE
527: -- Type : Private
528: -- Pre-reqs : FND_API, FND_MESSAGE
529: -- .
530: -- Version : Current version 1.0
531: -- Initial version 1.0
532: -- Created 12/10/1997 by Supriyo Ghosh
535: --
536:
537: PROCEDURE Update_Annual_FTE
538: ( p_api_version IN NUMBER,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
540: p_return_status OUT NOCOPY VARCHAR2,
541: p_worksheet_id IN NUMBER,
542: p_position_line_id IN NUMBER,
543: p_budget_year_id IN NUMBER,
550: /* ----------------------------------------------------------------------- */
551:
552: -- API name : Distribute_Following_Elements
553: -- Type : Private
554: -- Pre-reqs : FND_API, FND_MESSAGE
555: -- .
556: -- Version : Current version 1.0
557: -- Initial version 1.0
558: -- Created 12/09/1997 by Supriyo Ghosh
561: --
562:
563: PROCEDURE Distribute_Following_Elements
564: ( p_return_status OUT NOCOPY VARCHAR2,
565: p_redistribute IN VARCHAR2 := FND_API.G_FALSE,
566: p_pay_element_id IN NUMBER,
567: p_data_extract_id IN NUMBER,
568: p_flex_code IN NUMBER,
569: p_business_group_id IN NUMBER,