APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 883: v_proc_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;

879: -- MODIFICATION HISTORY
880: -- Person Date Comments
881: -- dpatel 20/03/2006
882: -- --------- ------ -------------------------------------------
883: v_proc_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;
884: v_proc_org_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;
885: BEGIN
886: select process_org_rev_id into v_proc_org_rev_id
887: from amw_process_organization

Line 884: v_proc_org_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;

880: -- Person Date Comments
881: -- dpatel 20/03/2006
882: -- --------- ------ -------------------------------------------
883: v_proc_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;
884: v_proc_org_rev_id FND_ATTACHED_DOCUMENTS.pk1_value%type;
885: BEGIN
886: select process_org_rev_id into v_proc_org_rev_id
887: from amw_process_organization
888: where process_id = p_process_id

Line 893: From FND_ATTACHED_DOCUMENTS

889: and organization_id = p_org_id
890: and end_date is null;
891:
892: select distinct pk1_value into v_proc_rev_id
893: From FND_ATTACHED_DOCUMENTS
894: where entity_name ='AMW_PROCESS'
895: and pk1_value in ( select PROCESS_REV_ID
896: from amw_process_vl
897: where process_id = p_process_id

Line 901: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => 'AMW_PROCESS_ORGANIZATION'

897: where process_id = p_process_id
898: and end_date is null);
899:
900: IF p_add_upd_flag = 'U' THEN
901: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => 'AMW_PROCESS_ORGANIZATION'
902: ,X_pk1_value => v_proc_org_rev_id);
903: --,X_delete_document_flag => 'Y');
904:
905: END IF; -- if update then delete the current attachments before adding new

Line 907: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROCESS'

903: --,X_delete_document_flag => 'Y');
904:
905: END IF; -- if update then delete the current attachments before adding new
906:
907: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROCESS'
908: ,X_from_pk1_value => v_proc_rev_id
909: ,X_to_entity_name => 'AMW_PROCESS_ORGANIZATION'
910: ,X_to_pk1_value => v_proc_org_rev_id
911: ,X_created_by => G_USER_ID

Line 4996: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => 'AMW_PROCESS_ORGANIZATION',

4992: and association_creation_date is null
4993: and object_type = 'CTRL_ORG';
4994:
4995:
4996: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => 'AMW_PROCESS_ORGANIZATION',
4997: X_pk1_value => previd);
4998:
4999: -- cancel existing change requests
5000: -- update org count..

Line 7525: l_proc_latest FND_ATTACHED_DOCUMENTS.pk1_value%type;

7521: l_curr_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7522: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
7523: pending_approval_exception exception;
7524: l_approval_status varchar2(1);
7525: l_proc_latest FND_ATTACHED_DOCUMENTS.pk1_value%type;
7526: l_proc_prev FND_ATTACHED_DOCUMENTS.pk1_value%type;
7527:
7528: BEGIN
7529:

Line 7526: l_proc_prev FND_ATTACHED_DOCUMENTS.pk1_value%type;

7522: l_log_stmt_level number := FND_LOG.LEVEL_STATEMENT;
7523: pending_approval_exception exception;
7524: l_approval_status varchar2(1);
7525: l_proc_latest FND_ATTACHED_DOCUMENTS.pk1_value%type;
7526: l_proc_prev FND_ATTACHED_DOCUMENTS.pk1_value%type;
7527:
7528: BEGIN
7529:
7530: -- synchronization is only done to a process when it exists in the organization..

Line 7611: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROCESS_ORGANIZATION'

7607: and organization_id = p_org_id
7608: and approval_date is not null
7609: and approval_end_date is null;
7610:
7611: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(X_from_entity_name => 'AMW_PROCESS_ORGANIZATION'
7612: ,X_from_pk1_value => l_proc_prev
7613: ,X_to_entity_name => 'AMW_PROCESS_ORGANIZATION'
7614: ,X_to_pk1_value => l_proc_latest
7615: ,X_created_by => G_USER_ID