[Home] [Help]
427: | interface records
428: |
429: | ARGUMENTS
430: | p_api_version API Version of this procedure. Current version is 1.0
431: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
432: | p_commit Indicates whether to commit the changes after successful processing
433: | p_validation_level Indicates whether or not to perform a full validation
434: | x_return_status Returns the status to indicate success or failure of execution
435: | x_msg_count Returns number of error message in the error message stack in case of failure
447: +==========================================================================+ */
448: /* Bug 5255959 added p_clear_qty_cache parameter */
449: PROCEDURE process_transactions (
450: p_api_version IN NUMBER := 1
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER
454: := fnd_api.g_valid_level_full
455: ,p_table IN NUMBER := 2
448: /* Bug 5255959 added p_clear_qty_cache parameter */
449: PROCEDURE process_transactions (
450: p_api_version IN NUMBER := 1
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER
454: := fnd_api.g_valid_level_full
455: ,p_table IN NUMBER := 2
456: ,p_header_id IN NUMBER
450: p_api_version IN NUMBER := 1
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER
454: := fnd_api.g_valid_level_full
455: ,p_table IN NUMBER := 2
456: ,p_header_id IN NUMBER
457: := gme_common_pvt.get_txn_header_id
458: ,x_return_status OUT NOCOPY VARCHAR2
459: ,x_msg_count OUT NOCOPY NUMBER
460: ,x_msg_data OUT NOCOPY VARCHAR2
461: ,x_trans_count OUT NOCOPY NUMBER
462: --Bug#5584699 Changed the datatype from boolean to varchar2.
463: ,p_clear_qty_cache IN VARCHAR2 := fnd_api.g_true);
464: --,p_clear_qty_cache IN BOOLEAN DEFAULT TRUE);
465:
466: /* +==========================================================================+
467: | PROCEDURE NAME
471: | Query quantities at a level specified by the input
472: |
473: | ARGUMENTS
474: | p_api_version API Version of this procedure. Current version is 1.0
475: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
476: | x_return_status Returns the status to indicate success or failure of execution
477: | x_msg_count Returns number of error message in the error message stack in case of failure
478: | x_msg_data Returns the error message in case of failure
479: |
486: +==========================================================================+ */
487: PROCEDURE query_quantities (
488: p_api_version_number IN NUMBER := 1
489: ,p_init_msg_lst IN VARCHAR2
490: DEFAULT fnd_api.g_false
491: ,x_return_status OUT NOCOPY VARCHAR2
492: ,x_msg_count OUT NOCOPY NUMBER
493: ,x_msg_data OUT NOCOPY VARCHAR2
494: ,p_organization_id IN NUMBER
534: | return the quantities at the level after the update
535: |
536: | ARGUMENTS
537: | p_api_version API Version of this procedure. Current version is 1.0
538: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to determine whether to Initialize message list or not |
539: | x_return_status Returns the status to indicate success or failure of execution
540: | x_msg_count Returns number of error message in the error message stack in case of failure
541: | x_msg_data Returns the error message in case of failure
542: |
549: +==========================================================================+ */
550: PROCEDURE update_quantities (
551: p_api_version_number IN NUMBER := 1
552: ,p_init_msg_lst IN VARCHAR2
553: DEFAULT fnd_api.g_false
554: ,x_return_status OUT NOCOPY VARCHAR2
555: ,x_msg_count OUT NOCOPY NUMBER
556: ,x_msg_data OUT NOCOPY VARCHAR2
557: ,p_organization_id IN NUMBER