APPS.ENGECOBO dependencies on FND_LOOKUPS

Line 817: l_action_name fnd_lookups.meaning%TYPE;

813: AND ecpm.entity_action_status = 3);
814:
815:
816: l_current_revision_id NUMBER;
817: l_action_name fnd_lookups.meaning%TYPE;
818: l_local_attachment_id NUMBER;
819: l_pk3_value VARCHAR2(100);
820: l_status_name fnd_lookups.meaning%TYPE;
821: l_check_item_changes NUMBER;

Line 820: l_status_name fnd_lookups.meaning%TYPE;

816: l_current_revision_id NUMBER;
817: l_action_name fnd_lookups.meaning%TYPE;
818: l_local_attachment_id NUMBER;
819: l_pk3_value VARCHAR2(100);
820: l_status_name fnd_lookups.meaning%TYPE;
821: l_check_item_changes NUMBER;
822: l_local_att_status fnd_attached_documents.status%TYPE; -- Bug 3599366
823: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
824: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 953: FROM fnd_lookups

949: , x_att_status => l_local_att_status); -- Bug 3599366
950:
951: SELECT meaning
952: INTO l_action_name
953: FROM fnd_lookups
954: WHERE lookup_type = 'DOM_CHANGE_ACTION_TYPES'
955: AND lookup_code = ac.action_type;
956:
957: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_attachment_id'||l_local_attachment_id||' l_local_att_status'||l_local_att_status);

Line 998: FROM fnd_lookups

994: l_local_att_status IN ('PENDING', 'PENDING_CHANGE', 'SUBMITTED_FOR_APPROVAL')) -- Bug 3599366
995: THEN
996: SELECT meaning
997: INTO l_status_name
998: FROM fnd_lookups
999: WHERE lookup_type = 'DOM_ATTACHED_DOC_STATUS'
1000: AND lookup_code = l_local_att_status; -- Bug 3599366
1001:
1002: -- For all actions except attach, if attachment exists but it is not in a valid status for change, log error