110: sql_stmt_num := 2;
111:
112: SELECT COUNT (*)
113: INTO total_assembly_comments
114: FROM fnd_attached_documents
115: WHERE entity_name = 'BOM_BILL_OF_MATERIALS'
116: AND pk1_value = to_char(from_bill_seq_id);
117:
118: sql_stmt_num := 3;
6111: OR (specific_copy_flag = 'Y'
6112: AND copy_attach_flag = 'Y')
6113: )
6114: THEN
6115: fnd_attached_documents2_pkg.copy_attachments
6116: (x_from_entity_name => 'BOM_BILL_OF_MATERIALS',
6117: x_from_pk1_value => x_from_sequence_id,
6118: x_from_pk2_value => '',
6119: x_from_pk3_value => '',
6150: sql_stmt_num := 85;
6151:
6152: SELECT COUNT (*)
6153: INTO copy_comts
6154: FROM fnd_attached_documents
6155: WHERE entity_name = 'BOM_BILL_OF_MATERIALS'
6156: AND pk1_value = to_sequence_id;
6157:
6158: IF (x_from_org_id = to_org_id)
11580: p_to_sequence_id IN NUMBER,
11581: p_user_id IN NUMBER)
11582: IS
11583: BEGIN
11584: fnd_attached_documents2_pkg.copy_attachments
11585: (x_from_entity_name => 'BOM_BILL_OF_MATERIALS',
11586: x_from_pk1_value => p_from_sequence_id,
11587: x_from_pk2_value => '',
11588: x_from_pk3_value => '',