DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on FND_API

Line 57: ,p_commit IN VARCHAR2:= FND_API.g_TRUE

53: PROCEDURE update_item_attributes(p_pending_status IN VARCHAR2
54: ,p_control_level IN NUMBER
55: ,p_Org_Id IN NUMBER
56: ,p_Item_id IN NUMBER
57: ,p_commit IN VARCHAR2:= FND_API.g_TRUE
58: ,p_return_status OUT NOCOPY BOOLEAN)
59:
60: IS
61: CURSOR c_get_status_control (cp_attrib_name VARCHAR2)

Line 499: IF FND_API.To_Boolean (p_commit) THEN

495: AND inventory_item_id = p_Item_Id
496: AND effective_date <= SYSDATE
497: AND pending_flag = 'Y';
498:
499: IF FND_API.To_Boolean (p_commit) THEN
500: COMMIT WORK;
501: END IF;
502:
503: p_return_status := TRUE;

Line 532: ,p_commit IN VARCHAR2 := FND_API.g_TRUE

528: PROCEDURE Process_Pending_Status(ERRBUF OUT NOCOPY VARCHAR2
529: ,RETCODE OUT NOCOPY NUMBER
530: ,p_Org_Id IN NUMBER := NULL
531: ,p_Item_Id IN NUMBER := NULL
532: ,p_commit IN VARCHAR2 := FND_API.g_TRUE
533: ,p_prog_appid IN NUMBER := NULL
534: ,p_prog_id IN NUMBER := NULL
535: ,p_request_id IN NUMBER := NULL
536: ,p_user_id IN NUMBER := NULL

Line 538: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

534: ,p_prog_id IN NUMBER := NULL
535: ,p_request_id IN NUMBER := NULL
536: ,p_user_id IN NUMBER := NULL
537: ,p_login_id IN NUMBER := NULL
538: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
539: ,p_msg_logname IN VARCHAR2 := 'FILE')
540: IS
541: CURSOR c_status_pending_items (cp_org_id NUMBER
542: ,cp_item_id NUMBER)

Line 591: IF FND_API.To_Boolean (p_init_msg_list) THEN

587: INV_ITEM_MSG.Initialize;
588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
590:
591: IF FND_API.To_Boolean (p_init_msg_list) THEN
592: INV_ITEM_MSG.Initialize_Error_Handler;
593: END IF;
594:
595: WHILE (l_counter < 3) LOOP