DBA Data[Home] [Help]

APPS.FLM_KANBAN_PUB dependencies on FLM_EKANBAN_PUB

Line 484: procedure validate_pull_sequence(p_pull_seq_rec IN OUT NOCOPY flm_ekanban_pub.pull_sequence_rec_type

480:
481: --------------------------------------------
482: -- Validate Pull Sequence - Private procedure
483: --------------------------------------------
484: procedure validate_pull_sequence(p_pull_seq_rec IN OUT NOCOPY flm_ekanban_pub.pull_sequence_rec_type
485: ,p_transaction_type NUMBER
486: ,x_ret_status OUT NOCOPY VARCHAR2
487: ,x_error_msg OUT NOCOPY VARCHAR2)
488: is

Line 1512: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;

1508: ,x_ret_status OUT NOCOPY VARCHAR2
1509: )
1510: IS
1511:
1512: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
1513: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;
1514: t_supplier_tbl flm_ekanban_pub.kanban_supplier_tbl_type;
1515: l_transaction_type NUMBER;
1516: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1513: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;

1509: )
1510: IS
1511:
1512: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
1513: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;
1514: t_supplier_tbl flm_ekanban_pub.kanban_supplier_tbl_type;
1515: l_transaction_type NUMBER;
1516: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1517: l_error_msg VARCHAR2(4000);

Line 1514: t_supplier_tbl flm_ekanban_pub.kanban_supplier_tbl_type;

1510: IS
1511:
1512: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
1513: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;
1514: t_supplier_tbl flm_ekanban_pub.kanban_supplier_tbl_type;
1515: l_transaction_type NUMBER;
1516: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1517: l_error_msg VARCHAR2(4000);
1518: l_counter NUMBER := 0;

Line 1675: PROCEDURE validate_kanban_cards (p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type

1671: --
1672: -- PURPOSE
1673: -- validate Kanban Card Details
1674: --------------------------------------------------------------------
1675: PROCEDURE validate_kanban_cards (p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type
1676: ,p_transaction_type IN NUMBER
1677: ,p_release_kanban_flag OUT NOCOPY NUMBER
1678: ,p_error_text IN OUT NOCOPY VARCHAR2
1679: ,x_ret_status OUT NOCOPY VARCHAR2

Line 1762: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;

1758:
1759: lr_inv_item c_inv_item%ROWTYPE;
1760: lr_pullseq_info c_pullseq_info%ROWTYPE;
1761:
1762: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
1763:
1764: l_org_code VARCHAR2 (3);
1765: l_item_name VARCHAR2 (200);
1766: l_calculate_kanban_flag NUMBER;

Line 2556: PROCEDURE process_kanban_cards(p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type

2552:
2553: -----------------------------------
2554: --Procedure to Process Kanban Cards
2555: -----------------------------------
2556: PROCEDURE process_kanban_cards(p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type
2557: ,p_release_kanban_flag IN NUMBER
2558: ,p_transaction_type IN NUMBER
2559: ,x_ret_status OUT NOCOPY VARCHAR2
2560: ,x_err_msg OUT NOCOPY VARCHAR2

Line 2564: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;

2560: ,x_err_msg OUT NOCOPY VARCHAR2
2561: )
2562: IS
2563: --r_card_tab_rec inv_kanban_pvt.kanban_card_rec_type;
2564: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2565: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
2566: -- l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type; This is not required
2567: l_report_id NUMBER := NULL;
2568: l_no_of_cards NUMBER := 1;

Line 2921: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;

2917: ,x_ret_status OUT NOCOPY VARCHAR2
2918: ,x_err_msg OUT NOCOPY VARCHAR2
2919: )
2920: IS
2921: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2922: l_release_kanban_flag NUMBER;
2923: l_ret_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
2924: l_err_msg VARCHAR2(2000);
2925: BEGIN

Line 3049: PROCEDURE process_cards(p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type

3045: END IF;
3046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: END process_cards;
3048:
3049: PROCEDURE process_cards(p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type
3050: ,p_transaction_type IN NUMBER
3051: ,p_commit_flag IN VARCHAR2 DEFAULT 'N'
3052: ,x_ret_status OUT NOCOPY VARCHAR2
3053: ,x_err_msg OUT NOCOPY VARCHAR2

Line 3135: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;

3131: PROCEDURE process_kc(p_card_int_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type
3132: ,x_ret_status OUT NOCOPY VARCHAR2
3133: )
3134: IS
3135: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
3136: l_ret_status VARCHAR2(1);
3137: l_err_msg VARCHAR2(2000);
3138: l_count NUMBER := 0;
3139: BEGIN

Line 3313: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;

3309: ,p_transaction_type IN NUMBER
3310: ,x_ret_status OUT NOCOPY VARCHAR2
3311: ,x_error_msg OUT NOCOPY VARCHAR2)
3312: IS
3313: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
3314: l_Pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;
3315: l_ret_status VARCHAR2(1);
3316: l_error_msg VARCHAR2(4000);
3317: BEGIN

Line 3684: PROCEDURE validate_suppliers(p_supplier_rec IN OUT NOCOPY flm_ekanban_pub.kanban_supplier_rec_type

3680:
3681: ------------------------------
3682: -- Validate multiple suppliers
3683: ------------------------------
3684: PROCEDURE validate_suppliers(p_supplier_rec IN OUT NOCOPY flm_ekanban_pub.kanban_supplier_rec_type
3685: ,p_organization_id IN NUMBER
3686: ,x_ret_status OUT NOCOPY VARCHAR2
3687: ,x_error_msg OUT NOCOPY VARCHAR2)
3688: IS

Line 3852: PROCEDURE process_pull_sequence(p_pull_sequence_rec IN OUT NOCOPY flm_ekanban_pub.pull_sequence_rec_type

3848:
3849: --------------------------------------------
3850: -- procedure for pull sequence public API
3851: --------------------------------------------
3852: PROCEDURE process_pull_sequence(p_pull_sequence_rec IN OUT NOCOPY flm_ekanban_pub.pull_sequence_rec_type
3853: ,p_supplier_tbl IN OUT NOCOPY flm_ekanban_pub.kanban_supplier_tbl_type
3854: ,p_transaction_type IN NUMBER
3855: ,p_commit_flag IN VARCHAR2 DEFAULT 'N'
3856: ,x_ret_status OUT NOCOPY VARCHAR2

Line 3853: ,p_supplier_tbl IN OUT NOCOPY flm_ekanban_pub.kanban_supplier_tbl_type

3849: --------------------------------------------
3850: -- procedure for pull sequence public API
3851: --------------------------------------------
3852: PROCEDURE process_pull_sequence(p_pull_sequence_rec IN OUT NOCOPY flm_ekanban_pub.pull_sequence_rec_type
3853: ,p_supplier_tbl IN OUT NOCOPY flm_ekanban_pub.kanban_supplier_tbl_type
3854: ,p_transaction_type IN NUMBER
3855: ,p_commit_flag IN VARCHAR2 DEFAULT 'N'
3856: ,x_ret_status OUT NOCOPY VARCHAR2
3857: ,x_error_msg OUT NOCOPY VARCHAR2)

Line 4119: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;

4115: ,p_transaction_type IN NUMBER
4116: ,x_ret_status OUT NOCOPY VARCHAR2
4117: ,x_error_msg OUT NOCOPY VARCHAR2)
4118: IS
4119: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;
4120: l_ret_status VARCHAR2(1);
4121: l_error_msg VARCHAR2(4000);
4122: l_last_update_date DATE;
4123: l_last_updated_by NUMBER;