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 8357: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

8353: -- Initialize API return status to success
8354: x_return_status := FND_API.G_RET_STS_SUCCESS;
8355:
8356: -- Initialize Table var
8357: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
8358: l_person_id_tbl := FND_TABLE_OF_NUMBER();
8359:
8360: -- Get Change Object Identifier
8361: GetChangeObject

Line 11660: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

11656: l_return_status VARCHAR2(1);
11657: l_msg_count NUMBER;
11658: l_msg_data VARCHAR2(3000);
11659:
11660: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
11661: l_index PLS_INTEGER ;
11662:
11663:
11664:

Line 12240: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

12236: Write_Debug('calling Eng_Workflow_Util.GrantObjectRoles.' );
12237: END IF ;
12238:
12239: l_index := 0 ;
12240: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12241: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
12242: THEN
12243: l_target_obj_tbl.EXTEND ;
12244: l_index := l_index + 1 ;

Line 12503: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

12499:
12500:
12501:
12502: -- R12B
12503: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
12504: l_index PLS_INTEGER ;
12505:
12506: l_msg_count NUMBER ;
12507: l_msg_data VARCHAR2(2000) ;

Line 12898: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

12894:
12895: IF g_debug_flag THEN
12896: Write_Debug('Change Object is a Doc LC Object, Setting target objects. . . . ');
12897: END IF ;
12898: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
12899: l_target_obj_tbl.EXTEND ;
12900: l_index := l_index+1 ;
12901: l_target_obj_tbl(l_index) := G_DOM_DOCUMENT_REVISION ;
12902: END IF ;

Line 13214: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;

13210:
13211: -- R12B
13212: l_route_id NUMBER;
13213: l_change_line_id NUMBER;
13214: l_target_obj_tbl FND_TABLE_OF_VARCHAR2_30;
13215: l_obj_index PLS_INTEGER ;
13216: l_person_id_tbl FND_TABLE_OF_NUMBER ;
13217: l_person_idx PLS_INTEGER ;
13218: l_default_assignee_resp VARCHAR2(30) ;

Line 13500: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();

13496: l_person_idx := 0 ;
13497:
13498: IF ( p_item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE )
13499: THEN
13500: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
13501: l_target_obj_tbl.EXTEND ;
13502: l_obj_index := l_obj_index + 1 ;
13503: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
13504: END IF ;

Line 13589: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

13585: , p_change_line_id IN NUMBER
13586: , p_route_id IN NUMBER
13587: , p_step_id IN NUMBER
13588: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
13589: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
13590: , p_api_caller IN VARCHAR2 := NULL
13591: , p_grant_option IN VARCHAR2 := NULL -- Optionnal
13592: )
13593: IS

Line 13610: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;

13606: l_change_line_id NUMBER ;
13607: l_document_id NUMBER ;
13608: l_document_revision_id NUMBER ;
13609:
13610: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;
13611: l_obj_idx PLS_INTEGER ;
13612:
13613: l_doc_rev_person_id_tbl FND_TABLE_OF_NUMBER ;
13614: l_doc_rev_person_idx PLS_INTEGER ;

Line 13764: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;

13760: -- Initialize API return status to success
13761: x_return_status := FND_API.G_RET_STS_SUCCESS;
13762: l_return_status := FND_API.G_RET_STS_SUCCESS;
13763:
13764: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13765: l_obj_idx := 0 ;
13766:
13767: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13768: l_doc_rev_person_idx := 0 ;

Line 14248: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14244: , x_msg_data OUT NOCOPY VARCHAR2 --
14245: , p_change_id IN NUMBER -- Change Id
14246: , p_change_line_id IN NUMBER -- Change Line Id
14247: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14248: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14249: , p_api_caller IN VARCHAR2 := NULL
14250: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal: G_REVOKE_ALL
14251: )
14252: IS

Line 14445: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14441: , p_change_id IN NUMBER -- Change Id
14442: , p_change_line_id IN NUMBER -- Change Line Id
14443: , p_route_id IN NUMBER
14444: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14445: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14446: , p_api_caller IN VARCHAR2 := NULL
14447: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
14448: )
14449: IS

Line 14548: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL

14544: , p_change_line_id IN NUMBER -- Change Line Id
14545: , p_route_id IN NUMBER
14546: , p_step_id IN NUMBER
14547: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL
14548: , p_target_objects IN FND_TABLE_OF_VARCHAR2_30 := NULL
14549: , p_api_caller IN VARCHAR2 := NULL
14550: , p_revoke_option IN VARCHAR2 := NULL -- Optionnal
14551: )
14552: IS

Line 14570: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;

14566:
14567: l_document_id NUMBER ;
14568: l_document_revision_id NUMBER ;
14569:
14570: l_target_object_tbl FND_TABLE_OF_VARCHAR2_30 ;
14571: l_obj_idx PLS_INTEGER ;
14572:
14573: l_doc_rev_person_id_tbl FND_TABLE_OF_NUMBER ;
14574: l_doc_rev_person_idx PLS_INTEGER ;

Line 14721: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;

14717: -- Initialize API return status to success
14718: x_return_status := FND_API.G_RET_STS_SUCCESS;
14719: l_return_status := FND_API.G_RET_STS_SUCCESS;
14720:
14721: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14722: l_obj_idx := 0 ;
14723:
14724: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14725: l_doc_rev_person_idx := 0 ;