DBA Data[Home] [Help]

APPS.PSB_WS_POS1 dependencies on FND_API

Line 176: ( p_init_index NUMBER := FND_API.G_MISS_NUM

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:

Line 241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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:

Line 364: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 376: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 382: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM

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:

Line 389: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 400: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 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: /* ----------------------------------------------------------------------- */

Line 405: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE

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:

Line 412: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 426: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 427: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 429: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 432: p_budget_group_id 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,

Line 433: p_annual_fte 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,

Line 436: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 438: p_end_stage_seq 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: );
441:
442: /* ----------------------------------------------------------------------- */

Line 446: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 457: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 459: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 462: p_service_package_id 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: );

Line 463: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 465: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 471: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 485: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 494: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 496: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

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: /* ----------------------------------------------------------------------- */

Line 504: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 517: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

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

Line 519: p_service_package_id 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:

Line 520: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

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: /* ----------------------------------------------------------------------- */

Line 521: p_element_cost IN NUMBER := FND_API.G_MISS_NUM

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:

Line 528: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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,

Line 554: -- Pre-reqs : FND_API, FND_MESSAGE

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

Line 565: p_redistribute IN VARCHAR2 := FND_API.G_FALSE,

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,