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 8358: l_person_id_tbl := FND_TABLE_OF_NUMBER();

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

Line 13216: l_person_id_tbl FND_TABLE_OF_NUMBER ;

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) ;
13219:
13220:

Line 13507: l_person_id_tbl := FND_TABLE_OF_NUMBER();

13503: l_target_obj_tbl(l_obj_index) := G_DOM_DOCUMENT_REVISION ;
13504: END IF ;
13505:
13506:
13507: l_person_id_tbl := FND_TABLE_OF_NUMBER();
13508: l_person_id_tbl.EXTEND ;
13509: l_person_idx := l_person_idx + 1 ;
13510: l_person_id_tbl(l_person_idx) := l_new_party_id ;
13511:

Line 13588: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

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

Line 13613: l_doc_rev_person_id_tbl FND_TABLE_OF_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 ;
13615: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
13616: l_ocs_person_idx PLS_INTEGER ;
13617:

Line 13615: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;

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 ;
13615: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
13616: l_ocs_person_idx PLS_INTEGER ;
13617:
13618: l_doc_rev_grant_flag BOOLEAN ;
13619: l_ocs_grant_flag BOOLEAN ;

Line 13625: l_attachment_ids FND_TABLE_OF_NUMBER;

13621: l_attachment_entity_name VARCHAR2(40) ;
13622: l_attachment_pk1value VARCHAR2(100) ;
13623:
13624: l_base_cm_type_code VARCHAR2(40);
13625: l_attachment_ids FND_TABLE_OF_NUMBER;
13626: l_repository_ids FND_TABLE_OF_NUMBER;
13627: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13628: l_sumitted_by NUMBER;
13629:

Line 13626: l_repository_ids FND_TABLE_OF_NUMBER;

13622: l_attachment_pk1value VARCHAR2(100) ;
13623:
13624: l_base_cm_type_code VARCHAR2(40);
13625: l_attachment_ids FND_TABLE_OF_NUMBER;
13626: l_repository_ids FND_TABLE_OF_NUMBER;
13627: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13628: l_sumitted_by NUMBER;
13629:
13630:

Line 13627: l_source_mdedia_ids FND_TABLE_OF_NUMBER;

13623:
13624: l_base_cm_type_code VARCHAR2(40);
13625: l_attachment_ids FND_TABLE_OF_NUMBER;
13626: l_repository_ids FND_TABLE_OF_NUMBER;
13627: l_source_mdedia_ids FND_TABLE_OF_NUMBER;
13628: l_sumitted_by NUMBER;
13629:
13630:
13631: CURSOR c_step_assignees ( c_step_id NUMBER )

Line 13767: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;

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 ;
13769: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13770: l_ocs_person_idx := 0 ;
13771:

Line 13769: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;

13765: l_obj_idx := 0 ;
13766:
13767: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13768: l_doc_rev_person_idx := 0 ;
13769: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
13770: l_ocs_person_idx := 0 ;
13771:
13772: l_change_id := p_change_id ;
13773: l_change_line_id := p_change_line_id ;

Line 14247: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

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

Line 14444: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

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

Line 14547: , p_person_ids IN FND_TABLE_OF_NUMBER := NULL

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

Line 14573: l_doc_rev_person_id_tbl FND_TABLE_OF_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 ;
14575: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
14576: l_ocs_person_idx PLS_INTEGER ;
14577:

Line 14575: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;

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 ;
14575: l_ocs_person_id_tbl FND_TABLE_OF_NUMBER ;
14576: l_ocs_person_idx PLS_INTEGER ;
14577:
14578: l_doc_rev_revoke_flag BOOLEAN ;
14579: l_ocs_revoke_flag BOOLEAN ;

Line 14724: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;

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 ;
14726: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14727: l_ocs_person_idx := 0 ;
14728:

Line 14726: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;

14722: l_obj_idx := 0 ;
14723:
14724: l_doc_rev_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14725: l_doc_rev_person_idx := 0 ;
14726: l_ocs_person_id_tbl := FND_TABLE_OF_NUMBER() ;
14727: l_ocs_person_idx := 0 ;
14728:
14729: l_change_id := p_change_id ;
14730: l_change_line_id := p_change_line_id ;