DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on FND_TABLE_OF_VARCHAR2_30

Line 8272: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

8268:
8269: -- R12B
8270: l_route_id NUMBER;
8271: l_change_line_id NUMBER;
8272: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
8273: l_obj_index PLS_INTEGER ;
8274: l_person_id_tbl FND_TABLE_OF_NUMBER ;
8275: l_person_idx PLS_INTEGER ;
8276:

Line 8392: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

8388: -- Initialize API return status to success
8389: x_return_status := FND_API.G_RET_STS_SUCCESS;
8390:
8391: -- Initialize Table var
8392: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
8393: l_person_id_tbl := FND_TABLE_OF_NUMBER();
8394:
8395: -- Get Change Object Identifier
8396: GetChangeObject

Line 11736: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

11732: l_return_status VARCHAR2(1);
11733: l_msg_count NUMBER;
11734: l_msg_data VARCHAR2(3000);
11735:
11736: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
11737: l_index PLS_INTEGER ;
11738:
11739:
11740:

Line 12316: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

12312: Write_Debug('calling Eng_Workflow_Util.GrantObjectRoles.' );
12313: END IF ;
12314:
12315: l_index := 0 ;
12316: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12317: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
12318: THEN
12319: l_target_obj_tbl.EXTEND ;
12320: l_index := l_index + 1 ;

Line 12579: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

12575:
12576:
12577:
12578: -- R12B
12579: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
12580: l_index PLS_INTEGER ;
12581:
12582: l_msg_count NUMBER ;
12583: l_msg_data VARCHAR2(2000) ;

Line 12974: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

12970:
12971: IF g_debug_flag THEN
12972: Write_Debug('Change Object is a Doc LC Object, Setting target objects. . . . ');
12973: END IF ;
12974: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12975: l_target_obj_tbl.EXTEND ;
12976: l_index := l_index+1 ;
12977: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12978: END IF ;

Line 13290: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

13286:
13287: -- R12B
13288: l_route_id NUMBER;
13289: l_change_line_id NUMBER;
13290: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
13291: l_obj_index PLS_INTEGER ;
13292: l_person_id_tbl FND_TABLE_OF_NUMBER ;
13293: l_person_idx PLS_INTEGER ;
13294: l_default_assignee_resp VARCHAR2(30) ;

Line 13645: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

13641: l_person_idx := 0 ;
13642:
13643: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
13644: THEN
13645: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
13646: l_target_obj_tbl.EXTEND ;
13647: l_obj_index := l_obj_index + 1 ;
13648: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
13649: END IF ;

Line 13734: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

13730: , p_change_line_id IN NUMBER
13731: , p_route_id IN NUMBER
13732: , p_step_id IN NUMBER
13733: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
13734: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
13735: , p_api_caller IN VARCHAR2 := NULL
13736: , p_grant_option IN VARCHAR2 := NULL -- Optionnal
13737: )
13738: IS

Line 13755: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;

13751: l_change_line_id NUMBER ;
13752: l_document_id NUMBER ;
13753: l_document_revision_id NUMBER ;
13754:
13755: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;
13756: l_obj_idx PLS_INTEGER ;
13757:
13758: l_doc_rev_person_id_tbl FND_TABLE_OF_NUMBER ;
13759: l_doc_rev_person_idx PLS_INTEGER ;

Line 13909: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;

13905: -- Initialize API return status to success
13906: x_return_status := FND_API.G_RET_STS_SUCCESS;
13907: l_return_status := FND_API.G_RET_STS_SUCCESS;
13908:
13909: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13910: l_obj_idx := 0 ;
13911:
13912: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13913: l_doc_rev_person_idx := 0 ;

Line 14393: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14389: , x_msg_data OUT NOCOPY VARCHAR2 --
14390: , p_change_id IN NUMBER -- Change Id
14391: , p_change_line_id IN NUMBER -- Change Line Id
14392: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14393: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14394: , p_api_caller IN VARCHAR2 := NULL
14395: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal: G_REVOKE_ALL
14396: )
14397: IS

Line 14590: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14586: , p_change_id IN NUMBER -- Change Id
14587: , p_change_line_id IN NUMBER -- Change Line Id
14588: , p_route_id IN NUMBER
14589: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14590: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14591: , p_api_caller IN VARCHAR2 := NULL
14592: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
14593: )
14594: IS

Line 14693: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14689: , p_change_line_id IN NUMBER -- Change Line Id
14690: , p_route_id IN NUMBER
14691: , p_step_id IN NUMBER
14692: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14693: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14694: , p_api_caller IN VARCHAR2 := NULL
14695: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
14696: )
14697: IS

Line 14715: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;

14711:
14712: l_document_id NUMBER ;
14713: l_document_revision_id NUMBER ;
14714:
14715: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;
14716: l_obj_idx PLS_INTEGER ;
14717:
14718: l_doc_rev_person_id_tbl FND_TABLE_OF_NUMBER ;
14719: l_doc_rev_person_idx PLS_INTEGER ;

Line 14866: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;

14862: -- Initialize API return status to success
14863: x_return_status := FND_API.G_RET_STS_SUCCESS;
14864: l_return_status := FND_API.G_RET_STS_SUCCESS;
14865:
14866: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14867: l_obj_idx := 0 ;
14868:
14869: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14870: l_doc_rev_person_idx := 0 ;