eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_WORKFLOW_UTIL dependencies on FND_TABLE_OF_NUMBER

Line 1629: , x_source_media_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER

1625:
1626:
1627: PROCEDURE GetAttachmentChangeDetails
1628: ( p_change_id IN NUMBER
1629: , x_source_media_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1630: , x_attached_document_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1631: , x_repository_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1632: , x_creator_user_id OUT NOCOPY NUMBER
1633: )

Line 1630: , x_attached_document_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER

1626:
1627: PROCEDURE GetAttachmentChangeDetails
1628: ( p_change_id IN NUMBER
1629: , x_source_media_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1630: , x_attached_document_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1631: , x_repository_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1632: , x_creator_user_id OUT NOCOPY NUMBER
1633: )
1634: IS

Line 1631: , x_repository_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER

1627: PROCEDURE GetAttachmentChangeDetails
1628: ( p_change_id IN NUMBER
1629: , x_source_media_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1630: , x_attached_document_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1631: , x_repository_id_tbl OUT NOCOPY FND_TABLE_OF_NUMBER
1632: , x_creator_user_id OUT NOCOPY NUMBER
1633: )
1634: IS
1635: CURSOR doc_details(p_change_id NUMBER)

Line 1646: x_attached_document_id_tbl := new FND_TABLE_OF_NUMBER();

1642: WHERE eec.change_id = p_change_id ;
1643: l_index NUMBER :=0;
1644:
1645: BEGIN
1646: x_attached_document_id_tbl := new FND_TABLE_OF_NUMBER();
1647: x_source_media_id_tbl := new FND_TABLE_OF_NUMBER();
1648: x_repository_id_tbl := new FND_TABLE_OF_NUMBER();
1649: for doc_detail in doc_details( p_change_id)
1650: loop

Line 1647: x_source_media_id_tbl := new FND_TABLE_OF_NUMBER();

1643: l_index NUMBER :=0;
1644:
1645: BEGIN
1646: x_attached_document_id_tbl := new FND_TABLE_OF_NUMBER();
1647: x_source_media_id_tbl := new FND_TABLE_OF_NUMBER();
1648: x_repository_id_tbl := new FND_TABLE_OF_NUMBER();
1649: for doc_detail in doc_details( p_change_id)
1650: loop
1651: l_index := l_index + 1;

Line 1648: x_repository_id_tbl := new FND_TABLE_OF_NUMBER();

1644:
1645: BEGIN
1646: x_attached_document_id_tbl := new FND_TABLE_OF_NUMBER();
1647: x_source_media_id_tbl := new FND_TABLE_OF_NUMBER();
1648: x_repository_id_tbl := new FND_TABLE_OF_NUMBER();
1649: for doc_detail in doc_details( p_change_id)
1650: loop
1651: l_index := l_index + 1;
1652: x_attached_document_id_tbl.EXTEND ;

Line 8274: l_person_id_tbl FND_TABLE_OF_NUMBER ;

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:
8277: l_base_change_mgmt_type_code VARCHAR2(30);
8278: l_message_text VARCHAR2(400);

Line 8393: l_person_id_tbl := FND_TABLE_OF_NUMBER();

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
8397: ( p_item_type => p_item_type

Line 13292: l_person_id_tbl FND_TABLE_OF_NUMBER ;

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) ;
13295:
13296: --Bug 11802032 Start

Line 13652: l_person_id_tbl := FND_TABLE_OF_NUMBER();

13648: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
13649: END IF ;
13650:
13651:
13652: l_person_id_tbl := FND_TABLE_OF_NUMBER();
13653: l_person_id_tbl.EXTEND ;
13654: l_person_idx := l_person_idx + 1 ;
13655: l_person_id_tbl(l_person_idx) := l_new_party_id ;
13656:

Line 13733: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

13729: , p_change_id IN NUMBER
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: )

Line 13758: l_doc_rev_person_id_tbl FND_TABLE_OF_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 ;
13760: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
13761: l_ocs_person_idx PLS_INTEGER ;
13762:

Line 13760: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;

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 ;
13760: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
13761: l_ocs_person_idx PLS_INTEGER ;
13762:
13763: l_doc_rev_grant_flag BOOLEAN ;
13764: l_ocs_grant_flag BOOLEAN ;

Line 13770: l_attachment_ids FND_TABLE_OF_NUMBER;

13766: l_attachment_entity_name VARCHAR2(40) ;
13767: l_attachment_pk1value VARCHAR2(100) ;
13768:
13769: l_base_cm_type_code VARCHAR2(40);
13770: l_attachment_ids FND_TABLE_OF_NUMBER;
13771: l_repository_ids FND_TABLE_OF_NUMBER;
13772: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13773: l_sumitted_by NUMBER;
13774:

Line 13771: l_repository_ids FND_TABLE_OF_NUMBER;

13767: l_attachment_pk1value VARCHAR2(100) ;
13768:
13769: l_base_cm_type_code VARCHAR2(40);
13770: l_attachment_ids FND_TABLE_OF_NUMBER;
13771: l_repository_ids FND_TABLE_OF_NUMBER;
13772: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13773: l_sumitted_by NUMBER;
13774:
13775:

Line 13772: l_source_mdedia_ids FND_TABLE_OF_NUMBER;

13768:
13769: l_base_cm_type_code VARCHAR2(40);
13770: l_attachment_ids FND_TABLE_OF_NUMBER;
13771: l_repository_ids FND_TABLE_OF_NUMBER;
13772: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13773: l_sumitted_by NUMBER;
13774:
13775:
13776: CURSOR c_step_assignees ( c_step_id NUMBER )

Line 13912: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;

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 ;
13914: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13915: l_ocs_person_idx := 0 ;
13916:

Line 13914: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;

13910: l_obj_idx := 0 ;
13911:
13912: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13913: l_doc_rev_person_idx := 0 ;
13914: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13915: l_ocs_person_idx := 0 ;
13916:
13917: l_change_id := p_change_id ;
13918: l_change_line_id := p_change_line_id ;

Line 14392: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

14388: , x_msg_count OUT NOCOPY NUMBER --
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: )

Line 14589: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

14585: , x_msg_data OUT NOCOPY VARCHAR2 --
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: )

Line 14692: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

14688: , p_change_id IN NUMBER -- Change Id
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: )

Line 14718: l_doc_rev_person_id_tbl FND_TABLE_OF_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 ;
14720: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
14721: l_ocs_person_idx PLS_INTEGER ;
14722:

Line 14720: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;

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 ;
14720: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
14721: l_ocs_person_idx PLS_INTEGER ;
14722:
14723: l_doc_rev_revoke_flag BOOLEAN ;
14724: l_ocs_revoke_flag BOOLEAN ;

Line 14869: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;

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 ;
14871: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14872: l_ocs_person_idx := 0 ;
14873:

Line 14871: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;

14867: l_obj_idx := 0 ;
14868:
14869: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14870: l_doc_rev_person_idx := 0 ;
14871: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14872: l_ocs_person_idx := 0 ;
14873:
14874: l_change_id := p_change_id ;
14875: l_change_line_id := p_change_line_id ;